APPS.INV_EBI_ITEM_HELPER dependencies on MTL_ITEM_CATALOG_GROUPS_VL

Line 922: FROM mtl_item_catalog_groups_vl

918: l_is_new_item_request_reqd VARCHAR2(3);
919: BEGIN
920: IF (p_item_catalog_group_id IS NOT NULL AND p_item_catalog_group_id <> fnd_api.g_miss_num) THEN
921: SELECT new_item_request_reqd INTO l_is_new_item_request_reqd
922: FROM mtl_item_catalog_groups_vl
923: WHERE item_catalog_group_id = p_item_catalog_group_id;
924: IF(l_is_new_item_request_reqd = 'Y') THEN
925: RETURN FND_API.g_true;
926: ELSE

Line 1138: FROM MTL_ITEM_CATALOG_GROUPS_VL

1134: l_item_desc_gen_method VARCHAR2(2);
1135: BEGIN
1136: SELECT item_desc_gen_method, parent_catalog_group_id
1137: INTO l_item_desc_gen_method, l_parent_catalog_group_id
1138: FROM MTL_ITEM_CATALOG_GROUPS_VL
1139: WHERE item_catalog_group_id = p_item_catalog_group_id;
1140: IF UPPER(l_item_desc_gen_method)='I' THEN
1141: WHILE UPPER(l_item_desc_gen_method) = 'I' LOOP
1142: SELECT item_desc_gen_method,

Line 1146: FROM mtl_item_catalog_groups_vl

1142: SELECT item_desc_gen_method,
1143: parent_catalog_group_id
1144: INTO l_item_desc_gen_method,
1145: t_parent_catalog_group_id
1146: FROM mtl_item_catalog_groups_vl
1147: WHERE item_catalog_group_id = l_parent_catalog_group_id;
1148: EXIT WHEN t_parent_catalog_group_id IS NULL;
1149: l_parent_catalog_group_id := t_parent_catalog_group_id;
1150: END LOOP;