APPS.ASO_SUBMIT_QUOTE_PVT dependencies on ASO_SHIPMENTS

Line 967: UPDATE ASO_SHIPMENTS

963:
964: FOR i IN 1..lx_order_line_tbl.count LOOP
965: -- update order line id for quote lines
966:
967: UPDATE ASO_SHIPMENTS
968: SET order_line_id = lx_order_line_tbl(i).order_line_id,
969: last_update_date = sysdate,
970: last_updated_by = fnd_global.user_id,
971: last_update_login = fnd_global.conc_login_id

Line 1495: FROM ASO_SHIPMENTS

1491: DEMAND_CLASS_CODE,
1492: OBJECT_VERSION_NUMBER,
1493: SHIP_METHOD_CODE_FROM,
1494: FREIGHT_TERMS_CODE_FROM
1495: FROM ASO_SHIPMENTS
1496: WHERE quote_header_id = p_qte_header_id AND quote_line_id IS NULL;
1497: -- ((quote_line_id = p_qte_line_id) OR (quote_line_id IS NULL AND p_qte_line_id IS NULL));
1498:
1499: --created a new cursor for bug 5093289

Line 1558: FROM ASO_SHIPMENTS

1554: DEMAND_CLASS_CODE,
1555: OBJECT_VERSION_NUMBER,
1556: SHIP_METHOD_CODE_FROM,
1557: FREIGHT_TERMS_CODE_FROM
1558: FROM ASO_SHIPMENTS
1559: WHERE quote_line_id = p_qte_line_id;
1560:
1561: -- l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1562: l_ship_count NUMBER;