105: Begin
106:
107: Select 'X'
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'
260: Begin
261:
262: Select 'X'
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
431: Begin
432:
433: Select 'X'
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'
464: Begin
465:
466: Select 'X'
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'
587: Begin
588:
589: Select 'X'
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