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_MODIFY_TIMECARD_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=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

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=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