View: PA_SST_VIEW_TIMECARD_HISTORY_V

Product:	PA - Projects
Description:	View of Submitted and Approved timecards. Used in View Timecard History function of Self Service Time.
Implementation/DBA Data:	APPS.PA_SST_VIEW_TIMECARD_HISTORY_V

View Text

SELECT EXP.EXPENDITURE_ID
, EXP.ORIG_USER_EXP_TXN_REFERENCE
, EXP.EXPENDITURE_GROUP
, LOOKUP.MEANING
, EXP.EXPENDITURE_ENDING_DATE
, PER.FULL_NAME
, EXP.INCURRED_BY_PERSON_ID
, EXP.INCURRED_BY_ORGANIZATION_ID
, EXP.INITIAL_SUBMISSION_DATE
, EXP.DESCRIPTION
, EXP.ENTERED_BY_PERSON_ID
, EXP.OVERRIDING_APPROVER_PERSON_ID
, SUM(NVL(DEN.QUANTITY_1
, 0)+NVL(DEN.QUANTITY_2
, 0)+NVL(DEN.QUANTITY_3
, 0)+NVL(DEN.QUANTITY_4
, 0)+ NVL(DEN.QUANTITY_5
, 0)+NVL(QUANTITY_6
, 0)+NVL(QUANTITY_7
, 0))
, 'JAVASCRIPT:VOID WINDOW.OPEN('||''''||'[PLSQL_AGENT]PA_SELF_SERVICE_INQUIRIES_PVT.OPENWINDOWFROMINQUIRY?P_EXPENDITURE_ID='||EXP.EXPENDITURE_ID ||'&' ||'P_ACTION_CODE=HISTORY_VIEW'||''''||'
, '||''''||'WINMAIN'||''''||'
, '||''''||'STATUS=YES
, RESIZABLE=YES
, SCROLLBARS=YES
, MENUBAR=NO
, TOOLBAR=NO'||''''||')'
, ''
, 'JAVASCRIPT:VOID WINDOW.OPEN('||''''||'[PLSQL_AGENT]PA_SELF_SERVICE_INQUIRIES_PVT.OPENWINDOWFROMINQUIRY?P_EXPENDITURE_ID='||EXP.EXPENDITURE_ID ||'&' ||'P_ACTION_CODE=HISTORY_COPY'||''''||'
, '||''''||'WINMAIN'||''''||'
, '||''''||'STATUS=YES
, RESIZABLE=YES
, SCROLLBARS=YES
, MENUBAR=NO
, TOOLBAR=NO'||''''||')'
, ''
, 'JAVASCRIPT:VOID WINDOW.OPEN('||''''||'[PLSQL_AGENT]PA_SELF_SERVICE_INQUIRIES_PVT.OPENWINDOWFROMINQUIRY?P_EXPENDITURE_ID='||EXP.EXPENDITURE_ID ||'&'||'P_ACTION_CODE=HISTORY_REVERSE'||''''||'
, ' ||''''||'WINMAIN'||''''||'
, '||''''||'STATUS=YES
, RESIZABLE=YES
, SCROLLBARS=YES
, MENUBAR=NO
, TOOLBAR=NO'||''''||')'
, EXP.ORG_ID
FROM PA_EXPENDITURES EXP
, PER_ALL_PEOPLE_F PER
, PA_EI_DENORM DEN
, PA_LOOKUPS LOOKUP
WHERE EXPENDITURE_CLASS_CODE = 'PT' AND ((EXP.ORIG_USER_EXP_TXN_REFERENCE IS NOT NULL
AND EXPENDITURE_STATUS_CODE = 'SUBMITTED') OR (EXP.USER_BATCH_NAME IS NOT NULL
AND EXPENDITURE_STATUS_CODE='APPROVED')) AND EXP.EXPENDITURE_ID = DEN.EXPENDITURE_ID AND EXP.INCURRED_BY_PERSON_ID = PER.PERSON_ID AND EXPENDITURE_ENDING_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE AND LOOKUP.LOOKUP_TYPE = 'EXPENDITURE STATUS' AND LOOKUP.LOOKUP_CODE = EXP.EXPENDITURE_STATUS_CODE GROUP BY EXP.EXPENDITURE_ID
, EXP.ORIG_USER_EXP_TXN_REFERENCE
, EXP.EXPENDITURE_GROUP
, LOOKUP.MEANING
, EXP.EXPENDITURE_ENDING_DATE
, PER.FULL_NAME
, EXP.INCURRED_BY_PERSON_ID
, EXP.INCURRED_BY_ORGANIZATION_ID
, EXP.INITIAL_SUBMISSION_DATE
, EXP.DESCRIPTION
, EXP.ENTERED_BY_PERSON_ID
, EXP.OVERRIDING_APPROVER_PERSON_ID
, EXP.ORG_ID

Columns