APPS.EGO_ICC_BULKLOAD_PVT dependencies on EGO_ATTR_GROUPS_V

Line 1236: from ego_attr_groups_v EAGv

1232: ---
1233:
1234: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE EAGAI
1235: SET attr_group_name = ( select eagv.attr_group_name
1236: from ego_attr_groups_v EAGv
1237: where EAGv.attr_group_id = EAGAI.attr_group_id
1238: )
1239: WHERE eagai.attr_group_id IS NOT NULL
1240: AND eagai.process_status = G_PROCESS_STATUS_INITIAL

Line 1254: from ego_attr_groups_v EAGv

1250: ---
1251:
1252: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE EAGAI
1253: SET attr_group_id = ( select eagv.attr_group_id
1254: from ego_attr_groups_v EAGv
1255: where EAGv.attr_group_name = EAGAI.attr_group_name
1256: )
1257: WHERE eagai.attr_group_id IS NULL
1258: AND eagai.attr_group_name IS NOT NULL

Line 1488: FROM ego_attr_groups_v agv,

1484: --- Get the Attr group name
1485: ---
1486: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1487: set efpmi.attr_group_name =( SELECT agv.attr_group_id
1488: FROM ego_attr_groups_v agv,
1489: ego_obj_attr_grp_assocs_v oagv,
1490: ego_catalog_groups_v cg
1491: WHERE oagv.attr_group_id = agv.attr_group_id
1492: AND agv.attr_group_id = EFPMI.ATTR_GROUP_ID

Line 1520: FROM ego_attr_groups_v agv,

1516: -- Attr Group id
1517:
1518: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1519: set efpmi.attr_group_id = ( SELECT agv.attr_group_id
1520: FROM ego_attr_groups_v agv,
1521: ego_obj_attr_grp_assocs_v oagv,
1522: ego_catalog_groups_v cg
1523: WHERE oagv.attr_group_id = agv.attr_group_id
1524: AND agv.attr_group_name = EFPMI.ATTR_GROUP_NAME

Line 4433: FROM ego_attr_groups_v agv,

4429:
4430: cursor cur_ag_assoc
4431: is
4432: SELECT oagv.association_id
4433: FROM ego_attr_groups_v agv,
4434: ego_obj_attr_grp_assocs_v oagv,
4435: ego_catalog_groups_v cg
4436: WHERE oagv.attr_group_id = agv.attr_group_id
4437: AND agv.attr_group_id = p_attr_group_id