APPS.MTL_DEFAULT_CATEGORY_SETS_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 117: From MTL_SYSTEM_ITEMS_B Item

113: Into buffer
114: FROM dual
115: WHERE EXISTS (
116: SELECT 'X'
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

Line 234: From MTL_SYSTEM_ITEMS_B Item

230:
231: Sql_Stmt := 4;
232: Select DISTINCT 'X'
233: Into buffer
234: From MTL_SYSTEM_ITEMS_B Item
235: Where ( Item.PURCHASING_ITEM_FLAG = 'Y' OR
236: Item.INTERNAL_ORDER_FLAG = 'Y' )
237: And NOT EXISTS
238: ( Select 'X'

Line 272: From MTL_SYSTEM_ITEMS_B Item

268: Into buffer
269: FROM dual
270: WHERE EXISTS (
271: SELECT 'X'
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

Line 406: From MTL_SYSTEM_ITEMS_B Item

402:
403: Sql_Stmt := 4;
404: Select DISTINCT 'X'
405: Into buffer
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

Line 443: From MTL_SYSTEM_ITEMS_B Item

439: Into buffer
440: FROM dual
441: WHERE EXISTS (
442: SELECT 'X'
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

Line 476: From MTL_SYSTEM_ITEMS_B Item

472: Into buffer
473: FROM dual
474: WHERE EXISTS (
475: SELECT 'X'
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

Line 522: FROM MTL_SYSTEM_ITEMS_B Item

518: BEGIN
519:
520: SELECT DECODE( COUNT(*), 0, 0, -1 )
521: INTO l_count
522: FROM MTL_SYSTEM_ITEMS_B Item
523: WHERE
524: Item.EAM_ITEM_TYPE IS NOT NULL
525: AND NOT EXISTS
526: ( SELECT 'X'

Line 547: FROM MTL_SYSTEM_ITEMS_B Item

543: BEGIN
544:
545: SELECT DECODE( COUNT(*), 0, 0, -1 )
546: INTO l_count
547: FROM MTL_SYSTEM_ITEMS_B Item
548: WHERE
549: Item.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE', 'WARRANTY')
550: AND NOT EXISTS
551: ( SELECT 'X'

Line 571: FROM MTL_SYSTEM_ITEMS_B Item

567: BEGIN
568:
569: SELECT DECODE( COUNT(*), 0, 0, -1 )
570: INTO l_count
571: FROM MTL_SYSTEM_ITEMS_B Item
572: WHERE
573: Item.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE', 'WARRANTY', 'SUBSCRIPTION', 'USAGE')
574: AND NOT EXISTS
575: ( SELECT 'X'

Line 599: From MTL_SYSTEM_ITEMS_B Item

595: Into buffer
596: FROM dual
597: WHERE EXISTS (
598: SELECT 'X'
599: From MTL_SYSTEM_ITEMS_B Item
600: Where ( Item.CUSTOMER_ORDER_FLAG = 'Y' OR
601: Item.INTERNAL_ORDER_FLAG = 'Y' )
602: And NOT EXISTS
603: ( Select 'X'

Line 757: FROM mtl_system_items_b item

753: INTO buffer
754: FROM DUAL
755: WHERE EXISTS
756: (SELECT 'X'
757: FROM mtl_system_items_b item
758: WHERE item.process_costing_enabled_flag = 'Y'
759: AND item.organization_id IN (SELECT ood.organization_id
760: FROM org_organization_definitions ood
761: WHERE ood.inventory_enabled_flag = 'Y')