View: PA_EXPENDITURE_HISTORY_V

Product:	PA - Projects
Description:	For Online Expenditure Entry Form
Implementation/DBA Data:	APPS.PA_EXPENDITURE_HISTORY_V

View Text

SELECT H.INCURRED_BY_PERSON_ID
, E.FULL_NAME EMPLOYEE_NAME
, E.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, H.EXPENDITURE_ID
, H.DENORM_ID
, H.PROJECT_ID
, P.PROJECT_NUMBER
, P.PROJECT_NAME
, H.TASK_ID
, T.TASK_NUMBER TASK_NUMBER
, T.TASK_NAME TASK_NAME
, H.EXPENDITURE_CLASS_CODE
, H.EXPENDITURE_SOURCE_CODE
, H.EXPENDITURE_TYPE
, H.SYSTEM_LINKAGE_FUNCTION
, H.EXPENDITURE_ITEM_DATE
, H.QUANTITY
, H.ATTRIBUTE_CATEGORY
, H.ATTRIBUTE1
, H.ATTRIBUTE2
, H.ATTRIBUTE3
, H.ATTRIBUTE4
, H.ATTRIBUTE5
, H.ATTRIBUTE6
, H.ATTRIBUTE7
, H.ATTRIBUTE8
, H.ATTRIBUTE9
, H.ATTRIBUTE10
, H.EXPENDITURE_ITEM_COMMENT
, H.ADJUSTED_EXPENDITURE_ITEM_ID
, H.CHANGE_CODE
, L.MEANING
, H.CREATION_DATE
, H.CREATED_BY
, H.LAST_UPDATE_DATE
, H.LAST_UPDATED_BY
, H.LAST_UPDATE_LOGIN
FROM PA_EXPENDITURE_HISTORY H
, PA_PROJECTS_EXPEND_V P
, PA_TASKS_EXPEND_V T
, PA_LOOKUPS L
, PA_EMPLOYEES E
WHERE L.LOOKUP_CODE = H.CHANGE_CODE
AND L.LOOKUP_TYPE = 'ONLINE_EXP_CHANGE_REASON'
AND H.TASK_ID = T.TASK_ID
AND H.PROJECT_ID = P.PROJECT_ID
AND TRUNC(SYSDATE) BETWEEN E.EFFECTIVE_START_DATE
AND E.EFFECTIVE_END_DATE
AND H.INCURRED_BY_PERSON_ID = E.PERSON_ID

Columns