APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 271: SELECT COUNT(1) INTO l_count FROM MTL_SYSTEM_ITEMS MSI

267: --5. Validate Item
268: l_count := 0;
269:
270: BEGIN
271: SELECT COUNT(1) INTO l_count FROM MTL_SYSTEM_ITEMS MSI
272: WHERE MSI.INVENTORY_ITEM_ID = p_mtl_trx_tbl(i).inventory_item_id
273: AND MSI.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id
274: AND MSI.INVENTORY_ITEM_FLAG = 'Y';
275: EXCEPTION

Line 306: SELECT COUNT(1) INTO l_count FROM MTL_SYSTEM_ITEMS MSI

302: (INV_GLOBALS.G_ACTION_LOGICALICSALES, INV_GLOBALS.G_ACTION_LOGICALICRECEIPT,
303: INV_GLOBALS.G_ACTION_LOGICALICRCPTRETURN, INV_GLOBALS.G_ACTION_LOGICALICSALESRETURN,
304: INV_GLOBALS.G_ACTION_LOGICALEXPREQRECEIPT))THEN
305: BEGIN
306: SELECT COUNT(1) INTO l_count FROM MTL_SYSTEM_ITEMS MSI
307: WHERE MSI.INVENTORY_ITEM_ID = p_mtl_trx_tbl(i).inventory_item_id
308: AND MSI.ORGANIZATION_ID = p_mtl_trx_tbl(i).transfer_organization_id
309: AND MSI.INVENTORY_ITEM_FLAG = 'Y';
310: EXCEPTION

Line 445: MTL_SYSTEM_ITEMS MSI

441: BEGIN
442: SELECT 1 INTO l_count FROM dual WHERE exists
443: (
444: SELECT null FROM MTL_SECONDARY_INVENTORIES MTSI,
445: MTL_SYSTEM_ITEMS MSI
446: WHERE MSI.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id
447: AND MSI.INVENTORY_ITEM_ID = p_mtl_trx_tbl(i).inventory_item_id
448: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1
449: AND MTSI.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id

Line 455: SELECT NULL FROM MTL_SYSTEM_ITEMS ITM

451: AND MTSI.ORGANIZATION_ID = MSI.ORGANIZATION_ID
452: -- AND MTSI.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
453: AND MTSI.SECONDARY_INVENTORY_NAME = p_mtl_trx_tbl(i).subinventory_code
454: UNION
455: SELECT NULL FROM MTL_SYSTEM_ITEMS ITM
456: WHERE ITM.RESTRICT_SUBINVENTORIES_CODE = 2
457: AND ITM.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id
458: AND ITM.INVENTORY_ITEM_ID = p_mtl_trx_tbl(i).inventory_item_id);
459: EXCEPTION

Line 520: MTL_SYSTEM_ITEMS MSI

516: BEGIN
517: SELECT 1 INTO l_count FROM dual WHERE exists
518: (
519: SELECT null FROM MTL_SECONDARY_LOCATORS MSL,
520: MTL_SYSTEM_ITEMS MSI
521: WHERE MSI.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id
522: AND MSI.INVENTORY_ITEM_ID = p_mtl_trx_tbl(i).inventory_item_id
523: AND MSI.RESTRICT_LOCATORS_CODE = 1
524: AND MSL.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id

Line 531: SELECT NULL FROM MTL_SYSTEM_ITEMS ITM

527: AND MSL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
528: AND MSL.SUBINVENTORY_CODE = p_mtl_trx_tbl(i).subinventory_code
529: AND MSL.SECONDARY_LOCATOR = p_mtl_trx_tbl(i).locator_id
530: UNION
531: SELECT NULL FROM MTL_SYSTEM_ITEMS ITM
532: WHERE ITM.RESTRICT_LOCATORS_CODE = 2
533: AND ITM.ORGANIZATION_ID = p_mtl_trx_tbl(i).organization_id
534: AND ITM.INVENTORY_ITEM_ID = p_mtl_trx_tbl(i).inventory_item_id);
535: EXCEPTION