View: PA_XLA_EXP_HEADER_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_XLA_EXP_HEADER_V

View Text

SELECT XEV.EVENT_ID
, XEV.SOURCE_ID_INT_1
, XEV.EVENT_DATE
, EI.PROJECT_ID
, EI.TASK_ID
, EI.EXPENDITURE_TYPE
, NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, E.INCURRED_BY_ORGANIZATION_ID)
, EI.ORG_ID
, E.INCURRED_BY_PERSON_ID
, EI.EXPENDITURE_ID
, E.EXPENDITURE_CLASS_CODE
, EI.EXPENDITURE_ITEM_DATE
, EI.ORIG_TRANSACTION_REFERENCE
, E.ORIG_USER_EXP_TXN_REFERENCE
, E.ORIG_EXP_TXN_REFERENCE1
, E.ORIG_EXP_TXN_REFERENCE2
, E.ORIG_EXP_TXN_REFERENCE3
, EI.INVENTORY_ITEM_ID
, EI.WIP_RESOURCE_ID
, EI.NON_LABOR_RESOURCE
, EI.ORGANIZATION_ID
, EI.SYSTEM_LINKAGE_FUNCTION
, EI.SOURCE_EXPENDITURE_ITEM_ID
, NVL(E.PERSON_TYPE
, 'EMP')
, EI.COST_JOB_ID
, EI.JOB_ID
, EI.TRANSACTION_SOURCE
, DECODE(EI.TRANSACTION_SOURCE
, 'AP ERV'
, 'Y'
, 'N')
, EI.ADJUSTED_EXPENDITURE_ITEM_ID
, EI.CC_PRVDR_ORGANIZATION_ID
, EI.OVERRIDE_TO_ORGANIZATION_ID
, EI.TP_JOB_ID
, EI.TP_AMT_TYPE_CODE
, EI.CC_CROSS_CHARGE_TYPE
, EI.LABOR_COST_MULTIPLIER_NAME
, EI.ATTRIBUTE_CATEGORY
, EI.ATTRIBUTE1
, EI.ATTRIBUTE2
, EI.ATTRIBUTE3
, EI.ATTRIBUTE4
, EI.ATTRIBUTE5
, EI.ATTRIBUTE6
, EI.ATTRIBUTE7
, EI.ATTRIBUTE8
, EI.ATTRIBUTE9
, EI.ATTRIBUTE10
, E.ATTRIBUTE_CATEGORY
, E.ATTRIBUTE1
, E.ATTRIBUTE2
, E.ATTRIBUTE3
, E.ATTRIBUTE4
, E.ATTRIBUTE5
, E.ATTRIBUTE6
, E.ATTRIBUTE7
, E.ATTRIBUTE8
, E.ATTRIBUTE9
, E.ATTRIBUTE10
, NVL(EI.PAYROLL_ACCRUAL_FLAG
, 'N')
FROM XLA_EVENTS_GT XEV
, PA_EXPENDITURE_ITEMS_ALL EI
, PA_EXPENDITURES_ALL E
WHERE XEV.APPLICATION_ID = 275
AND E.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND EI.EXPENDITURE_ITEM_ID = XEV.SOURCE_ID_INT_1

Columns