DBA Data[Home] [Help]

APPS.EGO_ICC_BULKLOAD_PVT dependencies on EGO_OBJ_ATTR_GRP_ASSOCS_V

Line 1489: ego_obj_attr_grp_assocs_v oagv,

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

Line 1521: ego_obj_attr_grp_assocs_v oagv,

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

Line 4434: ego_obj_attr_grp_assocs_v oagv,

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