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 AP_INVOICE_DISTRIBUTIONS_ALL

Line 112: ap_invoice_distributions_all ap ,

108: FROM DUAL
109: WHERE EXISTS
110: (SELECT 'X'
111: FROM gms_award_distributions adl,
112: ap_invoice_distributions_all ap ,
113: ap_invoices_all ai --Bug 7660803/8250302
114: WHERE adl.invoice_distribution_id = ap.invoice_distribution_id
115: AND adl.adl_status = 'A'
116: AND adl.award_id = P_AWARD_ID

Line 337: ap_invoice_distributions_all ap ,

333: FROM DUAL
334: WHERE EXISTS
335: (SELECT 'X'
336: FROM gms_award_distributions adl,
337: ap_invoice_distributions_all ap ,
338: ap_invoices_all ai --Bug 7660803 / 8250302
339: WHERE adl.invoice_distribution_id = ap.invoice_distribution_id
340: AND adl.adl_status = 'A'
341: AND adl.award_id = P_AWARD_ID

Line 655: FROM ap_invoice_distributions_all ap,

651: SELECT 1
652: FROM DUAL
653: WHERE EXISTS
654: (SELECT 'X'
655: FROM ap_invoice_distributions_all ap,
656: ap_invoices_all ai --Bug 8431879
657: WHERE ap.project_id = P_PROJECT_ID
658: AND ap.task_id = nvl(P_TASK_ID, ap.task_id)
659: AND ap.expenditure_item_date < P_START_DATE

Line 938: FROM ap_invoice_distributions_all ap,

934: SELECT 1
935: FROM DUAL
936: WHERE EXISTS
937: (SELECT 'X'
938: FROM ap_invoice_distributions_all ap,
939: ap_invoices_all ai --Bug 8431879
940: WHERE ap.project_id = P_PROJECT_ID
941: AND ap.task_id = nvl(P_TASK_ID, ap.task_id)
942: AND ap.expenditure_item_date > P_COMPLETION_DATE