DBA Data[Home] [Help]

APPS.EGO_ICC_BULKLOAD_PVT dependencies on EGO_CATALOG_GROUPS_V

Line 1490: ego_catalog_groups_v cg

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
1493: AND cg.catalog_group_id = oagv.classification_code
1494: AND oagv.object_id = g_item_obj_id

Line 1522: ego_catalog_groups_v cg

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
1525: AND cg.catalog_group_id = oagv.classification_code
1526: AND oagv.object_id = g_item_obj_id

Line 4435: ego_catalog_groups_v cg

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
4438: AND cg.catalog_group_id = oagv.classification_code
4439: AND oagv.object_id = g_item_obj_id