APPS.POA_SUPPERF_API_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 66: FROM po_distributions_all

62:
63: SELECT sum(quantity_ordered * nvl(rate, 1)) /
64: DECODE(sum(quantity_ordered), 0, 1, sum(quantity_ordered))
65: INTO v_ave_rate
66: FROM po_distributions_all
67: WHERE line_location_id = p_line_location_id
68: AND nvl(distribution_type,'-99') <> 'AGREEMENT';
69:
70: v_ave_price := v_ave_rate * p_price_override;

Line 468: FROM po_distributions_all

464: nvl(quantity_billed, 0) quantity_billed,
465: nvl(quantity_cancelled, 0) quantity_cancelled,
466: quantity_ordered,
467: nvl(rate, 1) rate
468: FROM po_distributions_all
469: WHERE line_location_id = p_line_location_id
470: AND nvl(distribution_type,'-99') <> 'AGREEMENT';
471:
472: v_c_info C_DIST%ROWTYPE;