APPS.PO_INVOICES_SV2 dependencies on AP_INVOICE_LINES_INTERFACE

Line 66: ap_invoice_lines_interface.line_number%TYPE INDEX BY BINARY_INTEGER;

62: TYPE org_id_tbl_type IS TABLE OF
63: po_headers.org_id%TYPE INDEX BY BINARY_INTEGER;
64:
65: TYPE invoice_line_num_tbl_type IS TABLE OF
66: ap_invoice_lines_interface.line_number%TYPE INDEX BY BINARY_INTEGER;
67:
68: TYPE invoice_id_tbl_type IS TABLE OF
69: ap_invoices_interface.invoice_id%TYPE INDEX BY BINARY_INTEGER;
70:

Line 225: ap_invoice_lines_interface aili

221: AND pod.quantity_ordered > NVL(pod.quantity_billed,0)
222: AND poll.closed_code <> 'FINALLY CLOSED'
223: AND NOT EXISTS ( SELECT 'use invoice is interfaced'
224: FROM ap_invoices_interface aii,
225: ap_invoice_lines_interface aili
226: WHERE aii.invoice_id = aili.invoice_id
227: AND nvl(aii.status,'PENDING') <> 'PROCESSED'
228: AND aili.po_distribution_id = pod.po_distribution_id )
229: UNION ALL

Line 291: ap_invoice_lines_interface aili

287: AND pod.quantity_ordered > NVL(pod.quantity_billed,0)
288: AND poll.closed_code <> 'FINALLY CLOSED'
289: AND NOT EXISTS ( SELECT 'use invoice is interfaced'
290: FROM ap_invoices_interface aii,
291: ap_invoice_lines_interface aili
292: WHERE aii.invoice_id = aili.invoice_id
293: AND nvl(aii.status,'PENDING') <> 'PROCESSED'
294: AND aili.po_distribution_id = pod.po_distribution_id )
295: ORDER BY 6, -- VENDOR_ID

Line 773: into AP_INVOICE_LINES_INTERFACE

769: /*==================================================================
770: PROCEDURE NAME: create_invoice_distr
771:
772: DESCRIPTION: bulk insert records from p_consumption structure
773: into AP_INVOICE_LINES_INTERFACE
774:
775:
776: PARAMETERS:
777: x_return_status : return status of the procedure