DBA Data[Home] [Help]

APPS.BOM_PFI_PVT dependencies on DUAL

Line 71: from dual ;

67: v_user_id := fnd_global.user_id;
68:
69: select userenv('LANG')
70: into l_Source_Lang
71: from dual ;
72:
73: IF ( SQL%NOTFOUND ) THEN
74: RAISE no_data_found;
75: END IF;

Line 117: from dual ;

113: l_stmt_num := 3 ;
114:
115: select MTL_CATEGORIES_S.nextval
116: into l_New_Category_ID
117: from dual ;
118:
119: INSERT INTO MTL_CATEGORIES_B
120: (
121: CATEGORY_ID ,

Line 475: FROM dual

471: v_user_id ,
472: sysdate ,
473: v_user_id ,
474: null
475: FROM dual
476: WHERE NOT EXISTS
477: ( SELECT 'x'
478: FROM MTL_ITEM_CATEGORIES icat
479: WHERE icat.INVENTORY_ITEM_ID = l_item_id