Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_AAD_LINE_DEFN_ASSGNS_F_V |
SELECT XAL.ROWID ROW_ID
, XAL.AMB_CONTEXT_CODE
, XAL.APPLICATION_ID
, XAL.EVENT_CLASS_CODE
, XAL.EVENT_TYPE_CODE
, XAL.PRODUCT_RULE_TYPE_CODE
, XAL.PRODUCT_RULE_CODE
, XAL.LINE_DEFINITION_CODE
, XAL.LINE_DEFINITION_OWNER_CODE
, XLA.NAME LINE_DEFINITION_NAME
, LK.MEANING LINE_DEFINITION_OWNER
, XLA.DESCRIPTION LINE_DEFINITION_DESC
, XAL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, XAL.CREATION_DATE CREATION_DATE
, XAL.CREATED_BY CREATED_BY
, XAL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XAL.LAST_UPDATED_BY LAST_UPDATED_BY
, XAL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_AAD_LINE_DEFN_ASSGNS XAL
, XLA_LINE_DEFINITIONS_TL XLA
, XLA_LOOKUPS LK
WHERE LK.LOOKUP_CODE = XAL.LINE_DEFINITION_OWNER_CODE
AND LK.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND XLA.LINE_DEFINITION_OWNER_CODE = XAL.LINE_DEFINITION_OWNER_CODE
AND XLA.LINE_DEFINITION_CODE = XAL.LINE_DEFINITION_CODE
AND XLA.EVENT_CLASS_CODE = XAL.EVENT_CLASS_CODE
AND XLA.EVENT_TYPE_CODE = XAL.EVENT_TYPE_CODE
AND XLA.APPLICATION_ID = XAL.APPLICATION_ID
AND XLA.AMB_CONTEXT_CODE = XAL.AMB_CONTEXT_CODE
AND XLA.LANGUAGE = USERENV('LANG')