APPS.AP_RECURRING_INVOICES_PKG dependencies on PO_DISTRIBUTIONS_AP_V

Line 953: FROM po_distributions_ap_v pd,po_line_locations pll

949: (sum(nvl(pd.amount_ordered,0) - nvl(pd.amount_billed,0) -
950: nvl(pd.amount_cancelled,0)) - (p_invoice_amount - nvl(p_tax_amount,0)))
951: )
952: INTO C_quantity_outstanding
953: FROM po_distributions_ap_v pd,po_line_locations pll
954: WHERE pd.line_location_id=pll.line_location_id
955: AND pd.line_location_id = P_po_shipment_id
956: GROUP BY pll.line_location_id,pll.price_override;
957: