[Home] [Help]
421: , wdt.priority
422: , wdt.task_id task_id
423: , sub.picking_order sub_picking_order
424: , loc.picking_order loc_picking_order
425: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
426: WHERE wdt.person_id = l_user_id
427: AND wdt.organization_id = l_org_id
428: AND wdt.status <= 3
429: AND wdt.task_type IN (1, 4, 5, 6)
440: , wdt.task_id task_id
441: , sub.picking_order sub_picking_order
442: , loc.picking_order loc_picking_order
443: --Bug 3808770 -Added the table mtl_cycle_count_headers in the FROM clause
444: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
445: ,mtl_cycle_count_headers mcch
446: WHERE wdt.person_id = l_user_id
447: AND wdt.organization_id = l_org_id
448: AND wdt.status <= 3
468: , wdt.priority
469: , wdt.task_id task_id
470: , sub.picking_order sub_picking_order
471: , loc.picking_order loc_picking_order
472: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
473: WHERE wdt.person_id = l_user_id
474: AND wdt.organization_id = l_org_id
475: AND wdt.status <= 3
476: AND wdt.task_type IN (1, 4, 5, 6)
486: , wdt.task_id task_id
487: , sub.picking_order sub_picking_order
488: , loc.picking_order loc_picking_order
489: --Bug 3808770 -Added the table mtl_cycle_count_headers in the FROM clause
490: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
491: , mtl_cycle_count_headers mcch
492: WHERE wdt.person_id = l_user_id
493: AND wdt.organization_id = l_org_id
494: AND wdt.status <= 3
1623:
1624: IF (p_sub <> l_orig_sub) THEN
1625: SELECT msi.reservable_type
1626: INTO l_sub_reservable_type
1627: FROM mtl_secondary_inventories msi
1628: WHERE msi.secondary_inventory_name = p_sub
1629: AND msi.organization_id = p_org_id;
1630:
1631: IF l_sub_reservable_type = 2 THEN
2839: -- bug 2398247
2840: -- verify if sub is active
2841: SELECT COUNT(*)
2842: INTO l_sub_active
2843: FROM mtl_secondary_inventories
2844: WHERE NVL(disable_date, SYSDATE + 1) > SYSDATE
2845: AND organization_id = p_org_id
2846: AND secondary_inventory_name = l_sub;
2847:
8237:
8238: IF l_xfr_sub IS NOT NULL THEN
8239: SELECT lpn_controlled_flag
8240: INTO l_lpn_controlled_flag
8241: FROM mtl_secondary_inventories
8242: WHERE organization_id = p_organization_id
8243: AND secondary_inventory_name = l_xfr_sub;
8244: END IF;
8245:
8298: FROM DUAL
8299: WHERE EXISTS
8300: ( SELECT 'x'
8301: FROM mtl_material_transactions_temp mmtt
8302: , mtl_secondary_inventories msi
8303: WHERE mmtt.transaction_temp_id <> p_temp_id
8304: AND mmtt.transfer_lpn_id = pick_to_lpn_rec.lpn_id
8305: AND msi.organization_id = p_organization_id
8306: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
11197:
11198: BEGIN
11199: SELECT LPN_CONTROLLED_FLAG
11200: INTO l_is_transfer_sub_lpn
11201: FROM mtl_secondary_inventories
11202: WHERE ORGANIZATION_ID = p_org_id
11203: AND SECONDARY_INVENTORY_NAME = l_transfer_sub;
11204: EXCEPTION
11205: WHEN OTHERS THEN
13644: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13645: BEGIN
13646: SELECT reservable_type
13647: INTO l_reservable_type
13648: FROM mtl_secondary_inventories
13649: WHERE organization_id = p_organization_id
13650: AND secondary_inventory_name = p_subinventory_code;
13651:
13652: IF (l_reservable_type = 1) THEN
14482: , mmtt.transfer_subinventory
14483: INTO l_lpn_controlled_flag
14484: , l_xfr_lpn_id
14485: , l_orig_xfr_sub
14486: FROM mtl_material_transactions_temp mmtt, mtl_secondary_inventories msi
14487: WHERE mmtt.transaction_temp_id = p_temp_id
14488: AND mmtt.organization_id = msi.organization_id
14489: AND msi.secondary_inventory_name = p_confirmed_drop_sub;
14490:
14617: , mmtt.transfer_subinventory
14618: INTO l_lpn_controlled_flag
14619: , l_xfr_lpn_id
14620: , l_orig_xfr_sub
14621: FROM mtl_material_transactions_temp mmtt, mtl_secondary_inventories msi
14622: WHERE mmtt.transaction_temp_id = p_temp_id
14623: AND mmtt.organization_id = msi.organization_id
14624: AND msi.secondary_inventory_name = p_confirmed_drop_sub;
14625: