DBA Data[Home] [Help]

APPS.MSC_X_CUST_FACING_RELEASE dependencies on MSC_SUP_DEM_ENTRIES

Line 744: UPDATE msc_sup_dem_entries sd

740:
741: if (lv_error_message is null) then
742: -- change the release status of the replenishment record from
743: -- from UNRELEASED to RELEASED
744: UPDATE msc_sup_dem_entries sd
745: SET sd.release_status = G_RELEASED,
746: sd.quantity_in_process = l_order_quantity
747: WHERE sd.publisher_id = 1
748: AND sd.inventory_item_id = l_inventory_item_id

Line 988: UPDATE msc_sup_dem_entries sd

984:
985: if (l_transaction_type = G_REPLENISHMENT) then
986: -- change the release status of the replenishment record from
987: -- from UNRELEASED to RELEASED
988: UPDATE msc_sup_dem_entries sd
989: SET sd.release_status = G_RELEASED,
990: sd.quantity_in_process = l_order_quantity
991: WHERE sd.publisher_id = 1
992: AND sd.inventory_item_id = l_inventory_item_id