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.MTL_DEFAULT_CATEGORY_SETS_PKG dependencies on MTL_ITEM_CATEGORIES

Line 121: From MTL_ITEM_CATEGORIES Cat

117: From MTL_SYSTEM_ITEMS_B Item
118: Where Item.INVENTORY_ITEM_FLAG = 'Y'
119: And NOT EXISTS
120: ( Select 'X'
121: From MTL_ITEM_CATEGORIES Cat
122: Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
123: And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
124: And Cat.CATEGORY_SET_ID = P_Category_Set_Id
125: )

Line 239: From MTL_ITEM_CATEGORIES Cat

235: Where ( Item.PURCHASING_ITEM_FLAG = 'Y' OR
236: Item.INTERNAL_ORDER_FLAG = 'Y' )
237: And NOT EXISTS
238: ( Select 'X'
239: From MTL_ITEM_CATEGORIES Cat
240: Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
241: And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
242: And Cat.CATEGORY_SET_ID = P_Category_Set_Id
243: );

Line 276: From MTL_ITEM_CATEGORIES Cat

272: From MTL_SYSTEM_ITEMS_B Item
273: Where Item.MRP_PLANNING_CODE <> 6
274: And NOT EXISTS
275: ( Select 'X'
276: From MTL_ITEM_CATEGORIES Cat
277: Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
278: And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
279: And Cat.CATEGORY_SET_ID = P_Category_Set_Id
280: )

Line 410: From MTL_ITEM_CATEGORIES Cat

406: From MTL_SYSTEM_ITEMS_B Item
407: Where Item.COSTING_ENABLED_FLAG = 'Y'
408: And NOT EXISTS
409: ( Select 'X'
410: From MTL_ITEM_CATEGORIES Cat
411: Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
412: And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
413: And Cat.CATEGORY_SET_ID = P_Category_Set_Id
414: );

Line 447: From MTL_ITEM_CATEGORIES Cat

443: From MTL_SYSTEM_ITEMS_B Item
444: Where Item.ENG_ITEM_FLAG = 'Y'
445: And NOT EXISTS
446: ( Select 'X'
447: From MTL_ITEM_CATEGORIES Cat
448: Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
449: And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
450: And Cat.CATEGORY_SET_ID = P_Category_Set_Id
451: )

Line 480: From MTL_ITEM_CATEGORIES Cat

476: From MTL_SYSTEM_ITEMS_B Item
477: Where Item.CUSTOMER_ORDER_FLAG = 'Y'
478: And NOT EXISTS
479: ( Select 'X'
480: From MTL_ITEM_CATEGORIES Cat
481: Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
482: And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
483: And Cat.CATEGORY_SET_ID = P_Category_Set_Id
484: )

Line 527: FROM MTL_ITEM_CATEGORIES Cat

523: WHERE
524: Item.EAM_ITEM_TYPE IS NOT NULL
525: AND NOT EXISTS
526: ( SELECT 'X'
527: FROM MTL_ITEM_CATEGORIES Cat
528: WHERE
529: Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
530: AND Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
531: AND Cat.CATEGORY_SET_ID = P_Category_Set_Id

Line 552: FROM MTL_ITEM_CATEGORIES Cat

548: WHERE
549: Item.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE', 'WARRANTY')
550: AND NOT EXISTS
551: ( SELECT 'X'
552: FROM MTL_ITEM_CATEGORIES Cat
553: WHERE
554: Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
555: AND Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
556: AND Cat.CATEGORY_SET_ID = P_Category_Set_Id

Line 576: FROM MTL_ITEM_CATEGORIES Cat

572: WHERE
573: Item.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE', 'WARRANTY', 'SUBSCRIPTION', 'USAGE')
574: AND NOT EXISTS
575: ( SELECT 'X'
576: FROM MTL_ITEM_CATEGORIES Cat
577: WHERE
578: Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
579: AND Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
580: AND Cat.CATEGORY_SET_ID = P_Category_Set_Id

Line 604: From MTL_ITEM_CATEGORIES Cat

600: Where ( Item.CUSTOMER_ORDER_FLAG = 'Y' OR
601: Item.INTERNAL_ORDER_FLAG = 'Y' )
602: And NOT EXISTS
603: ( Select 'X'
604: From MTL_ITEM_CATEGORIES Cat
605: Where Cat.INVENTORY_ITEM_ID = Item.INVENTORY_ITEM_ID
606: And Cat.ORGANIZATION_ID = Item.ORGANIZATION_ID
607: And Cat.CATEGORY_SET_ID = P_Category_Set_Id
608: )

Line 631: From MTL_ITEM_CATEGORIES Cat,

627: Begin
628:
629: Select 'X'
630: Into buffer
631: From MTL_ITEM_CATEGORIES Cat,
632: MTL_DEFAULT_CATEGORY_SETS DefCat
633: Where DefCat.FUNCTIONAL_AREA_ID = 12
634: And DefCat.CATEGORY_SET_ID = Cat.CATEGORY_SET_ID
635: And NOT EXISTS

Line 637: From MTL_ITEM_CATEGORIES Cat1

633: Where DefCat.FUNCTIONAL_AREA_ID = 12
634: And DefCat.CATEGORY_SET_ID = Cat.CATEGORY_SET_ID
635: And NOT EXISTS
636: ( Select 'X'
637: From MTL_ITEM_CATEGORIES Cat1
638: Where Cat1.INVENTORY_ITEM_ID = Cat.INVENTORY_ITEM_ID
639: And Cat1.ORGANIZATION_ID = Cat.ORGANIZATION_ID
640: And Cat1.CATEGORY_SET_ID = P_Category_Set_Id
641: )

Line 662: From MTL_ITEM_CATEGORIES Cat,

658: Begin
659:
660: Select 'X'
661: Into buffer
662: From MTL_ITEM_CATEGORIES Cat,
663: MTL_DEFAULT_CATEGORY_SETS DefCat
664: Where DefCat.FUNCTIONAL_AREA_ID = 21
665: And DefCat.CATEGORY_SET_ID = Cat.CATEGORY_SET_ID
666: And NOT EXISTS

Line 668: From MTL_ITEM_CATEGORIES Cat1

664: Where DefCat.FUNCTIONAL_AREA_ID = 21
665: And DefCat.CATEGORY_SET_ID = Cat.CATEGORY_SET_ID
666: And NOT EXISTS
667: ( Select 'X'
668: From MTL_ITEM_CATEGORIES Cat1
669: Where Cat1.INVENTORY_ITEM_ID = Cat.INVENTORY_ITEM_ID
670: And Cat1.ORGANIZATION_ID = Cat.ORGANIZATION_ID
671: And Cat1.CATEGORY_SET_ID = P_Category_Set_Id
672: )

Line 764: FROM mtl_item_categories cat

760: FROM org_organization_definitions ood
761: WHERE ood.inventory_enabled_flag = 'Y')
762: AND NOT EXISTS
763: (SELECT 'X'
764: FROM mtl_item_categories cat
765: WHERE cat.inventory_item_id = item.inventory_item_id
766: AND cat.organization_id = item.organization_id
767: AND cat.category_set_id = P_Category_Set_Id));
768: