Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_PROD_HEADER_DESC_FVL |
SELECT PAH.ROWID ROW_ID
, PAH.APPLICATION_ID APPLICATION_ID
, PAH.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, PAH.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, PAH.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, PAH.ENTITY_CODE ENTITY_CODE
, PAH.EVENT_CLASS_CODE EVENT_CLASS_CODE
, PAH.EVENT_TYPE_CODE EVENT_TYPE_CODE
, PAH.DESCRIPTION_CODE HEADER_DESC_CODE
, PAH.DESCRIPTION_TYPE_CODE HEADER_DESC_TYPE_CODE
, DEL.NAME HEADER_DESC_NAME
, LKP.MEANING HEADER_DESC_TYPE_DSP
, PAH.CREATION_DATE CREATION_DATE
, PAH.CREATED_BY CREATED_BY
, PAH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PAH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PAH.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_PROD_ACCT_HEADERS PAH
, XLA_DESCRIPTIONS_TL DEL
, XLA_LOOKUPS LKP
WHERE PAH.APPLICATION_ID = DEL.APPLICATION_ID (+)
AND PAH.AMB_CONTEXT_CODE = DEL.AMB_CONTEXT_CODE (+)
AND PAH.DESCRIPTION_TYPE_CODE = DEL.DESCRIPTION_TYPE_CODE (+)
AND PAH.DESCRIPTION_CODE = DEL.DESCRIPTION_CODE (+)
AND DEL.LANGUAGE (+) = USERENV('LANG')
AND PAH.DESCRIPTION_TYPE_CODE = LKP.LOOKUP_CODE(+)
AND LKP.LOOKUP_TYPE(+) = 'XLA_OWNER_TYPE'