View: PA_CAPITAL_EVENT_COSTS_V

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

View Text

SELECT EI.EXPENDITURE_ITEM_ID
, EI.CAPITAL_EVENT_ID
, EI.PROJECT_ID
, EI.TASK_ID
, T.TASK_NUMBER
, EI.EXPENDITURE_TYPE
, EI.TRANSACTION_SOURCE
, TR.USER_TRANSACTION_SOURCE
, X.INCURRED_BY_PERSON_ID
, (SELECT P.FULL_NAME
FROM PER_ALL_PEOPLE_F P
WHERE (P.EMPLOYEE_NUMBER IS NOT NULL OR P.NPW_NUMBER IS NOT NULL)
AND P.PERSON_ID = X.INCURRED_BY_PERSON_ID
AND EI.EXPENDITURE_ITEM_DATE BETWEEN P.EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE) EMPLOYEE_NAME
, X.VENDOR_ID
, (SELECT VENDOR_NAME
FROM PO_VENDORS
WHERE VENDOR_ID = X.VENDOR_ID) VENDOR_NAME
, EI.RAW_COST
, EI.BURDEN_COST
, EI.EXPENDITURE_ITEM_DATE
, EI.BILLABLE_FLAG BILLABLE_CAPITALIZABLE_FLAG
, X.ORG_ID
FROM PA_EXPENDITURE_ITEMS_ALL EI
, PA_TRANSACTION_SOURCES TR
, PA_TASKS T
, PA_EXPENDITURES_ALL X
WHERE EI.TRANSACTION_SOURCE = TR.TRANSACTION_SOURCE (+)
AND EI.TASK_ID = T.TASK_ID
AND X.EXPENDITURE_ID = EI.EXPENDITURE_ID
AND NVL(EI.NET_ZERO_ADJUSTMENT_FLAG
, 'N') = 'N'

Columns