DBA Data[Home] [Help]

APPS.INVICGDS dependencies on MTL_DESCR_ELEMENT_VALUES

Line 418: FROM mtl_descr_element_values MDEV

414: first_elem_val NUMBER;
415:
416: CURSOR get_desc_elem( iii NUMBER) IS
417: SELECT element_name, element_value, element_sequence
418: FROM mtl_descr_element_values MDEV
419: WHERE MDEV.inventory_item_id = iii
420: AND MDEV.default_element_flag = 'Y'
421: ORDER BY element_sequence;
422:

Line 425: FROM mtl_descr_element_values MDEV

421: ORDER BY element_sequence;
422:
423: CURSOR get_not_null_desc_elem( iii NUMBER) IS
424: SELECT element_name, element_value, element_sequence
425: FROM mtl_descr_element_values MDEV
426: WHERE MDEV.inventory_item_id = iii
427: AND MDEV.default_element_flag = 'Y'
428: AND MDEV.element_value is not NULL
429: ORDER BY element_sequence;