VIEW: APPS.XLA_MPA_HEADER_AC_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 , xld.analytical_criterion_code analytical_criterion_code , xld.analytical_criterion_type_code analytical_criterion_type_code , xat.name analytical_criterion_name , lk.meaning analytical_criterion_owner , xat.description analytical_criterion_desc , xab.display_order display_order , xld.object_version_number object_version_number , 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_header_ac_assgns xld , xla_analytical_hdrs_b xab , xla_analytical_hdrs_tl xat , xla_lookups lk WHERE lk.lookup_code = xld.analytical_criterion_type_code AND lk.lookup_type = 'XLA_OWNER_TYPE' AND xat.language = USERENV('LANG') AND xat.analytical_criterion_type_code = xab.analytical_criterion_type_code AND xat.analytical_criterion_code = xab.analytical_criterion_code AND xat.amb_context_code = xab.amb_context_code AND xab.analytical_criterion_type_code = xld.analytical_criterion_type_code AND xab.analytical_criterion_code = xld.analytical_criterion_code AND xab.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
, XLD.ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, XLD.ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_TYPE_CODE
, XAT.NAME ANALYTICAL_CRITERION_NAME
, LK.MEANING ANALYTICAL_CRITERION_OWNER
, XAT.DESCRIPTION ANALYTICAL_CRITERION_DESC
, XAB.DISPLAY_ORDER DISPLAY_ORDER
, XLD.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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_HEADER_AC_ASSGNS XLD
, XLA_ANALYTICAL_HDRS_B XAB
, XLA_ANALYTICAL_HDRS_TL XAT
, XLA_LOOKUPS LK
WHERE LK.LOOKUP_CODE = XLD.ANALYTICAL_CRITERION_TYPE_CODE
AND LK.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND XAT.LANGUAGE = USERENV('LANG')
AND XAT.ANALYTICAL_CRITERION_TYPE_CODE = XAB.ANALYTICAL_CRITERION_TYPE_CODE
AND XAT.ANALYTICAL_CRITERION_CODE = XAB.ANALYTICAL_CRITERION_CODE
AND XAT.AMB_CONTEXT_CODE = XAB.AMB_CONTEXT_CODE
AND XAB.ANALYTICAL_CRITERION_TYPE_CODE = XLD.ANALYTICAL_CRITERION_TYPE_CODE
AND XAB.ANALYTICAL_CRITERION_CODE = XLD.ANALYTICAL_CRITERION_CODE
AND XAB.AMB_CONTEXT_CODE = XLD.AMB_CONTEXT_CODE