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_DISTRIBUTIONS_ALL

Line 94: po_distributions_all po ,

90: FROM DUAL
91: WHERE EXISTS
92: (SELECT 'X'
93: FROM gms_award_distributions adl,
94: po_distributions_all po ,
95: po_lines_all pol --Bug 7660803/8250302
96: WHERE adl.po_distribution_id = po.po_distribution_id
97: AND adl.adl_status = 'A'
98: AND adl.award_id = P_AWARD_ID

Line 319: po_distributions_all po ,

315: FROM DUAL
316: WHERE EXISTS
317: (SELECT 'X'
318: FROM gms_award_distributions adl,
319: po_distributions_all po ,
320: po_lines_all pol --bug 7660803 / 8250302
321: WHERE adl.po_distribution_id = po.po_distribution_id
322: AND adl.adl_status = 'A'
323: AND adl.award_id = P_AWARD_ID

Line 640: FROM po_distributions_all po ,

636: SELECT 1
637: FROM DUAL
638: WHERE EXISTS
639: (SELECT 'X'
640: FROM po_distributions_all po ,
641: po_lines_all pol --Bug 8431879
642: WHERE po.project_id = P_PROJECT_ID
643: AND po.task_id = nvl(P_TASK_ID, po.task_id)
644: AND po.expenditure_item_date < P_START_DATE

Line 923: FROM po_distributions_all po,

919: SELECT 1
920: FROM DUAL
921: WHERE EXISTS
922: (SELECT 'X'
923: FROM po_distributions_all po,
924: po_lines_all pol --Bug 8431879
925: WHERE po.project_id = P_PROJECT_ID
926: AND po.task_id = nvl(P_TASK_ID, po.task_id)
927: AND po.expenditure_item_date > P_COMPLETION_DATE