Product: | PA - Projects |
---|---|
Description: | Adjustment activity on expenditure items for a project. |
Implementation/DBA Data: | APPS.PA_PROJ_ADJUSTMENTS_VIEW |
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 )