APPS.EGO_ITEM_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_KFV

Line 672: l_current_category_name MTL_ITEM_CATALOG_GROUPS_KFV.concatenated_segments%TYPE;

668:
669: l_attributes_row_table EGO_USER_ATTR_ROW_TABLE;
670: l_current_data_element EGO_USER_ATTR_ROW_OBJ;
671:
672: l_current_category_name MTL_ITEM_CATALOG_GROUPS_KFV.concatenated_segments%TYPE;
673: l_current_life_cycle PA_EGO_LIFECYCLES_V.NAME%TYPE;
674: l_current_phase_name PA_EGO_PHASES_V.NAME%TYPE;
675: l_policy_cat_id NUMBER;
676: l_catalog_category_names_table LOCAL_MEDIUM_VARCHAR_TABLE;

Line 759: FROM MTL_ITEM_CATALOG_GROUPS_KFV

755: l_current_category_name := l_catalog_category_names_table(l_policy_cat_id);
756: ELSE
757: SELECT concatenated_segments
758: INTO l_current_category_name
759: FROM MTL_ITEM_CATALOG_GROUPS_KFV
760: WHERE ITEM_CATALOG_GROUP_ID = l_policy_cat_id;
761: l_catalog_category_names_table(l_policy_cat_id) := l_current_category_name;
762: END IF;
763:

Line 2491: FROM MTL_ITEM_CATALOG_GROUPS_KFV

2487:
2488: l_token_table(1).TOKEN_NAME := 'CAT_GROUP_NAME';
2489: SELECT CONCATENATED_SEGMENTS
2490: INTO l_token_table(1).TOKEN_VALUE
2491: FROM MTL_ITEM_CATALOG_GROUPS_KFV
2492: WHERE ITEM_CATALOG_GROUP_ID = p_catalog_group_id;
2493:
2494: ERROR_HANDLER.Add_Error_Message(
2495: p_message_name => 'EGO_TOO_MANY_CAT_GROUPS'

Line 4592: FROM MTL_ITEM_CATALOG_GROUPS_KFV

4588: ,p_proj_element_id => l_curr_phase_id);
4589: fnd_message.set_token('PHASE', l_dummy_char);
4590: SELECT concatenated_segments
4591: INTO l_dummy_char
4592: FROM MTL_ITEM_CATALOG_GROUPS_KFV
4593: WHERE ITEM_CATALOG_GROUP_ID = (
4594: SELECT item_catalog_group_id
4595: FROM (SELECT item_catalog_group_id
4596: FROM mtl_item_catalog_groups_b ic