The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select 'X'
from ENG_CHANGE_MGMT_TYPES_VL ecmt,
ENG_ENGINEERING_CHANGES echg,
ENG_CHANGE_ORDER_TYPES eco
where
ecmt.CHANGE_MGMT_TYPE_CODE = eco.change_mgmt_type_code
and
eco.change_order_type_id = echg.change_order_type_id
and
ecmt.CHANGE_MGMT_TYPE_CODE = p_mgmt_code;
Select 'X'
from ENG_CHANGE_MGMT_TYPES_VL ecmt,
ENG_ENGINEERING_CHANGES echg,
ENG_CHANGE_ORDER_TYPES eco
where
ecmt.CHANGE_MGMT_TYPE_CODE = eco.change_mgmt_type_code
and
eco.change_order_type_id = echg.change_order_type_id
and
echg.STATUS_TYPE <> 6 -- Implemented
and
echg.STATUS_TYPE <> 5 -- Cancelled
and
ecmt.CHANGE_MGMT_TYPE_CODE = p_mgmt_code;