APPS.PO_INVOICES_SV2 dependencies on AP_INVOICE_LINES_INTERFACE

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

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

Line 230: ap_invoice_lines_interface aili

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

Line 297: ap_invoice_lines_interface aili

293: AND pod.quantity_ordered > NVL(pod.quantity_billed,0)
294: AND poll.closed_code <> 'FINALLY CLOSED'
295: AND NOT EXISTS ( SELECT 'use invoice is interfaced'
296: FROM ap_invoices_interface aii,
297: ap_invoice_lines_interface aili
298: WHERE aii.invoice_id = aili.invoice_id
299: AND nvl(aii.status,'PENDING') <> 'PROCESSED'
300: AND aili.po_distribution_id = pod.po_distribution_id )
301: ORDER BY 6, -- VENDOR_ID

Line 780: into AP_INVOICE_LINES_INTERFACE

776: /*==================================================================
777: PROCEDURE NAME: create_invoice_distr
778:
779: DESCRIPTION: bulk insert records from p_consumption structure
780: into AP_INVOICE_LINES_INTERFACE
781:
782:
783: PARAMETERS:
784: x_return_status : return status of the procedure