APPS.PO_MULTI_MOD_VALIDATIONS dependencies on AP_INVOICES_ALL

Line 3737: ,ap_invoices_all ap

3733: BEGIN
3734: SELECT apl.invoice_id, ap.invoice_num, ap.invoice_date, ap.invoice_amount
3735: BULK COLLECT INTO l_invoice_id_tbl, l_invoice_num_tbl,l_invoice_date_tbl, l_invoice_amount_tbl
3736: FROM ap_invoice_lines_all apl
3737: ,ap_invoices_all ap
3738: WHERE apl.invoice_id = ap.invoice_id
3739: AND apl.match_type = 'ITEM_TO_PO'
3740: AND apl.po_header_id = p_document_id_tbl(i);
3741: EXCEPTION

Line 4233: FROM ap_invoices_all ap

4229: BEGIN
4230: --bug13084712. Selecting the invoice id,invoice num and invoice date as they have to be displayed in the exceptions report.
4231: SELECT ap.invoice_id,ap.invoice_num, ap.invoice_date
4232: BULK COLLECT INTO x_invoice_id_tbl, x_invoice_num_tbl, x_invoice_date_tbl
4233: FROM ap_invoices_all ap
4234: , ap_invoice_lines_all apl
4235: WHERE ap.invoice_id = apl.invoice_id
4236: AND ap.vendor_id = p_vendor_id
4237: AND NVL(apl.match_type, 'NOT_MATCHED') = 'NOT_MATCHED';

Line 4289: ,ap_invoices_all ap

4285:
4286: SELECT ap.invoice_id,ap.invoice_num, ap.invoice_date
4287: BULK COLLECT INTO x_invoice_id_tbl, x_invoice_num_tbl, x_invoice_date_tbl
4288: FROM ap_invoice_lines_all apl
4289: ,ap_invoices_all ap
4290: WHERE apl.prepay_invoice_id = ap.invoice_id
4291: AND NVL(apl.match_type, 'NOT_MATCHED') = 'NOT_MATCHED'
4292: AND ap.invoice_type_lookup_code = 'PREPAYMENT'
4293: AND ap.vendor_id = p_vendor_id;

Line 4346: FROM ap_invoices_all ap

4342: d_position := 10;
4343: BEGIN
4344: SELECT ap.invoice_id,ap.invoice_num, ap.invoice_date
4345: BULK COLLECT INTO x_invoice_id_tbl, x_invoice_num_tbl, x_invoice_date_tbl
4346: FROM ap_invoices_all ap
4347: ,ap_payment_schedules_all apps
4348: WHERE ap.invoice_id = apps.invoice_id
4349: AND NVL(ap.invoice_amount,0) <> NVL(ap.amount_paid,0)
4350: AND NVL(apps.amount_remaining,0) <> 0