DBA Data[Home] [Help]

APPS.MTL_DEFAULT_CATEGORY_SETS_PKG dependencies on DUAL

Line 109: FROM dual

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'

Line 264: FROM dual

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

Line 435: FROM dual

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'

Line 468: FROM dual

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'

Line 591: FROM dual

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