Product: | XLA - Subledger Accounting |
---|---|
Description: | Internal form view for the xla_mpa_jlt_ac_assgns table |
Implementation/DBA Data: | APPS.XLA_MPA_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
, XLD.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, XLD.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, XAL.NAME MPA_ACCOUNTING_LINE_NAME
, LK.MEANING MPA_ACCOUNTING_LINE_OWNER
, XLD.MPA_ACCOUNTING_LINE_CODE MPA_ACCOUNTING_LINE_CODE
, XLD.MPA_ACCOUNTING_LINE_TYPE_CODE MPA_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.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, XALT.NATURAL_SIDE_CODE NATURAL_SIDE_CODE
, DECODE(XLD.MPA_ACCOUNTING_LINE_CODE
, XLD.ACCOUNTING_LINE_CODE
, 1
, 2) DISPLAY_ORDER
, 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_MPA_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
WHERE LK.LOOKUP_CODE = XLD.MPA_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 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 XAL.LANGUAGE = USERENV('LANG')
AND XAL.ACCOUNTING_LINE_TYPE_CODE = XLD.MPA_ACCOUNTING_LINE_TYPE_CODE
AND XAL.ACCOUNTING_LINE_CODE = XLD.MPA_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.MPA_ACCOUNTING_LINE_TYPE_CODE
AND XALT.ACCOUNTING_LINE_CODE = XLD.MPA_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