VIEW: APPS.XLA_MPA_JLT_ASSGNS_F_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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