View: PA_SST_MODIFY_TIMECARD_V

Product:	PA - Projects
Description:	View of Working and Rejected timecards. Used in Modify Timecard function of Self Service Time.
Implementation/DBA Data:	APPS.PA_SST_MODIFY_TIMECARD_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=MODIFY_MODIFY'||''''||'
, '||''''||'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=MODIFY_COPY'||''''||'
, '||''''||'WINMAIN'||''''||'
, '||''''||'STATUS=YES
, RESIZABLE=YES
, SCROLLBARS=YES
, MENUBAR=NO
, TOOLBAR=NO'||''''||')'
, 'JAVASCRIPT:VOID WINDOW.OPEN('||''''||'[PLSQL_AGENT]PA_SELF_SERVICE_INQUIRIES_PVT.CHECKDELETE?P_EXPENDITURE_ID='||EXP.EXPENDITURE_ID||''''||')'
, ''
, ''
, EXP.ORG_ID
FROM PA_EXPENDITURES EXP
, PER_ALL_PEOPLE_F PER
, PA_EI_DENORM DEN
, PA_LOOKUPS LOOKUP
WHERE EXP.EXPENDITURE_CLASS_CODE = 'PT' AND EXP.ORIG_USER_EXP_TXN_REFERENCE IS NOT NULL AND EXP.EXPENDITURE_STATUS_CODE IN ('REJECTED'
, 'WORKING') AND DEN.EXPENDITURE_ID(+) = EXP.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