APPS.POS_TOTALS_PO_SV dependencies on AP_INVOICE_LINES_ALL

Line 629: from ap_invoice_lines_all

625:
626: select --sum(quantity_invoiced),
627: nvl(sum(amount), 0)
628: into p_amount_billed
629: from ap_invoice_lines_all
630: where po_line_location_id = p_po_line_location_id;
631:
632:
633: EXCEPTION

Line 871: from ap_invoice_lines_all

867:
868: select --sum(quantity_invoiced),
869: nvl(sum(amount), 0)
870: into x_total_invoiced
871: from ap_invoice_lines_all
872: where (po_header_id = p_po_header_id and po_release_id = p_po_release_id and p_po_release_id is not null)
873: or (po_header_id = p_po_header_id and po_release_id is null and p_po_release_id is null);
874:
875:

Line 899: from ap_invoice_lines_all

895:
896: select nvl(sum(quantity_invoiced), 0)
897: --nvl(sum(amount), 0)
898: into x_total_quantity_invoiced
899: from ap_invoice_lines_all
900: where (po_header_id = p_po_header_id and po_release_id = p_po_release_id and p_po_release_id is not null)
901: or (po_header_id = p_po_header_id and po_release_id is null and p_po_release_id is null);
902:
903: return x_total_quantity_invoiced;

Line 1029: AP_INVOICE_LINES_ALL AIL

1025: */
1026: CURSOR l_inv_paid_csr IS
1027: select NVL(AI.payment_status_flag, 'N')
1028: from AP_INVOICES_ALL AI,
1029: AP_INVOICE_LINES_ALL AIL
1030: where AI.invoice_id = AIL.invoice_id
1031: and AIL.po_line_location_id = p_line_location_id;
1032:
1033: BEGIN