APPS.INV_EBI_ITEM_HELPER dependencies on EGO_OBJ_ATTR_GRP_ASSOCS_V

Line 2689: FROM ego_obj_attr_grp_assocs_v

2685: p_item_catalog_group_id NUMBER,
2686: p_attr_grp_id NUMBER) IS
2687:
2688: SELECT data_level_int_name
2689: FROM ego_obj_attr_grp_assocs_v
2690: WHERE attr_group_id = p_attr_grp_id
2691: AND classification_code IN( SELECT item_catalog_group_id
2692: FROM mtl_item_catalog_groups_kfv
2693: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id

Line 4580: ego_obj_attr_grp_assocs_v ass,

4576: att.attr_name,
4577: ass.attr_group_id,
4578: ass.data_level_int_name
4579: FROM
4580: ego_obj_attr_grp_assocs_v ass,
4581: ego_attrs_v att
4582: WHERE ass.classification_code = TO_CHAR(p_classification_id)
4583: AND ass.attr_group_type = att.attr_group_type
4584: AND att.attr_group_type = p_attr_group_type

Line 4612: FROM ego_obj_attr_grp_assocs_v

4608: p_item_catalog_group_id NUMBER,
4609: p_attr_grp_id NUMBER) IS
4610:
4611: SELECT data_level_int_name
4612: FROM ego_obj_attr_grp_assocs_v
4613: WHERE attr_group_id = p_attr_grp_id
4614: AND classification_code IN( SELECT item_catalog_group_id
4615: FROM mtl_item_catalog_groups_kfv
4616: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id

Line 4636: FROM ego_obj_attr_grp_assocs_v

4632: IF(p_attr_group_type = INV_EBI_UTIL.G_EGO_ITEMMGMT_GROUP) THEN
4633:
4634: -- Commented out for bug 10397048
4635: /*SELECT data_level_int_name INTO l_data_level
4636: FROM ego_obj_attr_grp_assocs_v
4637: WHERE attr_group_id = p_attr_grp_id_tbl(i)
4638: AND classification_code = TO_CHAR(p_classification_id);*/
4639:
4640: -- An attribute group can have multiple data levels,but item revision level is mutually excelusive.

Line 4671: FROM ego_obj_attr_grp_assocs_v

4667: END IF;
4668:
4669: --Commented the query for bug 10397048
4670: /*SELECT attr_group_name INTO l_attr_group_name
4671: FROM ego_obj_attr_grp_assocs_v
4672: WHERE
4673: attr_group_id = p_attr_grp_id_tbl(i) AND
4674: classification_code = TO_CHAR(p_classification_id) AND
4675: data_level_int_name = l_data_level;*/

Line 4827: ego_obj_attr_grp_assocs_v ass

4823: CURSOR c_attr_group_id IS
4824: SELECT DISTINCT ems.attr_group_id
4825: FROM
4826: ego_mtl_sy_items_ext_vl ems,
4827: ego_obj_attr_grp_assocs_v ass
4828: WHERE
4829: ems.inventory_item_id = p_inventory_item_id AND
4830: ems.organization_id = p_organization_id AND
4831: ems.item_catalog_group_id IN ( SELECT item_catalog_group_id