APPS.EGO_IMPORT_UTIL_PVT dependencies on DUAL

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

3251: AND NVL(ag_ext.VARIANT, 'N') = 'N'
3252: AND ext_intf.DATA_LEVEL_ID = #' || l_item_org_dl_id;
3253:
3254: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3255: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3256: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Org Level UDAs');
3257:
3258: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3259: (

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

3348: AND eia.PK1_VALUE = eiai.PK1_VALUE
3349: )#';
3350:
3351: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3352: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3353: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Supplier Level UDAs');
3354:
3355: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3356: (

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

3448: AND eia.PK2_VALUE = eiai.PK2_VALUE
3449: )#';
3450:
3451: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3452: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3453: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Supplier Site Level UDAs');
3454:
3455: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3456: (

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

3550: AND eia.PK2_VALUE = eiai.PK2_VALUE
3551: )#';
3552:
3553: -- when copying from interface to interface, we do not need l_ag_sql, so passing dummy value
3554: l_ag_sql := 'SELECT NULL AS ATTR_GROUP_ID FROM DUAL WHERE 1 = 2';
3555: Debug_Conc_Log('Default_User_Attrs_From_Intf: Defaulting Item Supplier Site Org Level UDAs');
3556:
3557: EGO_ITEM_USER_ATTRS_CP_PUB.Copy_data_to_Intf
3558: (

Line 5093: FROM DUAL

5089: 'CREATE',
5090: i.ITEM_CATALOG_GROUP_ID,
5091: i.ITEM_CATALOG_GROUP_NAME,
5092: -99
5093: FROM DUAL
5094: WHERE NOT EXISTS (SELECT 1
5095: FROM MTL_SYSTEM_ITEMS_INTERFACE MSII2
5096: WHERE MSII2.SET_PROCESS_ID = p_batch_id
5097: AND MSII2.PROCESS_FLAG = 1