DBA Data[Home] [Help]

APPS.INV_PROCESS_TEMP dependencies on MTL_SYSTEM_ITEMS

Line 359: FROM MTL_SYSTEM_ITEMS MSI

355: (TRANSACTION_ACTION_ID <> 24
356: AND NVL(SHIPPABLE_FLAG,'Y') = 'Y'))
357: AND NOT EXISTS (
358: SELECT NULL
359: FROM MTL_SYSTEM_ITEMS MSI
360: WHERE MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
361: AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
362: AND MSI.INVENTORY_ITEM_FLAG = 'Y');
363: if(SQL%FOUND) then l_status := 0; else l_status := 1; end if;

Line 380: FROM MTL_SYSTEM_ITEMS MSI

376: AND TRANSACTION_STATUS = 3
377: AND TRANSACTION_ACTION_ID = 24
378: AND NOT EXISTS (
379: SELECT NULL
380: FROM MTL_SYSTEM_ITEMS MSI
381: WHERE MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
382: AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
383: AND MSI.INVENTORY_ITEM_FLAG = 'Y'
384: AND MSI.INVENTORY_ASSET_FLAG = 'Y'

Line 411: MTL_SYSTEM_ITEMS MSI

407: AND TRANSACTION_ACTION_ID NOT IN (24,33,34)
408: AND NOT EXISTS (
409: SELECT NULL
410: FROM MTL_ITEM_REVISIONS MIR,
411: MTL_SYSTEM_ITEMS MSI
412: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
413: AND MIR.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
414: AND MIR.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
415: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID

Line 422: FROM MTL_SYSTEM_ITEMS ITM

418: AND MIR.ORGANIZATION_ID = MSI.ORGANIZATION_ID
419: AND MIR.REVISION = MMTT.REVISION
420: UNION
421: SELECT NULL
422: FROM MTL_SYSTEM_ITEMS ITM
423: WHERE ITM.REVISION_QTY_CONTROL_CODE = 1
424: AND MMTT.REVISION IS NULL
425: AND ITM.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
426: AND ITM.ORGANIZATION_ID = MMTT.ORGANIZATION_ID);

Line 454: FROM MTL_SYSTEM_ITEMS MSI

450: AND PROCESS_FLAG = 1
451: AND NVL(SHIPPABLE_FLAG,'Y') = 'Y'
452: AND NOT EXISTS (
453: SELECT NULL
454: FROM MTL_SYSTEM_ITEMS MSI
455: WHERE MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
456: AND MSI.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION
457: AND MSI.MTL_TRANSACTIONS_ENABLED_FLAG = 'Y'); */
458:

Line 474: FROM MTL_SYSTEM_ITEMS MSI

470: AND PROCESS_FLAG = 'Y'
471: AND NVL(SHIPPABLE_FLAG,'Y') = 'Y'
472: AND NOT EXISTS (
473: SELECT NULL
474: FROM MTL_SYSTEM_ITEMS MSI
475: WHERE MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
476: AND MSI.ORGANIZATION_ID = MMTT.TRANSFER_ORGANIZATION
477: AND MSI.MTL_TRANSACTIONS_ENABLED_FLAG = 'Y');
478: if SQL%FOUND then return 0; else return 1; end if;

Line 505: MTL_SYSTEM_ITEMS MSI

501: AND TRANSACTION_ACTION_ID = 3
502: AND NOT EXISTS (
503: SELECT NULL
504: FROM MTL_ITEM_REVISIONS MIR,
505: MTL_SYSTEM_ITEMS MSI
506: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
507: AND MIR.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
508: AND MIR.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION
509: AND MIR.REVISION = MTI.REVISION

Line 516: FROM MTL_SYSTEM_ITEMS ITM

512: AND MIR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
513: AND MIR.ORGANIZATION_ID = MSI.ORGANIZATION_ID
514: UNION
515: SELECT NULL
516: FROM MTL_SYSTEM_ITEMS ITM
517: WHERE ITM.REVISION_QTY_CONTROL_CODE = 1
518: AND MTI.REVISION IS NULL
519: AND ITM.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID
520: AND ITM.ORGANIZATION_ID = MTI.TRANSFER_ORGANIZATION); */

Line 537: MTL_SYSTEM_ITEMS MSI

533: AND TRANSACTION_ACTION_ID = 3
534: AND NOT EXISTS (
535: SELECT NULL
536: FROM MTL_ITEM_REVISIONS MIR,
537: MTL_SYSTEM_ITEMS MSI
538: WHERE MSI.REVISION_QTY_CONTROL_CODE = 2
539: AND MIR.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
540: AND MIR.ORGANIZATION_ID = MMTT.TRANSFER_ORGANIZATION
541: AND MIR.REVISION = MMTT.REVISION

Line 548: FROM MTL_SYSTEM_ITEMS ITM

544: AND MIR.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
545: AND MIR.ORGANIZATION_ID = MSI.ORGANIZATION_ID
546: UNION
547: SELECT NULL
548: FROM MTL_SYSTEM_ITEMS ITM
549: WHERE ITM.REVISION_QTY_CONTROL_CODE = 1
550: -- AND MTI.REVISION IS NULL not required as per bug 3285134
551: AND ITM.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
552: AND ITM.ORGANIZATION_ID = MMTT.TRANSFER_ORGANIZATION);

Line 614: MTL_SYSTEM_ITEMS MSI

610: AND TRANSACTION_STATUS = 3
611: AND NOT EXISTS (
612: SELECT NULL
613: FROM MTL_ITEM_SUB_INVENTORIES MIS,
614: MTL_SYSTEM_ITEMS MSI
615: WHERE MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
616: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
617: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1
618: AND MIS.ORGANIZATION_ID = MMTT.ORGANIZATION_ID

Line 625: FROM MTL_SYSTEM_ITEMS ITM

621: AND MIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
622: AND MIS.SECONDARY_INVENTORY = MMTT.SUBINVENTORY_CODE
623: UNION
624: SELECT NULL
625: FROM MTL_SYSTEM_ITEMS ITM
626: WHERE ITM.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
627: AND ITM.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
628: AND ITM.RESTRICT_SUBINVENTORIES_CODE = 2);
629: if SQL%FOUND then l_status := 0; end if;

Line 679: MTL_SYSTEM_ITEMS MSI

675: AND LOCATOR_ID IS NOT NULL
676: AND NOT EXISTS (
677: SELECT NULL
678: FROM MTL_SECONDARY_LOCATORS MSL,
679: MTL_SYSTEM_ITEMS MSI
680: WHERE MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
681: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
682: AND MSI.RESTRICT_LOCATORS_CODE = 1
683: AND MSL.ORGANIZATION_ID = MMTT.ORGANIZATION_ID

Line 691: FROM MTL_SYSTEM_ITEMS ITM

687: AND MSL.SUBINVENTORY_CODE = MMTT.SUBINVENTORY_CODE
688: AND MSL.SECONDARY_LOCATOR = MMTT.LOCATOR_ID
689: UNION
690: SELECT NULL
691: FROM MTL_SYSTEM_ITEMS ITM
692: WHERE ITM.RESTRICT_LOCATORS_CODE = 2
693: AND ITM.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
694: AND ITM.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID);
695: if SQL%FOUND then l_status := 0; end if;

Line 762: MTL_SYSTEM_ITEMS MSI

758: AND TRANSACTION_ACTION_ID in (2,21,3)
759: AND NOT EXISTS (
760: SELECT NULL
761: FROM MTL_ITEM_SUB_INVENTORIES MIS,
762: MTL_SYSTEM_ITEMS MSI
763: WHERE MSI.ORGANIZATION_ID = decode(MMTT.TRANSACTION_ACTION_ID, 2,
764: MMTT.ORGANIZATION_ID, MMTT.TRANSFER_ORGANIZATION)
765: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
766: AND MSI.RESTRICT_SUBINVENTORIES_CODE = 1

Line 775: FROM MTL_SYSTEM_ITEMS ITM

771: AND MIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
772: AND MIS.SECONDARY_INVENTORY = MMTT.TRANSFER_SUBINVENTORY
773: UNION
774: SELECT NULL
775: FROM MTL_SYSTEM_ITEMS ITM
776: WHERE ITM.ORGANIZATION_ID = decode(MMTT.TRANSACTION_ACTION_ID, 2,
777: MMTT.ORGANIZATION_ID, MMTT.TRANSFER_ORGANIZATION)
778: AND ITM.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
779: AND ITM.RESTRICT_SUBINVENTORIES_CODE = 2);

Line 833: MTL_SYSTEM_ITEMS MSI

829: AND TRANSFER_TO_LOCATION IS NOT NULL
830: AND NOT EXISTS (
831: SELECT NULL
832: FROM MTL_SECONDARY_LOCATORS MSL,
833: MTL_SYSTEM_ITEMS MSI
834: WHERE MSI.ORGANIZATION_ID = decode(MMTT.TRANSACTION_ACTION_ID, 2,
835: MMTT.ORGANIZATION_ID, MMTT.TRANSFER_ORGANIZATION)
836: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
837: AND MSI.RESTRICT_LOCATORS_CODE = 1

Line 847: FROM MTL_SYSTEM_ITEMS MSI

843: AND MSL.SUBINVENTORY_CODE = MMTT.TRANSFER_SUBINVENTORY
844: AND MSL.SECONDARY_LOCATOR = MMTT.TRANSFER_TO_LOCATION
845: UNION
846: SELECT NULL
847: FROM MTL_SYSTEM_ITEMS MSI
848: WHERE MSI.ORGANIZATION_ID = decode(MMTT.TRANSACTION_ACTION_ID, 2,
849: MMTT.ORGANIZATION_ID, MMTT.TRANSFER_ORGANIZATION)
850: AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
851: AND MSI.RESTRICT_LOCATORS_CODE = 2);

Line 1110: FROM MTL_SYSTEM_ITEMS MS1,

1106: AND TRANSACTION_STATUS = 3
1107: AND TRANSACTION_ACTION_ID = 3
1108: AND EXISTS (
1109: SELECT NULL
1110: FROM MTL_SYSTEM_ITEMS MS1,
1111: MTL_SYSTEM_ITEMS MS2
1112: WHERE MS1.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1113: AND MS1.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1114: AND MS2.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID

Line 1111: MTL_SYSTEM_ITEMS MS2

1107: AND TRANSACTION_ACTION_ID = 3
1108: AND EXISTS (
1109: SELECT NULL
1110: FROM MTL_SYSTEM_ITEMS MS1,
1111: MTL_SYSTEM_ITEMS MS2
1112: WHERE MS1.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1113: AND MS1.ORGANIZATION_ID = MMTT.ORGANIZATION_ID
1114: AND MS2.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID
1115: AND MS2.ORGANIZATION_ID = MMTT.TRANSFER_ORGANIZATION