Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_AAD_HEADER_AC_ASSGNS_F_V |
SELECT XAH.ROWID ROW_ID
, XAH.APPLICATION_ID APPLICATION_ID
, XAH.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XAH.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XAH.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAH.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XAH.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XAH.ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, XAH.ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_TYPE_CODE
, XAT.NAME ANALYTICAL_CRITERION_NAME
, XLK.MEANING ANALYTICAL_CRITERION_TYPE_DSP
, XAT.DESCRIPTION ANALYTICAL_CRITERION_DESC
, XAB.DISPLAY_ORDER DISPLAY_ORDER
, XAH.CREATION_DATE CREATION_DATE
, XAH.CREATED_BY CREATED_BY
, XAH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XAH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, XAH.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_AAD_HEADER_AC_ASSGNS XAH
, XLA_ANALYTICAL_HDRS_B XAB
, XLA_ANALYTICAL_HDRS_TL XAT
, XLA_LOOKUPS XLK
WHERE XAT.ANALYTICAL_CRITERION_TYPE_CODE = XAB.ANALYTICAL_CRITERION_TYPE_CODE
AND XAT.ANALYTICAL_CRITERION_CODE = XAB.ANALYTICAL_CRITERION_CODE
AND XAT.AMB_CONTEXT_CODE = XAB.AMB_CONTEXT_CODE
AND XAT.LANGUAGE = USERENV('LANG')
AND XAB.AMB_CONTEXT_CODE = XAH.AMB_CONTEXT_CODE
AND XAB.ANALYTICAL_CRITERION_TYPE_CODE = XAH.ANALYTICAL_CRITERION_TYPE_CODE
AND XAB.ANALYTICAL_CRITERION_CODE = XAH.ANALYTICAL_CRITERION_CODE
AND XLK.LOOKUP_CODE = XAB.ANALYTICAL_CRITERION_TYPE_CODE
AND XLK.LOOKUP_TYPE = 'XLA_OWNER_TYPE'