eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_SECONDARY_INVENTORIES

Line 2288: FROM MTL_SECONDARY_INVENTORIES MSI

2284: AND TRANSACTION_ACTION_ID NOT IN (24, 30) /* CFM Scrap Transactions */
2285: AND (NVL(SHIPPABLE_FLAG,'Y') = 'Y'
2286: AND NOT EXISTS (
2287: SELECT NULL
2288: FROM MTL_SECONDARY_INVENTORIES MSI
2289: WHERE MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2290: AND MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2291: AND NVL(MSI.DISABLE_DATE,SYSDATE+1) > SYSDATE)
2292: OR (SHIPPABLE_FLAG = 'N'

Line 2296: FROM MTL_SECONDARY_INVENTORIES MSI

2292: OR (SHIPPABLE_FLAG = 'N'
2293: AND SUBINVENTORY_CODE IS NOT NULL
2294: AND NOT EXISTS (
2295: SELECT NULL
2296: FROM MTL_SECONDARY_INVENTORIES MSI
2297: WHERE MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2298: AND MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2299: AND NVL(MSI.DISABLE_DATE,SYSDATE+1) > SYSDATE)));
2300:

Line 2333: FROM MTL_SECONDARY_INVENTORIES MSI

2329: AND TRANSFER_SUBINVENTORY IS NOT NULL)
2330: AND ((NVL(SHIPPABLE_FLAG,'Y') = 'Y'
2331: AND NOT EXISTS (
2332: SELECT NULL
2333: FROM MTL_SECONDARY_INVENTORIES MSI
2334: WHERE MSI.ORGANIZATION_ID =
2335: DECODE(MTI.TRANSACTION_ACTION_ID,2,
2336: MTI.ORGANIZATION_ID,5,MTI.organization_id,
2337: MTI.TRANSFER_ORGANIZATION)

Line 2344: FROM MTL_SECONDARY_INVENTORIES MSI

2340: OR (SHIPPABLE_FLAG = 'N'
2341: AND TRANSFER_SUBINVENTORY IS NOT NULL
2342: AND NOT EXISTS (
2343: SELECT NULL
2344: FROM MTL_SECONDARY_INVENTORIES MSI
2345: WHERE MSI.ORGANIZATION_ID =
2346: DECODE(MTI.TRANSACTION_ACTION_ID,3,
2347: MTI.TRANSFER_ORGANIZATION,21,
2348: MTI.TRANSFER_ORGANIZATION,MTI.ORGANIZATION_ID)

Line 2502: FROM MTL_SECONDARY_INVENTORIES MSI

2498: AND PROCESS_FLAG = 1
2499: AND ((TRANSACTION_ACTION_ID in (1,2,3,30,31,5)
2500: AND EXISTS (
2501: SELECT 'X'
2502: FROM MTL_SECONDARY_INVENTORIES MSI
2503: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2504: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2505: AND MSI.QUANTITY_TRACKED = 2))
2506: OR (TRANSACTION_ACTION_ID = 21

Line 2509: FROM MTL_SECONDARY_INVENTORIES MSI,

2505: AND MSI.QUANTITY_TRACKED = 2))
2506: OR (TRANSACTION_ACTION_ID = 21
2507: AND EXISTS (
2508: SELECT 'X'
2509: FROM MTL_SECONDARY_INVENTORIES MSI,
2510: MTL_SYSTEM_ITEMS ITM
2511: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2512: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2513: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID

Line 2536: FROM MTL_SECONDARY_INVENTORIES MSI,

2532: AND PROCESS_FLAG = 1
2533: AND TRANSACTION_ACTION_ID in (2,5)
2534: AND EXISTS (
2535: SELECT 'X'
2536: FROM MTL_SECONDARY_INVENTORIES MSI,
2537: MTL_SYSTEM_ITEMS ITM
2538: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2539: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2540: AND ITM.ORGANIZATION_ID = MSI.ORGANIZATION_ID

Line 2546: FROM MTL_SECONDARY_INVENTORIES MSI,

2542: AND ITM.INVENTORY_ASSET_FLAG = 'Y'
2543: AND MSI.ASSET_INVENTORY = 2)
2544: AND EXISTS (
2545: SELECT 'X'
2546: FROM MTL_SECONDARY_INVENTORIES MSI,
2547: MTL_SYSTEM_ITEMS ITM
2548: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.TRANSFER_SUBINVENTORY
2549: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2550: AND ITM.ORGANIZATION_ID = MSI.ORGANIZATION_ID

Line 2571: FROM MTL_SECONDARY_INVENTORIES MSI

2567: AND PROCESS_FLAG = 1
2568: AND TRANSACTION_ACTION_ID = 3
2569: AND EXISTS (
2570: SELECT 'X'
2571: FROM MTL_SECONDARY_INVENTORIES MSI
2572: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2573: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2574: AND MSI.ASSET_INVENTORY = 2)
2575: AND EXISTS (

Line 2577: FROM MTL_SECONDARY_INVENTORIES MSI

2573: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2574: AND MSI.ASSET_INVENTORY = 2)
2575: AND EXISTS (
2576: SELECT 'X'
2577: FROM MTL_SECONDARY_INVENTORIES MSI
2578: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.TRANSFER_SUBINVENTORY
2579: AND MSI.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION
2580: AND MSI.ASSET_INVENTORY = 1);
2581:

Line 2608: FROM MTL_SECONDARY_INVENTORIES MSI

2604: AND PROCESS_FLAG = 1
2605: AND ((TRANSACTION_ACTION_ID in (1,2,3,30,31,5)
2606: AND EXISTS (
2607: SELECT 'X'
2608: FROM MTL_SECONDARY_INVENTORIES MSI
2609: WHERE MSI.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE
2610: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
2611: AND MSI.QUANTITY_TRACKED = 2)
2612: )) ;

Line 3260: mtl_secondary_inventories MSUB

3256: AND (TRANSACTION_ACTION_ID IN (1,27)
3257: AND EXISTS (
3258: SELECT NULL
3259: FROM MTL_SYSTEM_ITEMS MSI,
3260: mtl_secondary_inventories MSUB
3261: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
3262: AND MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID
3263: AND MSI.INVENTORY_ASSET_FLAG = 'Y'
3264: AND MSUB.SECONDARY_INVENTORY_NAME = MTI.SUBINVENTORY_CODE

Line 5385: FROM mtl_secondary_inventories

5381: IF (l_cost_group_id is null) then
5382: IF l_primary_cost_method = 1 THEN -- costing method is standard
5383: BEGIN
5384: SELECT default_cost_group_id INTO l_cost_group_id
5385: FROM mtl_secondary_inventories
5386: WHERE secondary_inventory_name = p_subinv
5387: AND organization_id = p_org_id
5388: AND default_cost_group_id IS NOT NULL;
5389: EXCEPTION

Line 6592: MTL_SECONDARY_INVENTORIES S,

6588: l_shlfcode,
6589: l_shlfdays,
6590: l_lotuniq
6591: FROM MTL_PARAMETERS P,
6592: MTL_SECONDARY_INVENTORIES S,
6593: MTL_SYSTEM_ITEMS I
6594: WHERE I.INVENTORY_ITEM_ID = l_itemid
6595: AND S.SECONDARY_INVENTORY_NAME = l_subinv
6596: AND P.ORGANIZATION_ID = l_orgid

Line 6808: MTL_SECONDARY_INVENTORIES S,

6804: l_xlotctrl,
6805: l_xserctrl,
6806: l_xresloc
6807: FROM MTL_PARAMETERS P,
6808: MTL_SECONDARY_INVENTORIES S,
6809: MTL_SYSTEM_ITEMS I
6810: WHERE I.INVENTORY_ITEM_ID = l_itemid
6811: AND S.SECONDARY_INVENTORY_NAME = l_xsubinv
6812: AND P.ORGANIZATION_ID = l_xorgid