DBA Data[Home] [Help]

APPS.INVUPCTF dependencies on MTL_DESCR_ELEMENT_VALUES

Line 25: FROM MTL_DESCR_ELEMENT_VALUES MDEV

21:
22: el_value := NULL;
23:
24: SELECT ELEMENT_VALUE INTO el_value
25: FROM MTL_DESCR_ELEMENT_VALUES MDEV
26: WHERE MDEV.INVENTORY_ITEM_ID = get_iii_cursor_row.III
27: AND MDEV.ELEMENT_NAME = current_element_name;
28:
29: IF el_value IS NULL THEN

Line 68: , MTL_DESCR_ELEMENT_VALUES V

64: FROM DUAL
65: WHERE EXISTS
66: ( SELECT null
67: FROM MTL_DESCRIPTIVE_ELEMENTS E
68: , MTL_DESCR_ELEMENT_VALUES V
69: WHERE E.REQUIRED_ELEMENT_FLAG = 'Y'
70: AND E.ITEM_CATALOG_GROUP_ID = current_catalog_id
71: AND V.INVENTORY_ITEM_ID = current_inv_item_id
72: AND V.ELEMENT_NAME = E.ELEMENT_NAME