View: XLA_MPA_HEADER_AC_ASSGNS_F_V

Product:	XLA - Subledger Accounting
Description:	Internal form view for the xla_mpa_header_ac_assgns table.
Implementation/DBA Data:	APPS.XLA_MPA_HEADER_AC_ASSGNS_F_V

View Text

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

Columns