DBA Data[Home] [Help]

APPS.POS_VIEW_RECEIPTS_GRP dependencies on AP_INVOICE_LINES_ALL

Line 353: FROM ap_invoices_all ap, ap_invoice_lines_all al, rcv_transactions rt

349:
350: -- Declare cursor to retrieve the Invoice number for Supplier View.
351: CURSOR inv_cursor(l_shipment_header_id number) IS
352: SELECT DISTINCT ap.invoice_num,ap.invoice_id
353: FROM ap_invoices_all ap, ap_invoice_lines_all al, rcv_transactions rt
354: WHERE ap.invoice_id = al.invoice_id
355: AND al.rcv_transaction_id = rt.transaction_id
356: AND rt.shipment_header_id = l_shipment_header_id;
357:

Line 398: FROM ap_invoices_all ap, ap_invoice_lines_all al, rcv_transactions rt

394:
395: -- Declare cursor to retrieve the Invoice number for Supplier View.
396: CURSOR inv_cursor(l_shipment_line_id number) IS
397: SELECT DISTINCT ap.invoice_num,ap.invoice_id
398: FROM ap_invoices_all ap, ap_invoice_lines_all al, rcv_transactions rt
399: WHERE ap.invoice_id = al.invoice_id
400: AND al.rcv_transaction_id = rt.transaction_id
401: AND rt.shipment_line_id = l_shipment_line_id;
402: