APPS.INV_TXN_MANAGER_GRP dependencies on MTL_SECONDARY_INVENTORIES

Line 2416: FROM MTL_SECONDARY_INVENTORIES MSI

2412: AND TRANSACTION_ACTION_ID NOT IN (24, 30) /* CFM Scrap Transactions */
2413: AND (NVL(SHIPPABLE_FLAG,'Y') = 'Y'
2414: AND NOT EXISTS (
2415: SELECT NULL
2416: FROM MTL_SECONDARY_INVENTORIES MSI
2417: WHERE MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2418: AND MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2419: AND NVL(MSI.DISABLE_DATE,SYSDATE+1) > SYSDATE)
2420: OR (SHIPPABLE_FLAG = 'N'

Line 2424: FROM MTL_SECONDARY_INVENTORIES MSI

2420: OR (SHIPPABLE_FLAG = 'N'
2421: AND SUBINVENTORY_CODE IS NOT NULL
2422: AND NOT EXISTS (
2423: SELECT NULL
2424: FROM MTL_SECONDARY_INVENTORIES MSI
2425: WHERE MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2426: AND MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2427: AND NVL(MSI.DISABLE_DATE,SYSDATE+1) > SYSDATE)));
2428:

Line 2461: FROM MTL_SECONDARY_INVENTORIES MSI

2457: AND TRANSFER_SUBINVENTORY IS NOT NULL)
2458: AND ((NVL(SHIPPABLE_FLAG,'Y') = 'Y'
2459: AND NOT EXISTS (
2460: SELECT NULL
2461: FROM MTL_SECONDARY_INVENTORIES MSI
2462: WHERE MSI.ORGANIZATION_ID =
2463: DECODE(MTI.TRANSACTION_ACTION_ID,2,
2464: MTI.ORGANIZATION_ID,5,MTI.organization_id,
2465: MTI.TRANSFER_ORGANIZATION)

Line 2472: FROM MTL_SECONDARY_INVENTORIES MSI

2468: OR (SHIPPABLE_FLAG = 'N'
2469: AND TRANSFER_SUBINVENTORY IS NOT NULL
2470: AND NOT EXISTS (
2471: SELECT NULL
2472: FROM MTL_SECONDARY_INVENTORIES MSI
2473: WHERE MSI.ORGANIZATION_ID =
2474: DECODE(MTI.TRANSACTION_ACTION_ID,3,
2475: MTI.TRANSFER_ORGANIZATION,21,
2476: MTI.TRANSFER_ORGANIZATION,MTI.ORGANIZATION_ID)

Line 2640: FROM MTL_SECONDARY_INVENTORIES MSI

2636: WHERE MP.PROCESS_ENABLED_FLAG = 'Y'
2637: AND MP.ORGANIZATION_ID = MTI.ORGANIZATION_ID))))
2638: AND EXISTS (
2639: SELECT 'X'
2640: FROM MTL_SECONDARY_INVENTORIES MSI
2641: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2642: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2643: AND MSI.QUANTITY_TRACKED = 2))
2644: OR (TRANSACTION_ACTION_ID = 21

Line 2647: FROM MTL_SECONDARY_INVENTORIES MSI,

2643: AND MSI.QUANTITY_TRACKED = 2))
2644: OR (TRANSACTION_ACTION_ID = 21
2645: AND EXISTS (
2646: SELECT 'X'
2647: FROM MTL_SECONDARY_INVENTORIES MSI,
2648: MTL_SYSTEM_ITEMS ITM
2649: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2650: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2651: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2674: FROM MTL_SECONDARY_INVENTORIES MSI,

2670: AND PROCESS_FLAG = 1
2671: AND TRANSACTION_ACTION_ID in (2,5)
2672: AND EXISTS (
2673: SELECT 'X'
2674: FROM MTL_SECONDARY_INVENTORIES MSI,
2675: MTL_SYSTEM_ITEMS ITM
2676: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2677: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2678: AND ITM.ORGANIZATION_ID = MSI.ORGANIZATION_ID

Line 2684: FROM MTL_SECONDARY_INVENTORIES MSI,

2680: AND ITM.INVENTORY_ASSET_FLAG = 'Y'
2681: AND MSI.ASSET_INVENTORY = 2)
2682: AND EXISTS (
2683: SELECT 'X'
2684: FROM MTL_SECONDARY_INVENTORIES MSI,
2685: MTL_SYSTEM_ITEMS ITM
2686: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.TRANSFER_SUBINVENTORY
2687: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2688: AND ITM.ORGANIZATION_ID = MSI.ORGANIZATION_ID

Line 2709: FROM MTL_SECONDARY_INVENTORIES MSI

2705: AND PROCESS_FLAG = 1
2706: AND TRANSACTION_ACTION_ID = 3
2707: AND EXISTS (
2708: SELECT 'X'
2709: FROM MTL_SECONDARY_INVENTORIES MSI
2710: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2711: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2712: AND MSI.ASSET_INVENTORY = 2)
2713: AND EXISTS (

Line 2715: FROM MTL_SECONDARY_INVENTORIES MSI

2711: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2712: AND MSI.ASSET_INVENTORY = 2)
2713: AND EXISTS (
2714: SELECT 'X'
2715: FROM MTL_SECONDARY_INVENTORIES MSI
2716: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.TRANSFER_SUBINVENTORY
2717: AND MSI.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION
2718: AND MSI.ASSET_INVENTORY = 1);
2719:

Line 2756: FROM MTL_SECONDARY_INVENTORIES MSI

2752: WHERE MP.PROCESS_ENABLED_FLAG = 'Y'
2753: AND MP.ORGANIZATION_ID = MTI.ORGANIZATION_ID))))
2754: AND EXISTS (
2755: SELECT 'X'
2756: FROM MTL_SECONDARY_INVENTORIES MSI
2757: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2758: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2759: AND MSI.QUANTITY_TRACKED = 2)));
2760:

Line 3447: mtl_secondary_inventories MSUB

3443: AND (TRANSACTION_ACTION_ID IN (1,27)
3444: AND EXISTS (
3445: SELECT NULL
3446: FROM MTL_SYSTEM_ITEMS MSI,
3447: mtl_secondary_inventories MSUB
3448: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3449: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3450: AND MSI.INVENTORY_ASSET_FLAG = 'Y'
3451: AND MSUB.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE

Line 5764: FROM mtl_secondary_inventories

5760: IF (l_cost_group_id is null) then
5761: IF l_primary_cost_method = 1 THEN -- costing method is standard
5762: BEGIN
5763: SELECT default_cost_group_id INTO l_cost_group_id
5764: FROM mtl_secondary_inventories
5765: WHERE secondary_inventory_name = p_subinv
5766: AND organization_id = p_org_id
5767: AND default_cost_group_id IS NOT NULL;
5768: EXCEPTION

Line 7072: MTL_SECONDARY_INVENTORIES S,

7068: l_shlfcode,
7069: l_shlfdays,
7070: l_lotuniq
7071: FROM MTL_PARAMETERS P,
7072: MTL_SECONDARY_INVENTORIES S,
7073: MTL_SYSTEM_ITEMS I
7074: WHERE I.INVENTORY_ITEM_ID = l_itemid
7075: AND S.SECONDARY_INVENTORY_NAME = l_subinv
7076: AND P.ORGANIZATION_ID = l_orgid

Line 7290: MTL_SECONDARY_INVENTORIES S,

7286: l_xlotctrl,
7287: l_xserctrl,
7288: l_xresloc
7289: FROM MTL_PARAMETERS P,
7290: MTL_SECONDARY_INVENTORIES S,
7291: MTL_SYSTEM_ITEMS I
7292: WHERE I.INVENTORY_ITEM_ID = l_itemid
7293: AND S.SECONDARY_INVENTORY_NAME = l_xsubinv
7294: AND P.ORGANIZATION_ID = l_xorgid