DBA Data[Home] [Help]

APPS.WMS_TASK_LOAD dependencies on WMS_GLOBALS

Line 13512: l_lpn_controlled_flag := wms_globals.g_non_lpn_controlled_sub;

13508: , l_operation_plan_id
13509: FROM mtl_material_transactions_temp mmtt
13510: WHERE mmtt.transaction_temp_id = p_temp_id; */
13511:
13512: l_lpn_controlled_flag := wms_globals.g_non_lpn_controlled_sub;
13513:
13514: IF l_xfr_sub IS NOT NULL THEN
13515: SELECT lpn_controlled_flag
13516: INTO l_lpn_controlled_flag

Line 13523: AND l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN

13519: AND secondary_inventory_name = l_xfr_sub;
13520: END IF;
13521:
13522: IF l_xfr_sub IS NOT NULL
13523: AND l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN
13524: IF (l_debug = 1) THEN
13525: mydebug('validate_pick_to_lpn: Transfer Sub is LPN Controlled');
13526: END IF;
13527:

Line 13583: AND msi.lpn_controlled_flag = wms_globals.g_lpn_controlled_sub

13579: WHERE mmtt.transaction_temp_id <> p_temp_id
13580: AND mmtt.transfer_lpn_id = pick_to_lpn_rec.lpn_id
13581: AND msi.organization_id = p_organization_id
13582: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
13583: AND msi.lpn_controlled_flag = wms_globals.g_lpn_controlled_sub
13584: );
13585: EXCEPTION
13586: WHEN NO_DATA_FOUND THEN
13587: l_count := 0;