Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_AAD_HDR_ACCT_ATTRS_FVL |
SELECT AHA.ROWID ROW_ID
, AHA.APPLICATION_ID APPLICATION_ID
, AHA.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, AHA.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, AHA.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, AHA.EVENT_CLASS_CODE EVENT_CLASS_CODE
, AHA.EVENT_TYPE_CODE EVENT_TYPE_CODE
, AHA.SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, AHA.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, AHA.SOURCE_CODE SOURCE_CODE
, AAL.ACCOUNTING_ATTRIBUTE_CODE ACCOUNTING_ATTRIBUTE_CODE
, AHA.EVENT_CLASS_DEFAULT_FLAG EVENT_CLASS_DEFAULT_FLAG
, AAL.NAME ACCOUNTING_ATTRIBUTE_NAME
, AAL.JOURNAL_ENTRY_LEVEL_CODE JOURNAL_ENTRY_LEVEL_CODE
, SOU.NAME SOURCE_NAME
, LKP1.MEANING SOURCE_TYPE_DSP
, AAL.ASSIGNMENT_GROUP_CODE ASSIGNMENT_GROUP_CODE
, LKP2.MEANING ASSIGNMENT_GROUP_NAME
, AAL.ASSIGNMENT_REQUIRED_CODE ASSIGNMENT_REQUIRED_CODE
, AAL.ASSIGNMENT_LEVEL_CODE ASSIGNMENT_LEVEL_CODE
, AAL.DATATYPE_CODE DATATYPE_CODE
, AHA.CREATION_DATE CREATION_DATE
, AHA.CREATED_BY CREATED_BY
, AHA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AHA.LAST_UPDATED_BY LAST_UPDATED_BY
, AHA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_AAD_HDR_ACCT_ATTRS AHA
, XLA_SOURCES_TL SOU
, XLA_ACCT_ATTRIBUTES_VL AAL
, XLA_LOOKUPS LKP1
, XLA_LOOKUPS LKP2
WHERE AHA.SOURCE_APPLICATION_ID = SOU.APPLICATION_ID (+)
AND AHA.SOURCE_CODE = SOU.SOURCE_CODE (+)
AND AHA.SOURCE_TYPE_CODE = SOU.SOURCE_TYPE_CODE (+)
AND SOU.LANGUAGE (+) = USERENV('LANG')
AND AHA.ACCOUNTING_ATTRIBUTE_CODE = AAL.ACCOUNTING_ATTRIBUTE_CODE
AND AHA.SOURCE_TYPE_CODE = LKP1.LOOKUP_CODE (+)
AND LKP1.LOOKUP_TYPE (+) = 'XLA_SOURCE_TYPE'
AND AAL.ASSIGNMENT_GROUP_CODE = LKP2.LOOKUP_CODE (+)
AND LKP2.LOOKUP_TYPE (+) = 'XLA_ACCT_ATTR_ASSGN_GROUP'