DBA Data[Home] [Help]

APPS.GME_CREATE_BATCH_PVT dependencies on MTL_STAT_ATTRIB_VALUES_ALL_V

Line 400: FROM mtl_stat_attrib_values_all_v st

396: -- Bug 11815699 - Fetch process execution enabled setting for item ststus.
397: CURSOR item_status_cursor (v_inventory_item_status_code VARCHAR2)
398: IS
399: SELECT NVL(st.attribute_value, 'N')
400: FROM mtl_stat_attrib_values_all_v st
401: WHERE st.inventory_item_status_code = v_inventory_item_status_code
402: AND attribute_name = 'MTL_SYSTEM_ITEMS.PROCESS_EXECUTION_ENABLED_FLAG';
403:
404: l_status_exec_enabled VARCHAR2(1);