DBA Data[Home] [Help]

APPS.PO_LINK_REQ_DIST_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 2603: FROM po_line_locations_draft_all PLLD

2599: FROM po_distributions_gt GT
2600: WHERE PLL.line_location_id = GT.line_location_id)
2601: AND NOT EXISTS(
2602: SELECT 'Shipment exists in draft'
2603: FROM po_line_locations_draft_all PLLD
2604: WHERE PLLD.line_location_id = PLL.line_location_id
2605: AND PLLD.draft_id = l_draft_id);
2606:
2607: d_position := 20;

Line 2620: UPDATE po_line_locations_draft_all PLLD

2616: p_delete_flag_tbl => delete_flag_tbl,
2617: x_record_already_exist_tbl => x_record_already_exist_tbl);
2618:
2619: FORALL i IN 1..po_line_loc_id_tbl.COUNT
2620: UPDATE po_line_locations_draft_all PLLD
2621: SET PLLD.change_status = 'NOCHANGE'
2622: WHERE PLLD.line_location_id = po_line_loc_id_tbl(i)
2623: AND PLLD.draft_id = l_draft_id;
2624: