View: XLA_PAD_INQ_HEADERS_FVL

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_PAD_INQ_HEADERS_FVL

View Text

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.ENTITY_CODE ENTITY_CODE
, 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
, P.ACCOUNTING_REQUIRED_FLAG ACCOUNTING_REQUIRED_FLAG
, NULL ANALYTICAL_CRITERION_CODE
, NULL ANALYTICAL_CRITERION_TYPE_CODE
, 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
WHERE B.APPLICATION_ID = P.APPLICATION_ID
AND B.AMB_CONTEXT_CODE = P.AMB_CONTEXT_CODE
AND B.PRODUCT_RULE_TYPE_CODE = P.PRODUCT_RULE_TYPE_CODE
AND B.PRODUCT_RULE_CODE = P.PRODUCT_RULE_CODE
AND T.APPLICATION_ID = B.APPLICATION_ID
AND T.AMB_CONTEXT_CODE = B.AMB_CONTEXT_CODE
AND T.PRODUCT_RULE_TYPE_CODE = B.PRODUCT_RULE_TYPE_CODE
AND T.PRODUCT_RULE_CODE = B.PRODUCT_RULE_CODE
AND T.LANGUAGE = USERENV('LANG')
AND P.APPLICATION_ID = C.APPLICATION_ID
AND P.ENTITY_CODE = C.ENTITY_CODE
AND P.EVENT_CLASS_CODE = C.EVENT_CLASS_CODE
AND C.LANGUAGE = USERENV('LANG')
AND P.APPLICATION_ID = E.APPLICATION_ID
AND P.ENTITY_CODE = E.ENTITY_CODE
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.AMB_CONTEXT_CODE = H.AMB_CONTEXT_CODE
AND P.DESCRIPTION_TYPE_CODE = H.DESCRIPTION_TYPE_CODE
AND P.DESCRIPTION_CODE = H.DESCRIPTION_CODE
AND H.LANGUAGE = USERENV('LANG')
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'

Columns