Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_ANALYTICAL_ASSGNS_FVL |
SELECT P.ROWID ROW_ID
, P.ANALYTICAL_ASSIGNMENT_ID ANALYTICAL_ASSIGNMENT_ID
, P.APPLICATION_ID APPLICATION_ID
, P.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, P.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, P.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, P.ENTITY_CODE ENTITY_CODE
, P.EVENT_CLASS_CODE EVENT_CLASS_CODE
, P.EVENT_TYPE_CODE EVENT_TYPE_CODE
, P.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, P.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, P.ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, L.NAME ANALYTICAL_CRITERIA_NAME
, L.DESCRIPTION ANALYTICAL_CRITERIA_DESC
, L.DISPLAY_ORDER DISPLAY_ORDER
, P.ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_TYPE_CODE
, K.MEANING ANALYTICAL_CRITERIA_TYPE_DSP
, P.CREATION_DATE CREATION_DATE
, P.CREATED_BY CREATED_BY
, P.LAST_UPDATE_DATE LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, P.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_ANALYTICAL_ASSGNS P
, XLA_ANALYTICAL_HDRS_VL L
, XLA_LOOKUPS K
WHERE P.ANALYTICAL_CRITERION_TYPE_CODE = L.ANALYTICAL_CRITERION_TYPE_CODE
AND P.ANALYTICAL_CRITERION_CODE = L.ANALYTICAL_CRITERION_CODE
AND P.AMB_CONTEXT_CODE = L.AMB_CONTEXT_CODE
AND P.ANALYTICAL_CRITERION_TYPE_CODE = K.LOOKUP_CODE
AND K.LOOKUP_TYPE = 'XLA_OWNER_TYPE'