DBA Data[Home] [Help]

APPS.PO_ADVANCED_PRICE_PVT dependencies on QP_LDETS_V

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

1548: if p_return_freight_flag then
1549: d_pos := 270;
1550:
1551: FOR j IN 1..i-1 LOOP
1552: -- query to qp_ldets_v to retrieve the freight charge info.
1553: select charge_type_code,
1554: order_qty_adj_amt freight_charge,
1555: pricing_status_code,
1556: pricing_status_text BULK COLLECT into l_freight_charge_rec_tbl

Line 1557: from qp_ldets_v

1553: select charge_type_code,
1554: order_qty_adj_amt freight_charge,
1555: pricing_status_code,
1556: pricing_status_text BULK COLLECT into l_freight_charge_rec_tbl
1557: from qp_ldets_v
1558: where line_index = j
1559: and list_line_type_code='FREIGHT_CHARGE'
1560: and applied_flag = 'Y';
1561: