DBA Data[Home] [Help]

APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 3191: from po_line_locations_draft_all poll

3187: poll.need_by_date
3188: into l_ship_to_loc,
3189: l_ship_to_org,
3190: l_need_by_date
3191: from po_line_locations_draft_all poll
3192: where poll.po_line_id = x_po_line_id
3193: AND poll.draft_id= po_autocreate_params.g_draft_id
3194: and poll.shipment_num = l_min_shipment_num;
3195: EXCEPTION

Line 3304: UPDATE po_line_locations_draft_all

3300:
3301: --- Need to modify the following code to update the proper table. -- serukull
3302: --All the shipments which have been created need to get the
3303: --new price as on the line for Standard POs.
3304: UPDATE po_line_locations_draft_all
3305: SET price_override = nvl(x_unit_price, price_override)
3306: WHERE po_line_id = x_po_line_id
3307: AND draft_id = po_autocreate_params.g_draft_id;
3308: