APPS.MTL_DEFAULT_CATEGORY_SETS_PKG dependencies on DUAL

Line 114: FROM dual

110: Begin
111:
112: Select 'X'
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'

Line 269: FROM dual

265: Begin
266:
267: Select 'X'
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

Line 440: FROM dual

436: Begin
437:
438: Select 'X'
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'

Line 473: FROM dual

469: Begin
470:
471: Select 'X'
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'

Line 596: FROM dual

592: Begin
593:
594: Select 'X'
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

Line 754: FROM DUAL

750: END IF;
751:
752: SELECT 'X'
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'