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
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: