APPS.POS_TOTALS_PO_SV dependencies on AP_INVOICE_LINES_ALL

Line 650: from ap_invoice_lines_all

646:
647: select --sum(quantity_invoiced),
648: nvl(sum(amount), 0)
649: into p_amount_billed
650: from ap_invoice_lines_all
651: where po_line_location_id = p_po_line_location_id;
652:
653:
654: EXCEPTION

Line 858: from ap_invoice_lines_all

854:
855: select --sum(quantity_invoiced),
856: nvl(sum(amount), 0)
857: into x_total_invoiced
858: from ap_invoice_lines_all
859: where (po_header_id = p_po_header_id and po_release_id = p_po_release_id and p_po_release_id is not null)
860: or (po_header_id = p_po_header_id and po_release_id is null and p_po_release_id is null);
861:
862:

Line 988: AP_INVOICE_LINES_ALL AIL

984: */
985: CURSOR l_inv_paid_csr IS
986: select NVL(AI.payment_status_flag, 'N')
987: from AP_INVOICES_ALL AI,
988: AP_INVOICE_LINES_ALL AIL
989: where AI.invoice_id = AIL.invoice_id
990: and AIL.po_line_location_id = p_line_location_id;
991:
992: BEGIN