DBA Data[Home] [Help]

APPS.WMS_TASK_LOAD dependencies on WMS_GLOBALS

Line 11238: l_lpn_controlled_flag := wms_globals.g_non_lpn_controlled_sub;

11234: , l_operation_plan_id
11235: FROM mtl_material_transactions_temp mmtt
11236: WHERE mmtt.transaction_temp_id = p_temp_id; */
11237:
11238: l_lpn_controlled_flag := wms_globals.g_non_lpn_controlled_sub;
11239:
11240: IF l_xfr_sub IS NOT NULL THEN
11241: SELECT lpn_controlled_flag
11242: INTO l_lpn_controlled_flag

Line 11249: AND l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN

11245: AND secondary_inventory_name = l_xfr_sub;
11246: END IF;
11247:
11248: IF l_xfr_sub IS NOT NULL
11249: AND l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN
11250: IF (l_debug = 1) THEN
11251: mydebug('validate_pick_to_lpn: Transfer Sub is LPN Controlled');
11252: END IF;
11253:

Line 11309: AND msi.lpn_controlled_flag = wms_globals.g_lpn_controlled_sub

11305: WHERE mmtt.transaction_temp_id <> p_temp_id
11306: AND mmtt.transfer_lpn_id = pick_to_lpn_rec.lpn_id
11307: AND msi.organization_id = p_organization_id
11308: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
11309: AND msi.lpn_controlled_flag = wms_globals.g_lpn_controlled_sub
11310: );
11311: EXCEPTION
11312: WHEN NO_DATA_FOUND THEN
11313: l_count := 0;