APPS.EGO_IMPORT_UTIL_PVT dependencies on DUAL

Line 3065: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';

3061: AND NVL(ag_ext.VARIANT, 'N') = 'N'
3062: AND ext_intf.DATA_LEVEL_ID = #' || l_item_org_dl_id;
3063:
3064: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3065: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3066: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Org Level UDAs');
3067:
3068: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3069: (

Line 3162: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';

3158: AND eia.PK1_VALUE = eiai.PK1_VALUE
3159: )#';
3160:
3161: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3162: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3163: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Supplier Level UDAs');
3164:
3165: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3166: (

Line 3262: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';

3258: AND eia.PK2_VALUE = eiai.PK2_VALUE
3259: )#';
3260:
3261: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3262: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3263: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Supplier Site Level UDAs');
3264:
3265: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3266: (

Line 3364: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';

3360: AND eia.PK2_VALUE = eiai.PK2_VALUE
3361: )#';
3362:
3363: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3364: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3365: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Supplier Site Org Level UDAs');
3366:
3367: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3368: (

Line 4396: FROM DUAL

4392: 'CREATE',
4393: i.ITEM_CATALOG_GROUP_ID,
4394: i.ITEM_CATALOG_GROUP_NAME,
4395: -99
4396: FROM DUAL
4397: WHERE NOT EXISTS (SELECT 1
4398: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII2
4399: WHERE MSII2.SET_PROCESS_ID = p_batch_id
4400: AND MSII2.PROCESS_FLAG = 1