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.

APPS.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 127: po_req_distributions_all req ,

123: FROM DUAL
124: WHERE EXISTS
125: (SELECT 'X'
126: FROM gms_award_distributions adl,
127: po_req_distributions_all req ,
128: po_requisition_lines_all pol --Bug 7660803 / 8250302
129: WHERE adl.distribution_id = req.distribution_id
130: AND adl.adl_status = 'A'
131: AND adl.award_id = P_AWARD_ID

Line 352: po_req_distributions_all req ,

348: FROM DUAL
349: WHERE EXISTS
350: (SELECT 'X'
351: FROM gms_award_distributions adl,
352: po_req_distributions_all req ,
353: po_requisition_lines_all pol --Bug 7660803 /8250302
354: WHERE adl.distribution_id = req.distribution_id
355: AND adl.adl_status = 'A'
356: AND adl.award_id = P_AWARD_ID

Line 670: FROM po_req_distributions_all req,

666: SELECT 1
667: FROM DUAL
668: WHERE EXISTS
669: (SELECT 'X'
670: FROM po_req_distributions_all req,
671: po_requisition_lines_all pol --Bug 8431879
672: WHERE req.project_id = P_PROJECT_ID
673: AND req.task_id = nvl(P_TASK_ID, req.task_id)
674: AND req.expenditure_item_date < P_START_DATE

Line 954: FROM po_req_distributions_all req,

950: SELECT 1
951: FROM DUAL
952: WHERE EXISTS
953: (SELECT 'X'
954: FROM po_req_distributions_all req,
955: po_requisition_lines_all pol --Bug 8431879
956: WHERE req.project_id = P_PROJECT_ID
957: AND req.task_id = nvl(P_TASK_ID, req.task_id)
958: AND req.expenditure_item_date > P_COMPLETION_DATE