DBA Data[Home] [Help]

APPS.FII_SIZING_UTIL dependencies on AP_INVOICES_ALL

Line 175: FROM ap_invoices_all ai

171: p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
172:
173: CURSOR c_cnt_rows IS
174: SELECT count(*)
175: FROM ap_invoices_all ai
176: WHERE ai.last_update_date between p_from_date and p_to_date
177: AND ai.invoice_type_lookup_code <> 'EXPENSE REPORT'
178: AND ai.cancelled_date IS NULL
179: AND ((EXISTS (SELECT 'this invoice is on hold' FROM ap_holds_all ah

Line 519: ap_invoices_all ai

515: CURSOR c_cnt_rows IS
516: Select count(*)
517: from
518: ap_invoice_distributions_all aid,
519: ap_invoices_all ai
520: WHERE aid.last_update_date between p_from_date and p_to_date
521: AND NVL(aid.reversal_flag,'N') <> 'Y'
522: AND aid.invoice_id = ai.invoice_id
523: AND aid.org_id = ai.org_id

Line 566: ap_invoices_all ai

562: CURSOR c_cnt_rows IS
563: SELECT count(*) cnt
564: FROM
565: ap_invoice_payments_all aip,
566: ap_invoices_all ai
567: WHERE aip.last_update_date between p_from_date and p_to_date
568: AND aip.invoice_id = ai.invoice_id
569: AND ai.invoice_type_lookup_code <> 'EXPENSE REPORT';
570:

Line 630: from ap_invoices_all ai

626: p_to_date DATE,
627: p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
628: CURSOR c_cnt_rows IS
629: Select count(*) cnt
630: from ap_invoices_all ai
631: where invoice_type_lookup_code <> 'EXPENSE REPORT'
632: AND ai.last_update_date between p_from_date and p_to_date;
633:
634: BEGIN