APPS.INV_EBI_ITEM_HELPER dependencies on MTL_ITEM_CATALOG_GROUPS_VL

Line 1197: FROM mtl_item_catalog_groups_vl

1193: l_is_new_item_request_reqd VARCHAR2(3);
1194: BEGIN
1195: IF (p_item_catalog_group_id IS NOT NULL AND p_item_catalog_group_id <> fnd_api.g_miss_num) THEN
1196: SELECT new_item_request_reqd INTO l_is_new_item_request_reqd
1197: FROM mtl_item_catalog_groups_vl
1198: WHERE item_catalog_group_id = p_item_catalog_group_id;
1199: IF(l_is_new_item_request_reqd = 'Y') THEN
1200: RETURN FND_API.g_true;
1201: ELSE

Line 1413: FROM MTL_ITEM_CATALOG_GROUPS_VL

1409: l_item_desc_gen_method VARCHAR2(2);
1410: BEGIN
1411: SELECT item_desc_gen_method, parent_catalog_group_id
1412: INTO l_item_desc_gen_method, l_parent_catalog_group_id
1413: FROM MTL_ITEM_CATALOG_GROUPS_VL
1414: WHERE item_catalog_group_id = p_item_catalog_group_id;
1415: IF UPPER(l_item_desc_gen_method)='I' THEN
1416: WHILE UPPER(l_item_desc_gen_method) = 'I' LOOP
1417: SELECT item_desc_gen_method,

Line 1421: FROM mtl_item_catalog_groups_vl

1417: SELECT item_desc_gen_method,
1418: parent_catalog_group_id
1419: INTO l_item_desc_gen_method,
1420: t_parent_catalog_group_id
1421: FROM mtl_item_catalog_groups_vl
1422: WHERE item_catalog_group_id = l_parent_catalog_group_id;
1423: EXIT WHEN t_parent_catalog_group_id IS NULL;
1424: l_parent_catalog_group_id := t_parent_catalog_group_id;
1425: END LOOP;