eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_SST_VIEW_TIMECARD_HISTORY_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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