CREATE OR REPLACE VIEW ref_site AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 1; CREATE OR REPLACE VIEW ref_level AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 2; CREATE OR REPLACE VIEW ref_job AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 3; CREATE OR REPLACE VIEW ref_context AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 4; CREATE OR REPLACE VIEW ref_content AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 5; CREATE OR REPLACE VIEW ref_days_of_rotation AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 6; CREATE OR REPLACE VIEW ref_demonstration_reason AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 7; CREATE OR REPLACE VIEW ref_action_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 8; CREATE OR REPLACE VIEW ref_climate AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 9; CREATE OR REPLACE VIEW ref_duration AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 10; CREATE OR REPLACE VIEW ref_event_shift_schedule AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 11; CREATE OR REPLACE VIEW ref_frequency AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 12; CREATE OR REPLACE VIEW ref_hazard_identification AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 13; CREATE OR REPLACE VIEW ref_actual_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 14; CREATE OR REPLACE VIEW ref_hazard_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 15; CREATE OR REPLACE VIEW ref_actual_incident_type_category AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 16; CREATE OR REPLACE VIEW ref_actual_incident_type_detail AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 17; CREATE OR REPLACE VIEW ref_hours_summary AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 18; CREATE OR REPLACE VIEW ref_basic_cause_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 19; CREATE OR REPLACE VIEW ref_basic_cause_category AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 20; CREATE OR REPLACE VIEW ref_basic_cause AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 21; CREATE OR REPLACE VIEW ref_immediate_cause_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 25; CREATE OR REPLACE VIEW ref_immediate_cause AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 26; CREATE OR REPLACE VIEW ref_incident_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 27; CREATE OR REPLACE VIEW ref_inspection_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 28; CREATE OR REPLACE VIEW ref_position AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 29; CREATE OR REPLACE VIEW ref_potential_loss AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 30; CREATE OR REPLACE VIEW ref_potential_risk AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 31; CREATE OR REPLACE VIEW ref_preliminary_incident_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 32; CREATE OR REPLACE VIEW ref_preliminary_incident_type_category AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 33; CREATE OR REPLACE VIEW ref_preliminary_incident_type_detail AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 34; CREATE OR REPLACE VIEW ref_recognition_given AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 35; CREATE OR REPLACE VIEW ref_recognition_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 36; CREATE OR REPLACE VIEW ref_special_ppe AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 37; CREATE OR REPLACE VIEW ref_temperature AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 38; CREATE OR REPLACE VIEW ref_topic_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 39; CREATE OR REPLACE VIEW ref_training_audit_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 40; CREATE OR REPLACE VIEW ref_equipment AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 41; CREATE OR REPLACE VIEW ref_classification AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 42; CREATE OR REPLACE VIEW ref_work_rest_established AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 43; CREATE OR REPLACE VIEW ref_involvement AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 44; CREATE OR REPLACE VIEW ref_preparation AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 45; CREATE OR REPLACE VIEW ref_testing AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 46; CREATE OR REPLACE VIEW ref_knowledge AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 47; CREATE OR REPLACE VIEW ref_audit_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 48; CREATE OR REPLACE VIEW ref_record_status AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 49; CREATE OR REPLACE VIEW ref_shift AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 50; CREATE OR REPLACE VIEW ref_training_code AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 51; CREATE OR REPLACE VIEW ref_training_institution AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 52; CREATE OR REPLACE VIEW ref_training_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 53; CREATE OR REPLACE VIEW ref_general_action AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 54; CREATE OR REPLACE VIEW ref_document_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 55; CREATE OR REPLACE VIEW ref_crew AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 56; CREATE OR REPLACE VIEW ref_likelihood AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 57; CREATE OR REPLACE VIEW ref_severity AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 58; CREATE OR REPLACE VIEW ref_risk_category AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 59; CREATE OR REPLACE VIEW ref_event_category AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 60; CREATE OR REPLACE VIEW ref_major_unwanted_event AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 61; CREATE OR REPLACE VIEW ref_color_list AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 62; CREATE OR REPLACE VIEW ref_reason_departure AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 63; CREATE OR REPLACE VIEW ref_employee_performance AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 64; CREATE OR REPLACE VIEW ref_assets_collected AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 65; CREATE OR REPLACE VIEW ref_rescue_plan_retrieval_equipment AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 66; CREATE OR REPLACE VIEW ref_hazards_present_rp AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 67; CREATE OR REPLACE VIEW ref_communication_strategy AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 68; CREATE OR REPLACE VIEW ref_rescue_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 69; CREATE OR REPLACE VIEW ref_key_contacts_rp AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 70; CREATE OR REPLACE VIEW ref_hot_work_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 71; CREATE OR REPLACE VIEW ref_hot_work_hazards AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 72; CREATE OR REPLACE VIEW ref_determine_controls_equipment AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 73; CREATE OR REPLACE VIEW ref_personal_protective_equipment AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 74; CREATE OR REPLACE VIEW ref_rescue_special_ppe AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 75; CREATE OR REPLACE VIEW ref_high_risk_precautions AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 76; CREATE OR REPLACE VIEW ref_potential_hazards_wh AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 77; CREATE OR REPLACE VIEW ref_determine_controls_wh AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 78; CREATE OR REPLACE VIEW ref_special_ppe_wh AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 79; CREATE OR REPLACE VIEW ref_occupation AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 80; CREATE OR REPLACE VIEW ref_am_task_contract AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 81; CREATE OR REPLACE VIEW ref_am_task_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 82; CREATE OR REPLACE VIEW ref_am_supplies_location AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 83; CREATE OR REPLACE VIEW ref_am_supplies_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 84; CREATE OR REPLACE VIEW ref_work_card_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 85; CREATE OR REPLACE VIEW ref_work_accomplished AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 86; CREATE OR REPLACE VIEW ref_rule_breaking AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 87; CREATE OR REPLACE VIEW ref_sanctions AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 88; CREATE OR REPLACE VIEW ref_preop_measure_unit AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 89; CREATE OR REPLACE VIEW ref_training_status AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 90; CREATE OR REPLACE VIEW ref_service_type AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 91; CREATE OR REPLACE VIEW ref_equipment_status AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 92; CREATE OR REPLACE VIEW ref_report_schedule_period AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 93; CREATE OR REPLACE VIEW ref_report_schedule_frequency AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 94; CREATE OR REPLACE VIEW ref_report_schedule_end AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 95; CREATE OR REPLACE VIEW ref_drilling_time_and_delays_code AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 96; CREATE OR REPLACE VIEW ref_drilling_code AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 97; CREATE OR REPLACE VIEW ref_drilling_status_code AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 98; CREATE OR REPLACE VIEW ref_drilling_log_code AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 99; CREATE OR REPLACE VIEW ref_drilling_bit_size AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 100; CREATE OR REPLACE VIEW ref_drilling_material_used AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 101; CREATE OR REPLACE VIEW ref_energy_source AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 102; CREATE OR REPLACE VIEW ref_lockout_devices AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 103; CREATE OR REPLACE VIEW ref_source_and_location AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 104; CREATE OR REPLACE VIEW ref_accessories AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 105; CREATE OR REPLACE VIEW ref_type_intervention AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 106; CREATE OR REPLACE VIEW ref_loto_status AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 107; CREATE OR REPLACE VIEW ref_atmospheric_gases AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 108; CREATE OR REPLACE VIEW ref_days_of_the_week AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 109; CREATE OR REPLACE VIEW ref_module_list AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 110; CREATE OR REPLACE VIEW ref_risk_level AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 111; CREATE OR REPLACE VIEW ref_work_card_risk AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 112; CREATE OR REPLACE VIEW ref_work_card_control AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 113; CREATE OR REPLACE VIEW ref_preop_equipment_status AS SELECT rld.rld_id AS rld_id, rld.rld_rlh_id as rld_rlh_id, rld.rld_code AS rld_code, rld.rld_name AS rld_name, lt.ltr_text AS ltr_text, rld.rld_description, rld.rld_tag_type AS rld_tag_type, rld.rld_is_active AS rld_is_active, lt.ltr_lng_id AS lng_id, NOT rld.rld_enable AS rld_deleted, rld.rld_enable AS rld_enable FROM (ref_list_detail rld left JOIN language_translation lt ON (lt.ltr_tag = rld.rld_name) AND lt.ltr_tag_type = rld.rld_tag_type) WHERE rld.rld_rlh_id = 114;