APPS.INV_EBI_ITEM_HELPER dependencies on MTL_ITEM_CATALOG_GROUPS_KFV

Line 130: SELECT item_catalog_group_id INTO l_id FROM mtl_item_catalog_groups_kfv

126: SELECT organization_id INTO l_id FROM mtl_parameters
127: WHERE organization_code = l_pk1;
128: WHEN G_ITEM_CATALOG_GROUP THEN
129: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
130: SELECT item_catalog_group_id INTO l_id FROM mtl_item_catalog_groups_kfv
131: WHERE concatenated_segments = l_pk1;
132: WHEN G_LIFECYCLE THEN
133: l_pk1 := ID_COL_VALUE('name',p_pk_col_name_val_pairs);
134: SELECT proj_element_id INTO l_id FROM pa_ego_lifecycles_v

Line 212: FROM mtl_item_catalog_groups_kfv

208: WHERE organization_id = l_pk1;
209: WHEN G_ITEM_CATALOG_GROUP THEN
210: l_pk1 := ID_COL_VALUE('item_catalog_group_id',p_pk_col_name_val_pairs);
211: SELECT concatenated_segments INTO l_code
212: FROM mtl_item_catalog_groups_kfv
213: WHERE item_catalog_group_id = l_pk1;
214: WHEN G_LIFECYCLE THEN
215: l_pk1 := ID_COL_VALUE('proj_element_id',p_pk_col_name_val_pairs);
216: SELECT name INTO l_code

Line 2692: FROM mtl_item_catalog_groups_kfv

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
2694: START WITH item_catalog_group_id = p_item_catalog_group_id
2695: );
2696: -- End of Bug 10378371

Line 4615: FROM mtl_item_catalog_groups_kfv

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
4617: START WITH item_catalog_group_id = p_item_catalog_group_id
4618: );
4619:

Line 4832: FROM mtl_item_catalog_groups_kfv

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
4832: FROM mtl_item_catalog_groups_kfv
4833: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
4834: START WITH item_catalog_group_id = p_item_classification_id
4835: ) AND
4836: ems.attr_group_id = ass.attr_group_id;