Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_LINE_DEFN_AC_ASSGNS_F_V |
SELECT XLD.ROWID ROW_ID
, XLD.AMB_CONTEXT_CODE
, XLD.APPLICATION_ID
, XLD.EVENT_CLASS_CODE
, XLD.EVENT_TYPE_CODE
, XLD.LINE_DEFINITION_OWNER_CODE
, XLD.LINE_DEFINITION_CODE
, XLD.ACCOUNTING_LINE_CODE
, XLD.ACCOUNTING_LINE_TYPE_CODE
, XLD.ANALYTICAL_CRITERION_CODE
, XLD.ANALYTICAL_CRITERION_TYPE_CODE
, XAT.NAME ANALYTICAL_CRITERION_NAME
, LK.MEANING ANALYTICAL_CRITERION_OWNER
, XAT.DESCRIPTION ANALYTICAL_CRITERION_DESC
, XAB.DISPLAY_ORDER
, XLD.OBJECT_VERSION_NUMBER
, XLD.CREATION_DATE
, XLD.CREATED_BY
, XLD.LAST_UPDATE_DATE
, XLD.LAST_UPDATED_BY
, XLD.LAST_UPDATE_LOGIN FROM XLA_LINE_DEFN_AC_ASSGNS XLD
, XLA_ANALYTICAL_HDRS_B XAB
, XLA_ANALYTICAL_HDRS_TL XAT
, XLA_LOOKUPS LK
WHERE LK.LOOKUP_TYPE = 'XLA_OWNER_TYPE' AND LK.LOOKUP_CODE = XLD.ANALYTICAL_CRITERION_TYPE_CODE AND XAT.LANGUAGE = USERENV('LANG') AND 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 XAB.ANALYTICAL_CRITERION_TYPE_CODE =XLD.ANALYTICAL_CRITERION_TYPE_CODE AND XAB.ANALYTICAL_CRITERION_CODE = XLD.ANALYTICAL_CRITERION_CODE AND XAB.AMB_CONTEXT_CODE = XLD.AMB_CONTEXT_CODE