APPS.INV_EBI_ITEM_HELPER dependencies on EGO_OBJ_ATTR_GRP_ASSOCS_V

Line 1984: FROM ego_obj_attr_grp_assocs_v

1980: LOOP
1981: l_attributes_row_obj := l_attributes_row_table(i);
1982: IF(l_attributes_row_table(i).attr_group_id IS NOT NULL AND p_item_catalog_group_id IS NOT NULL ) THEN
1983: SELECT data_level_int_name INTO l_data_level
1984: FROM ego_obj_attr_grp_assocs_v
1985: WHERE attr_group_id = l_attributes_row_table(i).attr_group_id
1986: AND classification_code = TO_CHAR(p_item_catalog_group_id);
1987: END IF;
1988: IF (l_data_level = INV_EBI_ITEM_PUB.g_data_level_item_rev ) THEN

Line 3136: ego_obj_attr_grp_assocs_v ass,

3132: att.attr_name,
3133: ass.attr_group_id,
3134: ass.data_level_int_name
3135: FROM
3136: ego_obj_attr_grp_assocs_v ass,
3137: ego_attrs_v att
3138: WHERE ass.classification_code = TO_CHAR(p_classification_id)
3139: AND ass.attr_group_type = att.attr_group_type
3140: AND att.attr_group_type = p_attr_group_type

Line 3162: FROM ego_obj_attr_grp_assocs_v

3158:
3159: IF(p_attr_group_type = INV_EBI_UTIL.G_EGO_ITEMMGMT_GROUP) THEN
3160:
3161: SELECT data_level_int_name INTO l_data_level
3162: FROM ego_obj_attr_grp_assocs_v
3163: WHERE attr_group_id = p_attr_grp_id_tbl(i)
3164: AND classification_code = TO_CHAR(p_classification_id);
3165:
3166: ELSE

Line 3173: FROM ego_obj_attr_grp_assocs_v

3169:
3170: END IF;
3171:
3172: SELECT attr_group_name INTO l_attr_group_name
3173: FROM ego_obj_attr_grp_assocs_v
3174: WHERE
3175: attr_group_id = p_attr_grp_id_tbl(i) AND
3176: classification_code = TO_CHAR(p_classification_id) AND
3177: data_level_int_name = l_data_level;

Line 3315: ego_obj_attr_grp_assocs_v ass

3311: CURSOR c_attr_group_id IS
3312: SELECT DISTINCT ems.attr_group_id
3313: FROM
3314: ego_mtl_sy_items_ext_vl ems,
3315: ego_obj_attr_grp_assocs_v ass
3316: WHERE
3317: ems.inventory_item_id = p_inventory_item_id AND
3318: ems.organization_id = p_organization_id AND
3319: ems.item_catalog_group_id = p_item_classification_id AND