DBA Data[Home] [Help]

APPS.INVICGDS dependencies on MTL_ITEM_CATALOG_GROUPS

Line 320: FROM mtl_item_catalog_groups_kfv MICGK

316: error_text);
317:
318: IF (use_name_as_first_elem = 'Y') THEN
319: SELECT MICGK.concatenated_segments into icg_desc_or_name
320: FROM mtl_item_catalog_groups_kfv MICGK
321: WHERE MICGK.item_catalog_group_id = icg_id_val;
322:
323: ELSIF (use_name_as_first_elem = 'N') THEN
324: SELECT MICG.description into icg_desc_or_name

Line 325: FROM mtl_item_catalog_groups MICG

321: WHERE MICGK.item_catalog_group_id = icg_id_val;
322:
323: ELSIF (use_name_as_first_elem = 'N') THEN
324: SELECT MICG.description into icg_desc_or_name
325: FROM mtl_item_catalog_groups MICG
326: WHERE MICG.item_catalog_group_id = icg_id_val;
327: ELSE
328: error_text:= error_text||' INVICGDS(3-2): use_name_as_first_elem should be Y/N';
329: /*Error in parameter*/