Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_LINE_DEFN_JLT_ASSGNS_F_V |
SELECT XLD.ROWID ROW_ID
, XLD.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XLD.APPLICATION_ID APPLICATION_ID
, XLD.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XLD.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XLD.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XLD.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XAL.NAME ACCOUNTING_LINE_NAME
, LK.MEANING ACCOUNTING_LINE_OWNER
, XLD.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XLD.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XLD.INHERIT_DESC_FLAG INHERIT_DESC_FLAG
, XDT.NAME DESCRIPTION_NAME
, LK2.MEANING DESCRIPTION_OWNER
, XLD.DESCRIPTION_CODE DESCRIPTION_CODE
, XLD.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE
, XLD.ACTIVE_FLAG ACTIVE_FLAG
, XLD.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, XALT.NATURAL_SIDE_CODE NATURAL_SIDE_CODE
, XLD.MPA_NUM_JE_CODE MPA_NUM_JE_CODE
, XLD.MPA_GL_DATES_CODE MPA_GL_DATES_CODE
, XLD.MPA_PRORATION_CODE MPA_PRORATION_CODE
, XLD.MPA_HEADER_DESC_CODE MPA_HEADER_DESC_CODE
, XALT.MPA_OPTION_CODE MPA_OPTION_CODE
, XDT2.NAME MPA_HEADER_DESC_NAME
, XLD.MPA_HEADER_DESC_TYPE_CODE MPA_HEADER_DESC_TYPE_CODE
, LK3.MEANING MPA_HEADER_DESC_OWNER
, XLD.CREATION_DATE CREATION_DATE
, XLD.CREATED_BY CREATED_BY
, XLD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XLD.LAST_UPDATED_BY LAST_UPDATED_BY
, XLD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM XLA_LINE_DEFN_JLT_ASSGNS XLD
, XLA_ACCT_LINE_TYPES_TL XAL
, XLA_ACCT_LINE_TYPES_B XALT
, XLA_DESCRIPTIONS_TL XDT
, XLA_LOOKUPS LK
, XLA_LOOKUPS LK2
, XLA_LOOKUPS LK3
, XLA_DESCRIPTIONS_TL XDT2
WHERE LK.LOOKUP_CODE = XLD.ACCOUNTING_LINE_TYPE_CODE AND LK.LOOKUP_TYPE = 'XLA_OWNER_TYPE' AND LK2.LOOKUP_CODE(+) = XLD.DESCRIPTION_TYPE_CODE AND LK2.LOOKUP_TYPE(+) = 'XLA_OWNER_TYPE'
AND LK3.LOOKUP_CODE(+) = XLD.MPA_HEADER_DESC_TYPE_CODE
AND LK3.LOOKUP_TYPE(+) = 'XLA_OWNER_TYPE' AND XDT.LANGUAGE(+) = USERENV('LANG') AND XDT.DESCRIPTION_TYPE_CODE(+) = XLD.DESCRIPTION_TYPE_CODE AND XDT.DESCRIPTION_CODE(+) = XLD.DESCRIPTION_CODE AND XDT.APPLICATION_ID(+) = XLD.APPLICATION_ID AND XDT.AMB_CONTEXT_CODE(+) = XLD.AMB_CONTEXT_CODE AND XDT2.LANGUAGE(+) = USERENV('LANG') AND XDT2.DESCRIPTION_TYPE_CODE(+) = XLD.MPA_HEADER_DESC_TYPE_CODE AND XDT2.DESCRIPTION_CODE(+) = XLD.MPA_HEADER_DESC_CODE AND XDT2.APPLICATION_ID(+) = XLD.APPLICATION_ID AND XDT2.AMB_CONTEXT_CODE(+) = XLD.AMB_CONTEXT_CODE AND XAL.LANGUAGE = USERENV('LANG') AND XAL.ACCOUNTING_LINE_TYPE_CODE = XLD.ACCOUNTING_LINE_TYPE_CODE AND XAL.ACCOUNTING_LINE_CODE = XLD.ACCOUNTING_LINE_CODE AND XAL.EVENT_CLASS_CODE = XLD.EVENT_CLASS_CODE AND XAL.APPLICATION_ID = XLD.APPLICATION_ID AND XAL.AMB_CONTEXT_CODE = XLD.AMB_CONTEXT_CODE AND XALT.ACCOUNTING_LINE_TYPE_CODE = XLD.ACCOUNTING_LINE_TYPE_CODE AND XALT.ACCOUNTING_LINE_CODE = XLD.ACCOUNTING_LINE_CODE AND XALT.EVENT_CLASS_CODE = XLD.EVENT_CLASS_CODE AND XALT.APPLICATION_ID = XLD.APPLICATION_ID AND XALT.AMB_CONTEXT_CODE = XLD.AMB_CONTEXT_CODE