VIEW: APPS.PA_PROJ_ADJUSTMENTS_VIEW

Source

View Text - Preformatted

SELECT exp.project_id, exp.project_num, exp.project_name, exp.expenditure_item_id, exp.incurred_by_employee_name, exp.incurred_by_employee_num, exp.incurred_by_person_id, exp.vendor_id, exp.vendor_num, exp.vendor_name, exp.employee_vendor_name, exp.employee_vendor_num, exp.incurred_by_organization_id, exp.incurred_by_organization_name, exp.expenditure_type, exp.task_id, exp.task_number, exp.task_name, exp.expenditure_item_date, exp.non_labor_resource, to_char(eia.activity_date,'DD-MON-RR hh:mi:ss'), eia.exception_activity_code, fnd.user_name, eia.created_by, per.person_id, per.full_name FROM pa_proj_expend_view exp, pa_expend_item_adj_activities eia, per_people_f per, fnd_user fnd WHERE exp.expenditure_item_id = eia.expenditure_item_id AND eia.created_by = fnd.user_id AND fnd.employee_id = per.person_id AND trunc(sysdate) between per.effective_start_date and per.effective_end_date AND ( PER.EMPLOYEE_NUMBER IS NOT NULL OR PER.NPW_NUMBER IS NOT NULL )

View Text - HTML Formatted

SELECT EXP.PROJECT_ID
, EXP.PROJECT_NUM
, EXP.PROJECT_NAME
, EXP.EXPENDITURE_ITEM_ID
, EXP.INCURRED_BY_EMPLOYEE_NAME
, EXP.INCURRED_BY_EMPLOYEE_NUM
, EXP.INCURRED_BY_PERSON_ID
, EXP.VENDOR_ID
, EXP.VENDOR_NUM
, EXP.VENDOR_NAME
, EXP.EMPLOYEE_VENDOR_NAME
, EXP.EMPLOYEE_VENDOR_NUM
, EXP.INCURRED_BY_ORGANIZATION_ID
, EXP.INCURRED_BY_ORGANIZATION_NAME
, EXP.EXPENDITURE_TYPE
, EXP.TASK_ID
, EXP.TASK_NUMBER
, EXP.TASK_NAME
, EXP.EXPENDITURE_ITEM_DATE
, EXP.NON_LABOR_RESOURCE
, TO_CHAR(EIA.ACTIVITY_DATE
, 'DD-MON-RR HH:MI:SS')
, EIA.EXCEPTION_ACTIVITY_CODE
, FND.USER_NAME
, EIA.CREATED_BY
, PER.PERSON_ID
, PER.FULL_NAME
FROM PA_PROJ_EXPEND_VIEW EXP
, PA_EXPEND_ITEM_ADJ_ACTIVITIES EIA
, PER_PEOPLE_F PER
, FND_USER FND
WHERE EXP.EXPENDITURE_ITEM_ID = EIA.EXPENDITURE_ITEM_ID
AND EIA.CREATED_BY = FND.USER_ID
AND FND.EMPLOYEE_ID = PER.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND ( PER.EMPLOYEE_NUMBER IS NOT NULL OR PER.NPW_NUMBER IS NOT NULL )