APPS.MTL_DEFAULT_CATEGORY_SETS_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 112: From MTL_SYSTEM_ITEMS_B Item

108: Into buffer
109: FROM dual
110: WHERE EXISTS (
111: SELECT 'X'
112: From MTL_SYSTEM_ITEMS_B Item
113: Where Item.INVENTORY_ITEM_FLAG = 'Y'
114: And NOT EXISTS
115: ( Select 'X'
116: From MTL_ITEM_CATEGORIES Cat

Line 229: From MTL_SYSTEM_ITEMS_B Item

225:
226: Sql_Stmt := 4;
227: Select DISTINCT 'X'
228: Into buffer
229: From MTL_SYSTEM_ITEMS_B Item
230: Where ( Item.PURCHASING_ITEM_FLAG = 'Y' OR
231: Item.INTERNAL_ORDER_FLAG = 'Y' )
232: And NOT EXISTS
233: ( Select 'X'

Line 267: From MTL_SYSTEM_ITEMS_B Item

263: Into buffer
264: FROM dual
265: WHERE EXISTS (
266: SELECT 'X'
267: From MTL_SYSTEM_ITEMS_B Item
268: Where Item.MRP_PLANNING_CODE <> 6
269: And NOT EXISTS
270: ( Select 'X'
271: From MTL_ITEM_CATEGORIES Cat

Line 401: From MTL_SYSTEM_ITEMS_B Item

397:
398: Sql_Stmt := 4;
399: Select DISTINCT 'X'
400: Into buffer
401: From MTL_SYSTEM_ITEMS_B Item
402: Where Item.COSTING_ENABLED_FLAG = 'Y'
403: And NOT EXISTS
404: ( Select 'X'
405: From MTL_ITEM_CATEGORIES Cat

Line 438: From MTL_SYSTEM_ITEMS_B Item

434: Into buffer
435: FROM dual
436: WHERE EXISTS (
437: SELECT 'X'
438: From MTL_SYSTEM_ITEMS_B Item
439: Where Item.ENG_ITEM_FLAG = 'Y'
440: And NOT EXISTS
441: ( Select 'X'
442: From MTL_ITEM_CATEGORIES Cat

Line 471: From MTL_SYSTEM_ITEMS_B Item

467: Into buffer
468: FROM dual
469: WHERE EXISTS (
470: SELECT 'X'
471: From MTL_SYSTEM_ITEMS_B Item
472: Where Item.CUSTOMER_ORDER_FLAG = 'Y'
473: And NOT EXISTS
474: ( Select 'X'
475: From MTL_ITEM_CATEGORIES Cat

Line 517: FROM MTL_SYSTEM_ITEMS_B Item

513: BEGIN
514:
515: SELECT DECODE( COUNT(*), 0, 0, -1 )
516: INTO l_count
517: FROM MTL_SYSTEM_ITEMS_B Item
518: WHERE
519: Item.EAM_ITEM_TYPE IS NOT NULL
520: AND NOT EXISTS
521: ( SELECT 'X'

Line 542: FROM MTL_SYSTEM_ITEMS_B Item

538: BEGIN
539:
540: SELECT DECODE( COUNT(*), 0, 0, -1 )
541: INTO l_count
542: FROM MTL_SYSTEM_ITEMS_B Item
543: WHERE
544: Item.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE', 'WARRANTY')
545: AND NOT EXISTS
546: ( SELECT 'X'

Line 566: FROM MTL_SYSTEM_ITEMS_B Item

562: BEGIN
563:
564: SELECT DECODE( COUNT(*), 0, 0, -1 )
565: INTO l_count
566: FROM MTL_SYSTEM_ITEMS_B Item
567: WHERE
568: Item.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE', 'WARRANTY', 'SUBSCRIPTION', 'USAGE')
569: AND NOT EXISTS
570: ( SELECT 'X'

Line 594: From MTL_SYSTEM_ITEMS_B Item

590: Into buffer
591: FROM dual
592: WHERE EXISTS (
593: SELECT 'X'
594: From MTL_SYSTEM_ITEMS_B Item
595: Where ( Item.CUSTOMER_ORDER_FLAG = 'Y' OR
596: Item.INTERNAL_ORDER_FLAG = 'Y' )
597: And NOT EXISTS
598: ( Select 'X'