VIEW: APPS.XLA_PAD_INQ_HEADERS_AC_FVL

Source

View Text - Preformatted

SELECT p.rowid row_id ,p.application_id application_id ,p.amb_context_code amb_context_code ,p.product_rule_code product_rule_code ,t.name product_rule_name ,p.product_rule_type_code product_rule_type_code ,l2.meaning product_rule_type_code_dsp ,b.locking_status_flag locking_status_flag ,p.event_class_code event_class_code ,c.name event_class_name ,p.event_type_code event_type_code ,e.name event_type_name ,p.description_code header_desc_code ,h.name header_desc_name ,p.description_type_code header_desc_type_code ,l1.meaning header_desc_type_dsp ,aa.analytical_criterion_code analytical_criterion_code ,aa.analytical_criterion_type_code analytical_criterion_type_code ,p.accounting_required_flag accounting_required_flag ,p.creation_date creation_date ,p.created_by created_by ,p.last_update_date last_update_date ,p.last_update_login last_update_login ,p.last_updated_by last_updated_by FROM xla_prod_acct_headers p ,xla_product_rules_b b ,xla_product_rules_tl t ,xla_event_classes_tl c ,xla_event_types_tl e ,xla_descriptions_tl h ,xla_lookups l1 ,xla_lookups l2 ,xla_aad_header_ac_assgns aa WHERE b.application_id = p.application_id AND b.product_rule_type_code = p.product_rule_type_code AND b.product_rule_code = p.product_rule_code AND b.amb_context_code = p.amb_context_code AND t.application_id = b.application_id AND t.product_rule_type_code = b.product_rule_type_code AND t.product_rule_code = b.product_rule_code AND t.amb_context_code = b.amb_context_code AND t.language = USERENV('LANG') AND p.application_id = c.application_id AND p.event_class_code = c.event_class_code AND c.language = USERENV('LANG') AND p.application_id = e.application_id AND p.event_class_code = e.event_class_code AND p.event_type_code = e.event_type_code AND e.language = USERENV('LANG') AND p.application_id = h.application_id(+) AND p.description_type_code = h.description_type_code(+) AND p.description_code = h.description_code(+) AND p.amb_context_code = h.amb_context_code(+) AND h.language(+) = USERENV('LANG') AND p.application_id = aa.application_id AND p.product_rule_type_code = aa.product_rule_type_code AND p.product_rule_code = aa.product_rule_code AND p.event_class_code = aa.event_class_code AND p.event_type_code = aa.event_type_code AND p.description_type_code = l1.lookup_code(+) AND l1.lookup_type(+) = 'XLA_OWNER_TYPE' AND t.product_rule_type_code = l2.lookup_code(+) AND l2.lookup_type(+) = 'XLA_OWNER_TYPE'

View Text - HTML Formatted

SELECT P.ROWID ROW_ID
, P.APPLICATION_ID APPLICATION_ID
, P.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, P.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, T.NAME PRODUCT_RULE_NAME
, P.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, L2.MEANING PRODUCT_RULE_TYPE_CODE_DSP
, B.LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, P.EVENT_CLASS_CODE EVENT_CLASS_CODE
, C.NAME EVENT_CLASS_NAME
, P.EVENT_TYPE_CODE EVENT_TYPE_CODE
, E.NAME EVENT_TYPE_NAME
, P.DESCRIPTION_CODE HEADER_DESC_CODE
, H.NAME HEADER_DESC_NAME
, P.DESCRIPTION_TYPE_CODE HEADER_DESC_TYPE_CODE
, L1.MEANING HEADER_DESC_TYPE_DSP
, AA.ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, AA.ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_TYPE_CODE
, P.ACCOUNTING_REQUIRED_FLAG ACCOUNTING_REQUIRED_FLAG
, P.CREATION_DATE CREATION_DATE
, P.CREATED_BY CREATED_BY
, P.LAST_UPDATE_DATE LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, P.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_PROD_ACCT_HEADERS P
, XLA_PRODUCT_RULES_B B
, XLA_PRODUCT_RULES_TL T
, XLA_EVENT_CLASSES_TL C
, XLA_EVENT_TYPES_TL E
, XLA_DESCRIPTIONS_TL H
, XLA_LOOKUPS L1
, XLA_LOOKUPS L2
, XLA_AAD_HEADER_AC_ASSGNS AA
WHERE B.APPLICATION_ID = P.APPLICATION_ID
AND B.PRODUCT_RULE_TYPE_CODE = P.PRODUCT_RULE_TYPE_CODE
AND B.PRODUCT_RULE_CODE = P.PRODUCT_RULE_CODE
AND B.AMB_CONTEXT_CODE = P.AMB_CONTEXT_CODE
AND T.APPLICATION_ID = B.APPLICATION_ID
AND T.PRODUCT_RULE_TYPE_CODE = B.PRODUCT_RULE_TYPE_CODE
AND T.PRODUCT_RULE_CODE = B.PRODUCT_RULE_CODE
AND T.AMB_CONTEXT_CODE = B.AMB_CONTEXT_CODE
AND T.LANGUAGE = USERENV('LANG')
AND P.APPLICATION_ID = C.APPLICATION_ID
AND P.EVENT_CLASS_CODE = C.EVENT_CLASS_CODE
AND C.LANGUAGE = USERENV('LANG')
AND P.APPLICATION_ID = E.APPLICATION_ID
AND P.EVENT_CLASS_CODE = E.EVENT_CLASS_CODE
AND P.EVENT_TYPE_CODE = E.EVENT_TYPE_CODE
AND E.LANGUAGE = USERENV('LANG')
AND P.APPLICATION_ID = H.APPLICATION_ID(+)
AND P.DESCRIPTION_TYPE_CODE = H.DESCRIPTION_TYPE_CODE(+)
AND P.DESCRIPTION_CODE = H.DESCRIPTION_CODE(+)
AND P.AMB_CONTEXT_CODE = H.AMB_CONTEXT_CODE(+)
AND H.LANGUAGE(+) = USERENV('LANG')
AND P.APPLICATION_ID = AA.APPLICATION_ID
AND P.PRODUCT_RULE_TYPE_CODE = AA.PRODUCT_RULE_TYPE_CODE
AND P.PRODUCT_RULE_CODE = AA.PRODUCT_RULE_CODE
AND P.EVENT_CLASS_CODE = AA.EVENT_CLASS_CODE
AND P.EVENT_TYPE_CODE = AA.EVENT_TYPE_CODE
AND P.DESCRIPTION_TYPE_CODE = L1.LOOKUP_CODE(+)
AND L1.LOOKUP_TYPE(+) = 'XLA_OWNER_TYPE'
AND T.PRODUCT_RULE_TYPE_CODE = L2.LOOKUP_CODE(+)
AND L2.LOOKUP_TYPE(+) = 'XLA_OWNER_TYPE'