VIEW: APPS.PA_CAPITAL_EVENT_COSTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'