APPS.EGO_ITEM_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_KFV

Line 668: l_current_category_name MTL_ITEM_CATALOG_GROUPS_KFV.concatenated_segments%TYPE;

664:
665: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
666: l_current_data_element EGO_USER_ATTR_ROW_OBJ;
667:
668: l_current_category_name MTL_ITEM_CATALOG_GROUPS_KFV.concatenated_segments%TYPE;
669: l_current_life_cycle PA_EGO_LIFECYCLES_V.NAME%TYPE;
670: l_current_phase_name PA_EGO_PHASES_V.NAME%TYPE;
671: l_policy_cat_id NUMBER;
672: l_catalog_category_names_table LOCAL_MEDIUM_VARCHAR_TABLE;

Line 755: FROM MTL_ITEM_CATALOG_GROUPS_KFV

751: l_current_category_name := l_catalog_category_names_table(l_policy_cat_id);
752: ELSE
753: SELECT concatenated_segments
754: INTO l_current_category_name
755: FROM MTL_ITEM_CATALOG_GROUPS_KFV
756: WHERE ITEM_CATALOG_GROUP_ID = l_policy_cat_id;
757: l_catalog_category_names_table(l_policy_cat_id) := l_current_category_name;
758: END IF;
759:

Line 2265: FROM MTL_ITEM_CATALOG_GROUPS_KFV

2261:
2262: l_token_table(1).TOKEN_NAME := 'CAT_GROUP_NAME';
2263: SELECT CONCATENATED_SEGMENTS
2264: INTO l_token_table(1).TOKEN_VALUE
2265: FROM MTL_ITEM_CATALOG_GROUPS_KFV
2266: WHERE ITEM_CATALOG_GROUP_ID = p_catalog_group_id;
2267:
2268: ERROR_HANDLER.Add_Error_Message(
2269: p_message_name => 'EGO_TOO_MANY_CAT_GROUPS'

Line 4131: FROM MTL_ITEM_CATALOG_GROUPS_KFV

4127: ,p_proj_element_id => l_curr_phase_id);
4128: fnd_message.set_token('PHASE', l_dummy_char);
4129: SELECT concatenated_segments
4130: INTO l_dummy_char
4131: FROM MTL_ITEM_CATALOG_GROUPS_KFV
4132: WHERE ITEM_CATALOG_GROUP_ID = (
4133: SELECT item_catalog_group_id
4134: FROM (SELECT item_catalog_group_id
4135: FROM mtl_item_catalog_groups_b ic