DBA Data[Home] [Help]

APPS.INVUPDAT dependencies on MTL_ITEM_STATUS

Line 17: from mtl_item_status s,

13:
14: CURSOR status_cursor(input_stat_value VARCHAR2) IS
15: select s.inventory_item_status_code IISC,
16: v.attribute_value AV
17: from mtl_item_status s,
18: mtl_status_attribute_values v
19: where s.inventory_item_status_code = NVL(input_stat_value , s.inventory_item_status_code)
20: and s.inventory_item_status_code = v.inventory_item_status_code
21: and v.attribute_name = current_attribute_name;