APPS.AP_RECURRING_INVOICES_PKG dependencies on PO_DISTRIBUTIONS_AP_V

Line 929: FROM po_distributions_ap_v pd,po_line_locations pll

925: (sum(nvl(pd.amount_ordered,0) - nvl(pd.amount_billed,0) -
926: nvl(pd.amount_cancelled,0)) - (p_invoice_amount - nvl(p_tax_amount,0)))
927: )
928: INTO C_quantity_outstanding
929: FROM po_distributions_ap_v pd,po_line_locations pll
930: WHERE pd.line_location_id=pll.line_location_id
931: AND pd.line_location_id = P_po_shipment_id
932: GROUP BY pll.line_location_id,pll.price_override;
933: