EBS SLA Queries

Oracle EBS queries to extract SLA( Sub Ledger Accounting ) setup

AAD

SELECT APPLICATION_ID,
         AMB_CONTEXT_CODE,
         APPLICATION_NAME,
         PRODUCT_RULE_TYPE_CODE,
         PRODUCT_RULE_TYPE_DSP,
         PRODUCT_RULE_CODE,
         NAME,
         DESCRIPTION,
         TRANSACTION_COA_NAME,
         ACCOUNTING_COA_NAME,
         PRODUCT_RULE_VERSION,
         COMPILE_STATUS_CODE,
         ENABLED_FLAG,
         COMPILE_STATUS_DSP
    FROM apps.xla_product_rules_fvl aad
   WHERE enabled_flag = ‘Y’
ORDER BY application_id,
         amb_context_code,
         product_rule_type_code,
         product_rule_code;

  SELECT APPLICATION_ID,
         AMB_CONTEXT_CODE,
         PRODUCT_RULE_CODE,
         PRODUCT_RULE_TYPE_CODE,
         ENTITY_CODE,
         EVENT_CLASS_CODE,
         EVENT_TYPE_CODE,
         EVENT_CLASS_NAME,
         EVENT_TYPE_NAME,
         ACCOUNTING_REQUIRED_FLAG,
         LOCKING_STATUS_FLAG,
         VALIDATION_STATUS_CODE,
         VALIDATION_STATUS_DSP
    FROM apps.xla_prod_acct_headers_fvl
ORDER BY application_id,
         amb_context_code,
         product_rule_type_code,
         product_rule_code,
         entity_code,
         event_class_code,
         event_type_code;

JLD

 SELECT AMB_CONTEXT_CODE,
         APPLICATION_ID,
         EVENT_CLASS_CODE,
         EVENT_TYPE_CODE,
         PRODUCT_RULE_TYPE_CODE,
         PRODUCT_RULE_CODE,
         LINE_DEFINITION_CODE,
         LINE_DEFINITION_OWNER_CODE,
         LINE_DEFINITION_NAME,
         LINE_DEFINITION_OWNER,
         LINE_DEFINITION_DESC
    FROM apps.xla_aad_line_defn_assgns_f_v jld
ORDER BY application_id,
         amb_context_code,
         event_class_code,
         event_type_code,
         product_rule_type_code,
         product_rule_code,
         line_definition_owner_code,
         line_definition_code;

  SELECT AMB_CONTEXT_CODE,
         APPLICATION_ID,
         EVENT_CLASS_CODE,
         EVENT_TYPE_CODE,
         LINE_DEFINITION_OWNER_CODE,
         LINE_DEFINITION_CODE,
         ACCOUNTING_LINE_NAME,
         ACCOUNTING_LINE_OWNER,
         ACCOUNTING_LINE_CODE,
         ACCOUNTING_LINE_TYPE_CODE,
         INHERIT_DESC_FLAG,
         DESCRIPTION_NAME,
         DESCRIPTION_OWNER,
         DESCRIPTION_CODE,
         DESCRIPTION_TYPE_CODE,
         ACTIVE_FLAG,
         NATURAL_SIDE_CODE,
         MPA_NUM_JE_CODE,
         MPA_GL_DATES_CODE,
         MPA_PRORATION_CODE,
         MPA_HEADER_DESC_CODE,
         MPA_OPTION_CODE,
         MPA_HEADER_DESC_NAME,
         MPA_HEADER_DESC_TYPE_CODE,
         MPA_HEADER_DESC_OWNER
    FROM apps.xla_line_defn_jlt_assgns_f_v jlda
ORDER BY application_id,
         amb_context_code,
         event_class_code,
         event_type_code,
         line_definition_owner_code,
         line_definition_code,
         accounting_line_type_code,
         accounting_line_code;

ADR

  SELECT AMB_CONTEXT_CODE,
         APPLICATION_ID,
         EVENT_CLASS_CODE,
         EVENT_TYPE_CODE,
         LINE_DEFINITION_OWNER_CODE,
         LINE_DEFINITION_CODE,
         ACCOUNTING_LINE_CODE,
         ACCOUNTING_LINE_TYPE_CODE,
         SIDE_CODE,
         SIDE_CODE_DSP,
         FLEXFIELD_SEGMENT_CODE,
         FLEXFIELD_SEGMENT_NAME,
         FLEXFIELD_SEGMENT_NUM,
         INHERIT_ADR_FLAG,
         SEGMENT_RULE_NAME,
         SEGMENT_RULE_APPL_ID,
         SEGMENT_RULE_CODE,
         SEGMENT_RULE_OWNER,
         SEGMENT_RULE_TYPE_CODE,
         SEGMENT_RULE_DESC
    FROM apps.xla_line_defn_adr_assgns_f_v adra
ORDER BY application_id,
         amb_context_code,
         event_class_code,
         event_type_code,
         line_definition_owner_code,
         line_definition_code,
         accounting_line_type_code,
         accounting_line_code,
         flexfield_segment_code,
         side_code;

  SELECT APPLICATION_ID,
         AMB_CONTEXT_CODE,
         APPLICATION_NAME,
         SEGMENT_RULE_TYPE_CODE,
         SEGMENT_RULE_TYPE_DSP,
         SEGMENT_RULE_CODE,
         NAME,
         DESCRIPTION,
         TRANSACTION_COA_NAME,
         ACCOUNTING_COA_NAME,
         FLEXFIELD_SEGMENT_CODE,
         FLEXFIELD_SEGMENT_NAME,
         FLEXFIELD_ASSIGN_MODE_CODE,
         ENABLED_FLAG,
         FLEX_VALUE_SET_NAME
    FROM apps.xla_seg_rules_fvl adr
ORDER BY APPLICATION_ID,
         AMB_CONTEXT_CODE,
         SEGMENT_RULE_TYPE_CODE,
         SEGMENT_RULE_CODE;

  SELECT APPLICATION_ID,
         AMB_CONTEXT_CODE,
         SEGMENT_RULE_TYPE_CODE,
         SEGMENT_RULE_CODE,
         USER_SEQUENCE,
         VALUE_TYPE_CODE,
         VALUE_SOURCE_TYPE_CODE,
         VALUE_SOURCE_CODE,
         VALUE_CONSTANT,
         VALUE_MAPPING_SET_CODE,
         VALUE_FLEXFIELD_SEGMENT_CODE,
         INPUT_SOURCE_TYPE_CODE,
         INPUT_SOURCE_CODE,
         VALUE_SEGMENT_RULE_TYPE_CODE,
         VALUE_SEGMENT_RULE_CODE
    FROM apps.xla_seg_rule_details adrd
ORDER BY APPLICATION_ID,
         AMB_CONTEXT_CODE,
         SEGMENT_RULE_TYPE_CODE,
         SEGMENT_RULE_CODE,
         USER_SEQUENCE;

  SELECT USER_SEQUENCE,
         APPLICATION_ID,
         AMB_CONTEXT_CODE,
         ENTITY_CODE,
         EVENT_CLASS_CODE,
         ACCOUNTING_LINE_TYPE_CODE,
         ACCOUNTING_LINE_CODE,
         BRACKET_LEFT_CODE,
         BRACKET_RIGHT_CODE,
         VALUE_TYPE_CODE,
         SOURCE_TYPE_CODE,
         SOURCE_CODE,
         FLEXFIELD_SEGMENT_CODE,
         VALUE_FLEXFIELD_SEGMENT_CODE,
         VALUE_SOURCE_TYPE_CODE,
         VALUE_SOURCE_CODE,
         VALUE_CONSTANT,
         LINE_OPERATOR_CODE,
         LOGICAL_OPERATOR_CODE,
         INDEPENDENT_VALUE_CONSTANT
    FROM apps.xla_conditions cond
ORDER BY APPLICATION_ID,
         ENTITY_CODE,
         EVENT_CLASS_CODE,
         AMB_CONTEXT_CODE,
         ACCOUNTING_LINE_TYPE_CODE,
         ACCOUNTING_LINE_CODE,
         SEGMENT_RULE_DETAIL_ID,
         DESCRIPTION_PRIO_ID,
         USER_SEQUENCE;