APPS.PO_ADVANCED_PRICE_PVT dependencies on QP_LDETS_V

Line 1639: -- query to qp_ldets_v to retrieve the freight charge info.

1635: IF p_return_freight_flag THEN
1636: d_pos := 270;
1637:
1638: FOR j IN 1..i - 1 LOOP
1639: -- query to qp_ldets_v to retrieve the freight charge info.
1640: SELECT charge_type_code,
1641: order_qty_adj_amt freight_charge,
1642: pricing_status_code,
1643: pricing_status_text BULK COLLECT INTO l_freight_charge_rec_tbl

Line 1644: FROM qp_ldets_v

1640: SELECT charge_type_code,
1641: order_qty_adj_amt freight_charge,
1642: pricing_status_code,
1643: pricing_status_text BULK COLLECT INTO l_freight_charge_rec_tbl
1644: FROM qp_ldets_v
1645: WHERE line_index = j
1646: AND list_line_type_code = 'FREIGHT_CHARGE'
1647: AND applied_flag = 'Y';
1648: