VIEW: APPS.PA_EXPENDITURE_HISTORY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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