APPS.ASO_SUBMIT_QUOTE_PVT dependencies on ASO_SHIPMENTS

Line 1096: UPDATE ASO_SHIPMENTS

1092:
1093: FOR i IN 1..lx_order_line_tbl.count LOOP
1094: -- update order line id for quote lines
1095:
1096: UPDATE ASO_SHIPMENTS
1097: SET order_line_id = lx_order_line_tbl(i).order_line_id,
1098: last_update_date = sysdate,
1099: last_updated_by = fnd_global.user_id,
1100: last_update_login = fnd_global.conc_login_id

Line 1648: FROM ASO_SHIPMENTS

1644: DEMAND_CLASS_CODE,
1645: OBJECT_VERSION_NUMBER,
1646: SHIP_METHOD_CODE_FROM,
1647: FREIGHT_TERMS_CODE_FROM
1648: FROM ASO_SHIPMENTS
1649: WHERE quote_header_id = p_qte_header_id AND quote_line_id IS NULL;
1650: -- ((quote_line_id = p_qte_line_id) OR (quote_line_id IS NULL AND p_qte_line_id IS NULL));
1651:
1652: --created a new cursor for bug 5093289

Line 1711: FROM ASO_SHIPMENTS

1707: DEMAND_CLASS_CODE,
1708: OBJECT_VERSION_NUMBER,
1709: SHIP_METHOD_CODE_FROM,
1710: FREIGHT_TERMS_CODE_FROM
1711: FROM ASO_SHIPMENTS
1712: WHERE quote_line_id = p_qte_line_id;
1713:
1714: -- l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1715: l_ship_count NUMBER;