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_LINES_ALL

Line 95: po_lines_all pol --Bug 7660803/8250302

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
99: AND adl.award_set_id = po.award_id -- Bug 3985177

Line 320: po_lines_all pol --bug 7660803 / 8250302

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
324: AND adl.award_set_id = po.award_id -- Bug 3985177

Line 641: po_lines_all pol --Bug 8431879

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
645: AND po.po_line_id = pol.po_line_id --Bug 8431879

Line 924: po_lines_all pol --Bug 8431879

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
928: AND po.po_line_id = pol.po_line_id --Bug 8431879