DBA Data[Home] [Help]

APPS.PO_DRAFT_APPR_STATUS_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 350: UPDATE po_line_locations_all

346:
347: -- need to update transaction table as well because there may not be
348: -- shipment changes for the distribution being changed.
349: FORALL i IN 1..l_line_loc_list2.COUNT
350: UPDATE po_line_locations_all
351: SET approved_flag = 'R'
352: WHERE line_location_id = l_line_loc_list2(i)
353: AND approved_flag = 'Y';
354: END IF;

Line 677: FROM po_line_locations_all PLL

673: AND NVL(PLLD.delete_flag, 'N') = 'N'
674: AND NVL(PLLD.change_accepted_flag, 'Y') = 'Y'
675: AND NOT EXISTS
676: ( SELECT NULL
677: FROM po_line_locations_all PLL
678: WHERE PLLD.line_location_id = PLL.line_location_id));
679:
680: IF (l_has_new_records = FND_API.G_TRUE) THEN
681: IF (PO_LOG.d_stmt) THEN

Line 692: po_line_locations_all PLL

688: SELECT PLLD.line_location_id
689: BULK COLLECT
690: INTO x_changed_line_loc_list
691: FROM po_line_locations_draft_all PLLD,
692: po_line_locations_all PLL
693: WHERE PLLD.draft_id = p_draft_info.draft_id
694: AND NVL(PLLD.delete_flag, 'N') = 'N'
695: AND NVL(PLLD.change_accepted_flag, 'Y') = 'Y'
696: AND PLLD.line_location_id = PLL.line_location_id