Hi,

You can't upgrade Intools version 5.3 to SPI7.

You should first Upgrade 5.3 to the latest SP version 6 and then Upgrade to version 7.

Regards

Ilan Hills

Hi,

Please run the following SQLs:

CREATE OR REPLACE VIEW SCHEMA_VIEW_INSTRUMENT_4 AS SELECT C.CMPNT_ID CMPNT_ID, C.CMPNT_NAME CMPNT_NAME, C.CMPNT_SERV CMPNT_SERV, C.CALIB_RANGE_MAX CALIB_RANGE_MAX, C.CALIB_RANGE_MIN CALIB_RANGE_MIN, C.CALIB_RANGE_UFLG_MAX CALIB_RANGE_UFLG_MAX, C.CALIB_RANGE_UFLG_MIN CALIB_RANGE_UFLG_MIN, C.CALIB_RANGE_UOM_MAX CALIB_RANGE_UOM_MAX, C.CALIB_RANGE_UOM_MIN CALIB_RANGE_UOM_MIN, C.DCS_RANGE_MAX DCS_RANGE_MAX, C.DCS_RANGE_MIN DCS_RANGE_MIN, C.DCS_RANGE_UOM DCS_RANGE_UOM, SUBSTR(C.CMPNT_NAME, 1,6) PREFIX, C.REMARK1 REMARK1, C.REMARK2 REMARK2, C.REMARK3 REMARK3, C.SPEC_CMPNT_PO_NO SPEC_CMPNT_PO_NO, C.SPEC_CMPNT_PRICE SPEC_CMPNT_PRICE, C.SPEC_CMPNT_PO_ITEM_NO SPEC_CMPNT_PO_ITEM_NO, SUBSTR(C.CMPNT_NAME, 5,11) CMPNT_SUFF, C.INST_RANGE_MIN INST_RANGE_MIN, C.INST_RANGE_MAX INST_RANGE_MAX, C.INST_RANGE_UOM_MAX INST_RANGE_UOM_MAX, C.INST_RANGE_UOM_MIN INST_RANGE_UOM_MIN, C.INST_RANGE_UFLG_MIN INST_RANGE_UFLG_MIN, C.INST_RANGE_UFLG_MAX INST_RANGE_UFLG_MAX, PA.AREA_NAME AREA_NAME, CFT.CMPNT_FUNC_TYPE_DESC CMPNT_FUNC_TYPE_DESC, CMFR.CMPNT_MFR_NAME CMPNT_MFR_NAME, CMFR.CMPNT_MFR_DESC CMPNT_MFR_DESC, CMFR.MFR_COMPANY_IDENTIFICATION MFR_COMPANY_IDENTIFICATION, CMOD.CMPNT_MOD_NAME CMPNT_MOD_NAME, '' CS_TAG_NAME, D1.DWG_NAME PID_NUM, L.LINE_NUM LINE_NUM, L.LINE_SIZE || ' ' || Upper(L.LINE_UOM) LINE_SIZE, PDG.PD_FLUID_NAME PD_FLUID_NAME, SF.SPEC_FORM_CNUM SPEC_FORM_CNUM, D2.DWG_NAME SPEC_NUM, CUDF.UDF_C01 UDF_C01, CUDF.UDF_C02 UDF_C02, CUDF.UDF_C03 UDF_C03, CUDF.UDF_C04 UDF_C04, CUDF.UDF_C05 UDF_C05, CUDF.UDF_C06 UDF_C06, CUDF.UDF_C07 UDF_C07, CUDF.UDF_C08 UDF_C08, CUDF.UDF_C36 UDF_C36, CUDF.UDF_C37 UDF_C37, CUDF.UDF_C61 UDF_C61, CUDF.UDF_C62 UDF_C62, CUDF.UDF_C63 UDF_C63, CUDF.UDF_C13 UDF_C13, CUDF.UDF_C14 UDF_C14, CUDF.UDF_C15 UDF_C15, CUDF.UDF_C16 UDF_C16, CUDF.UDF_C17 UDF_C17, CUDF.UDF_C18 UDF_C18, CUDF.UDF_C64 UDF_C64, CUDF.UDF_D01 UDF_D01, UDTS1.NAME UDT_SUPPORT1_NAME, UDTS2.NAME UDT_SUPPORT2_NAME, UDTS3.NAME UDT_SUPPORT3_NAME, UDTS4.NAME UDT_SUPPORT4_NAME, UDTS5.NAME UDT_SUPPORT5_NAME, UDTS6.NAME UDT_SUPPORT6_NAME, UDTS7.NAME UDT_SUPPORT7_NAME, UDTS8.NAME UDT_SUPPORT8_NAME, UDTS9.NAME UDT_SUPPORT9_NAME, UDTS10.NAME UDT_SUPPORT10_NAME, UDTS11.NAME UDT_SUPPORT11_NAME, UDTS12.NAME UDT_SUPPORT12_NAME, UDTS13.NAME UDT_SUPPORT13_NAME, UDTS14.NAME UDT_SUPPORT14_NAME, P.PLANT_NAME PLANT_NAME, PAU.UNIT_NAME UNIT_NAME, PAU.UNIT_NUM UNIT_NUM, ' ' STRIP_MFR_DESC, ' ' STRIP_MOD_DESC, ' ' CONTROLLER_NAME, ' ' CABINET_RACK_NAME, ' ' STRIP_NAME, ' ' CHANNEL_NAME FROM COMPONENT C, PLANT P, PLANT_AREA PA, PLANT_AREA_UNIT PAU, COMPONENT_MFR CMFR, COMPONENT_MOD CMOD, DRAWING D1, COMPONENT_FUNCTION_TYPE CFT, DRAWING D2, PD_GENERAL PDG, LINE L, SPEC_SHEET_DATA SSD, SPEC_FORM SF, UDF_COMPONENT CUDF, UDT_SUPPORT1 UDTS1, UDT_SUPPORT2 UDTS2, UDT_SUPPORT3 UDTS3, UDT_SUPPORT4 UDTS4, UDT_SUPPORT5 UDTS5, UDT_SUPPORT6 UDTS6, UDT_SUPPORT7 UDTS7, UDT_SUPPORT8 UDTS8, UDT_SUPPORT9 UDTS9, UDT_SUPPORT10 UDTS10, UDT_SUPPORT11 UDTS11, UDT_SUPPORT12 UDTS12, UDT_SUPPORT13 UDTS13, UDT_SUPPORT14 UDTS14 WHERE C.PLANT_ID = P.PLANT_ID AND C.AREA_ID = PA.AREA_ID AND C.UNIT_ID = PAU.UNIT_ID AND C.CMPNT_FUNC_TYPE_ID = CFT.CMPNT_FUNC_TYPE_ID AND C.CMPNT_MFR_ID = CMFR.CMPNT_MFR_ID AND C.CMPNT_MOD_ID = CMOD.CMPNT_MOD_ID AND C.LINE_ID = L.LINE_ID AND L.LINE_ID = PDG.LINE_ID AND PDG.CMPNT_ID = 0 AND C.CMPNT_ID = SSD.CMPNT_ID AND SSD.DWG_ID = D2.DWG_ID AND C.DWG_ID = D1.DWG_ID AND C.CMPNT_ID = CUDF.CMPNT_ID AND C.UDT_SUPPORT_ID1 = UDTS1.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID2 = UDTS2.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID3 = UDTS3.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID4 = UDTS4.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID5 = UDTS5.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID6 = UDTS6.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID7 = UDTS7.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID8 = UDTS8.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID9 = UDTS9.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID10 = UDTS10.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID11 = UDTS11.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID12 = UDTS12.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID13 = UDTS13.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID14 = UDTS14.UDT_SUPPORT_ID AND SSD.SPEC_FORM_ID = SF.SPEC_FORM_ID AND NOT EXISTS (SELECT 'X' FROM CONTROL_SYSTEM_TAG WHERE CMPNT_ID = C.CMPNT_ID) UNION ALL SELECT C.CMPNT_ID CMPNT_ID, C.CMPNT_NAME CMPNT_NAME, C.CMPNT_SERV CMPNT_SERV, C.CALIB_RANGE_MAX CALIB_RANGE_MAX, C.CALIB_RANGE_MIN CALIB_RANGE_MIN, C.CALIB_RANGE_UFLG_MAX CALIB_RANGE_UFLG_MAX, C.CALIB_RANGE_UFLG_MIN CALIB_RANGE_UFLG_MIN, C.CALIB_RANGE_UOM_MAX CALIB_RANGE_UOM_MAX, C.CALIB_RANGE_UOM_MIN CALIB_RANGE_UOM_MIN, C.DCS_RANGE_MAX DCS_RANGE_MAX, C.DCS_RANGE_MIN DCS_RANGE_MIN, C.DCS_RANGE_UOM DCS_RANGE_UOM, SUBSTR(C.CMPNT_NAME, 1,6) PREFIX, C.REMARK1 REMARK1, C.REMARK2 REMARK2, C.REMARK3 REMARK3, C.SPEC_CMPNT_PO_NO SPEC_CMPNT_PO_NO, C.SPEC_CMPNT_PRICE SPEC_CMPNT_PRICE, C.SPEC_CMPNT_PO_ITEM_NO SPEC_CMPNT_PO_ITEM_NO, SUBSTR(C.CMPNT_NAME, 5,11) CMPNT_SUFF, C.INST_RANGE_MIN INST_RANGE_MIN, C.INST_RANGE_MAX INST_RANGE_MAX, C.INST_RANGE_UOM_MAX INST_RANGE_UOM_MAX, C.INST_RANGE_UOM_MIN INST_RANGE_UOM_MIN, C.INST_RANGE_UFLG_MIN INST_RANGE_UFLG_MIN, C.INST_RANGE_UFLG_MAX INST_RANGE_UFLG_MAX, PA.AREA_NAME AREA_NAME, CFT.CMPNT_FUNC_TYPE_DESC CMPNT_FUNC_TYPE_DESC, CMFR.CMPNT_MFR_NAME CMPNT_MFR_NAME, CMFR.CMPNT_MFR_DESC CMPNT_MFR_DESC, CMFR.MFR_COMPANY_IDENTIFICATION MFR_COMPANY_IDENTIFICATION, CMOD.CMPNT_MOD_NAME CMPNT_MOD_NAME, CST.CS_TAG_NAME CS_TAG_NAME, D1.DWG_NAME PID_NUM, L.LINE_NUM LINE_NUM, L.LINE_SIZE || ' ' || Upper(L.LINE_UOM) LINE_SIZE, PDG.PD_FLUID_NAME PD_FLUID_NAME, SF.SPEC_FORM_CNUM SPEC_FORM_CNUM, D2.DWG_NAME SPEC_NUM, CUDF.UDF_C01 UDF_C01, CUDF.UDF_C02 UDF_C02, CUDF.UDF_C03 UDF_C03, CUDF.UDF_C04 UDF_C04, CUDF.UDF_C05 UDF_C05, CUDF.UDF_C06 UDF_C06, CUDF.UDF_C07 UDF_C07, CUDF.UDF_C08 UDF_C08, CUDF.UDF_C36 UDF_C36, CUDF.UDF_C37 UDF_C37, CUDF.UDF_C61 UDF_C61, CUDF.UDF_C62 UDF_C62, CUDF.UDF_C63 UDF_C63, CUDF.UDF_C13 UDF_C13, CUDF.UDF_C14 UDF_C14, CUDF.UDF_C15 UDF_C15, CUDF.UDF_C16 UDF_C16, CUDF.UDF_C17 UDF_C17, CUDF.UDF_C18 UDF_C18, CUDF.UDF_C64 UDF_C64, CUDF.UDF_D01 UDF_D01, UDTS1.NAME UDT_SUPPORT1_NAME, UDTS2.NAME UDT_SUPPORT2_NAME, UDTS3.NAME UDT_SUPPORT3_NAME, UDTS4.NAME UDT_SUPPORT4_NAME, UDTS5.NAME UDT_SUPPORT5_NAME, UDTS6.NAME UDT_SUPPORT6_NAME, UDTS7.NAME UDT_SUPPORT7_NAME, UDTS8.NAME UDT_SUPPORT8_NAME, UDTS9.NAME UDT_SUPPORT9_NAME, UDTS10.NAME UDT_SUPPORT10_NAME, UDTS11.NAME UDT_SUPPORT11_NAME, UDTS12.NAME UDT_SUPPORT12_NAME, UDTS13.NAME UDT_SUPPORT13_NAME, UDTS14.NAME UDT_SUPPORT14_NAME, P.PLANT_NAME PLANT_NAME, PAU.UNIT_NAME UNIT_NAME, PAU.UNIT_NUM UNIT_NUM, ST_MFR.STRIP_MFR_DESC, ST_MOD.STRIP_MOD_DESC, CTRL.CONTROLLER_NAME, RACK.CABINET_RACK_NAME, PS.STRIP_NAME, CH.CHANNEL_NAME FROM COMPONENT C, PLANT P, PLANT_AREA PA, PLANT_AREA_UNIT PAU, COMPONENT_MFR CMFR, COMPONENT_MOD CMOD, DRAWING D1, COMPONENT_FUNCTION_TYPE CFT, DRAWING D2, CONTROL_SYSTEM_TAG CST, PD_GENERAL PDG, LINE L, SPEC_SHEET_DATA SSD, SPEC_FORM SF, UDF_COMPONENT CUDF, UDT_SUPPORT1 UDTS1, UDT_SUPPORT2 UDTS2, UDT_SUPPORT3 UDTS3, UDT_SUPPORT4 UDTS4, UDT_SUPPORT5 UDTS5, UDT_SUPPORT6 UDTS6, UDT_SUPPORT7 UDTS7, UDT_SUPPORT8 UDTS8, UDT_SUPPORT9 UDTS9, UDT_SUPPORT10 UDTS10, UDT_SUPPORT11 UDTS11, UDT_SUPPORT12 UDTS12, UDT_SUPPORT13 UDTS13, UDT_SUPPORT14 UDTS14, PANEL_STRIP PS, STRIP_MFR ST_MFR, STRIP_MFR_MOD ST_MOD, CONTROLLER CTRL, CABINET_RACK RACK, CHANNEL CH WHERE C.PLANT_ID = P.PLANT_ID AND C.AREA_ID = PA.AREA_ID AND C.UNIT_ID = PAU.UNIT_ID AND C.CMPNT_FUNC_TYPE_ID = CFT.CMPNT_FUNC_TYPE_ID AND C.CMPNT_MFR_ID = CMFR.CMPNT_MFR_ID AND C.CMPNT_MOD_ID = CMOD.CMPNT_MOD_ID AND C.LINE_ID = L.LINE_ID AND L.LINE_ID = PDG.LINE_ID AND PDG.CMPNT_ID = 0 AND C.CMPNT_ID = CST.CMPNT_ID AND CST.PANEL_ID = PS.PANEL_ID AND CST.STRIP_ID = PS.STRIP_ID AND PS.STRIP_MFR_ID = ST_MFR.STRIP_MFR_ID AND PS.STRIP_MOD_ID = ST_MOD.STRIP_MOD_ID AND C.CMPNT_ID = SSD.CMPNT_ID AND SSD.DWG_ID = D2.DWG_ID AND C.DWG_ID = D1.DWG_ID AND C.CMPNT_ID = CUDF.CMPNT_ID AND C.UDT_SUPPORT_ID1 = UDTS1.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID2 = UDTS2.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID3 = UDTS3.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID4 = UDTS4.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID5 = UDTS5.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID6 = UDTS6.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID7 = UDTS7.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID8 = UDTS8.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID9 = UDTS9.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID10 = UDTS10.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID11 = UDTS11.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID12 = UDTS12.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID13 = UDTS13.UDT_SUPPORT_ID AND C.UDT_SUPPORT_ID14 = UDTS14.UDT_SUPPORT_ID AND SSD.SPEC_FORM_ID = SF.SPEC_FORM_ID AND PS.CONTROLLER_ID = CTRL.CONTROLLER_ID AND PS.RACK_ID=RACK.RACK_ID AND CH.PANEL_ID=CST.PANEL_ID AND CH.STRIP_ID=CST.STRIP_ID AND CST.CHANNEL_ID=CH.CHANNEL_ID;
CREATE OR REPLACE VIEW SCHEMA_VIEW_SIGNAL_7 ( CMPNT_ID, PROC_FUNC_NAME, CMPNT_SUFF, PREFIX, CMPNT_NUM, CMPNT_FUNC_TYPE_ID, CMPNT_HANDLE_ID, CMPNT_NAME, CMPNT_NOTE, CMPNT_SEQ, CMPNT_SERV, CMPNT_SYS_IO_TYPE_ID, EQUIP_ID, LINE_ID, LOOP_ID, OLD_CMPNT_NAME, PROC_FUNC_ID, REMARK1, REMARK2, REMARK3, REMARK4, REMARK5, CMPNT_FUNC_TYPE_DESC, CMPNT_FUNC_TYPE_NAME, CMPNT_HANDLE_DESC, CMPNT_HANDLE_NAME, CMPNT_LOC_DESC, CMPNT_LOC_NAME, CMPNT_MFR_DESC, CMPNT_MFR_NAME, CMPNT_MOD_DESC, CMPNT_MOD_NAME, CMPNT_SYS_IO_TYPE_DESC, CMPNT_SYS_IO_TYPE_NAME ) AS SELECT C.CMPNT_ID CMPNT_ID, CPF.PROC_FUNC_NAME PROC_FUNC_NAME, C.CMPNT_SUFF CMPNT_SUFF, C.PREFIX PREFIX, C.CMPNT_NUM CMPNT_NUM, C.CMPNT_FUNC_TYPE_ID CMPNT_FUNC_TYPE_ID, C.CMPNT_HANDLE_ID CMPNT_HANDLE_ID, C.CMPNT_NAME CMPNT_NAME, C.CMPNT_NOTE CMPNT_NOTE, C.CMPNT_SEQ CMPNT_SEQ, C.CMPNT_SERV CMPNT_SERV, C.CMPNT_SYS_IO_TYPE_ID CMPNT_SYS_IO_TYPE_ID, C.EQUIP_ID EQUIP_ID, C.LINE_ID LINE_ID, C.LOOP_ID LOOP_ID, C.OLD_CMPNT_NAME OLD_CMPNT_NAME, C.PROC_FUNC_ID PROC_FUNC_ID, C.REMARK1 REMARK1, C.REMARK2 REMARK2, C.REMARK3 REMARK3, C.REMARK4 REMARK4, C.REMARK5 REMARK5, CFT.CMPNT_FUNC_TYPE_DESC CMPNT_FUNC_TYPE_DESC, CFT.CMPNT_FUNC_TYPE_NAME CMPNT_FUNC_TYPE_NAME, CH.CMPNT_HANDLE_DESC CMPNT_HANDLE_DESC, CH.CMPNT_HANDLE_NAME CMPNT_HANDLE_NAME, CL.CMPNT_LOC_DESC CMPNT_LOC_DESC, CL.CMPNT_LOC_NAME CMPNT_LOC_NAME, CMFR.CMPNT_MFR_DESC CMPNT_MFR_DESC, CMFR.CMPNT_MFR_NAME CMPNT_MFR_NAME, CMOD.CMPNT_MOD_DESC CMPNT_MOD_DESC, CMOD.CMPNT_MOD_NAME CMPNT_MOD_NAME, CSYS.CMPNT_SYS_IO_TYPE_DESC CMPNT_SYS_IO_TYPE_DESC, CSYS.CMPNT_SYS_IO_TYPE_NAME CMPNT_SYS_IO_TYPE_NAME FROM COMPONENT C, COMPONENT_FUNCTION_TYPE CFT, COMPONENT_HANDLE CH, COMPONENT_LOCATION CL, COMPONENT_MFR CMFR, COMPONENT_MOD CMOD, COMPONENT_SYS_IO_TYPE CSYS, PROCESS_FUNCTION CPF WHERE C.CMPNT_FUNC_TYPE_ID = CFT.CMPNT_FUNC_TYPE_ID AND CFT.PROC_FUNC_ID = CPF.PROC_FUNC_ID AND C.CMPNT_HANDLE_ID = CH.CMPNT_HANDLE_ID AND C.CMPNT_HANDLE_ID = CH.CMPNT_HANDLE_ID AND C.CMPNT_LOC_ID = CL.CMPNT_LOC_ID AND C.CMPNT_MFR_ID = CMFR.CMPNT_MFR_ID AND C.CMPNT_MOD_ID = CMOD.CMPNT_MOD_ID AND C.CMPNT_SYS_IO_TYPE_ID = CSYS.CMPNT_SYS_IO_TYPE_ID AND CMPNT_ID > 0 AND MASTER_CMPNT_ID = 0 AND CFT.PROC_FUNC_CAT_ID = 20;
create or replace view v_instrument_JB as  select c.cmpnt_id tag, max(jb.panel_name) JB from component c, panel jb, wire_group wg, wire_terminal wt where c.cmpnt_id > 0 and c.cmpnt_id = wg.cmpnt_id (+) and wg.wire_group_id = wt.wire_group_id (+) and wt.panel_id = jb.panel_id (+) and jb.panel_category_id = 1 group by c.cmpnt_id;
CREATE OR REPLACE VIEW SCHEMA_VIEW_CHANNEL_1 AS SELECT CHANNEL.CHANNEL_NAME  CHANNEL_NAME,CHANNEL.ADDRESS ADDRESS,CHANNEL.CHANNEL_ENABLE CHANNEL_ENABLE,CHANNEL.CHANNEL_ID CHANNEL_ID,CHANNEL_TYPE.CHANNEL_TYPE_DESC CHANNEL_TYPE_DESC,CHANNEL.PANEL_ID PANEL_ID,CHANNEL.STRIP_ID STRIP_ID FROM CHANNEL, CHANNEL_TYPE WHERE CHANNEL.PANEL_ID > 0 AND   CHANNEL.STRIP_ID > 0 AND   CHANNEL.CHANNEL_ID > 0 AND   CHANNEL.CHANNEL_TYPE_ID = CHANNEL_TYPE.CHANNEL_TYPE_ID UNION ALL SELECT CHANNEL.CHANNEL_NAME  CHANNEL_NAME,CHANNEL.ADDRESS ADDRESS,CHANNEL.CHANNEL_ENABLE CHANNEL_ENABLE, CHANNEL.CHANNEL_ID CHANNEL_ID, '' CHANNEL_TYPE_DESC, CHANNEL.PANEL_ID PANEL_ID,CHANNEL.STRIP_ID STRIP_ID  FROM CHANNEL  WHERE CHANNEL.PANEL_ID > 0  AND   CHANNEL.STRIP_ID > 0  AND   CHANNEL.CHANNEL_ID > 0  AND   CHANNEL.CHANNEL_TYPE_ID IS NULL;
CREATE OR REPLACE VIEW SCHEMA_VIEW_INSTRUMENT_3 (CMPNT_ID,PROC_FUNC_NAME,CMPNT_SUFF,PREFIX,CMPNT_NUM,CMPNT_FUNC_TYPE_ID,CMPNT_HANDLE_ID,CMPNT_NAME,CMPNT_NOTE,CMPNT_SEQ,CMPNT_SERV,CMPNT_SYS_IO_TYPE_ID,EQUIP_ID,LINE_ID,LOOP_ID,OLD_CMPNT_NAME,PROC_FUNC_ID,REMARK1,REMARK2,REMARK3,REMARK4,REMARK5,PIPE_CLASS_NAME,CMPNT_FUNC_TYPE_DESC,CMPNT_FUNC_TYPE_NAME,CMPNT_HANDLE_DESC,CMPNT_HANDLE_NAME,CMPNT_LOC_DESC,CMPNT_LOC_NAME,CMPNT_MFR_DESC,CMPNT_MFR_NAME,CMPNT_MOD_DESC,CMPNT_MOD_NAME,CMPNT_SYS_IO_TYPE_DESC,CMPNT_SYS_IO_TYPE_NAME,CMPNT_CRITICAL_ID,FREQUENCY_ID,NUMBER_OF_PHASES_ID,OPERATING_MODE_ID,POWER_FACTOR_FULL_LOAD,RATED_VOLTAGE_ID,FULL_LOAD_CURRENT,STARTING_CURRENT,RATED_ACTIVE_LOAD,RATED_APPARENT_LOAD,RATED_REACTIVE_LOAD,OWER_SUPPLY_TYPE_FLAG,POWER_DISTRIBUTION_BOARD,CELL,ZZCOINCIDENCEFACTOR,ZCOINCIDENCEFACTOR,YCOINCIDENCEFACTOR,XCOINCIDENCEFACTOR,PHASE1,PHASE2,PHASE3,CMPNT_IS_CIRCUITE_TYPE_ID,CMPNT_CERTIF_ID,REQUIRES_POWER_SUPPLY,POWER_SUPPLY_TYPE_FLAG,CIRCUIT ) AS SELECT C.CMPNT_ID CMPNT_ID,CPF.PROC_FUNC_NAME PROC_FUNC_NAME,C.CMPNT_SUFF CMPNT_SUFF,C.PREFIX PREFIX,C.CMPNT_NUM CMPNT_NUM,C.CMPNT_FUNC_TYPE_ID CMPNT_FUNC_TYPE_ID,C.CMPNT_HANDLE_ID CMPNT_HANDLE_ID,C.CMPNT_NAME CMPNT_NAME,C.CMPNT_NOTE CMPNT_NOTE,C.CMPNT_SEQ CMPNT_SEQ,C.CMPNT_SERV CMPNT_SERV,C.CMPNT_SYS_IO_TYPE_ID CMPNT_SYS_IO_TYPE_ID,C.EQUIP_ID EQUIP_ID ,C.LINE_ID LINE_ID,C.LOOP_ID LOOP_ID,C.OLD_CMPNT_NAME OLD_CMPNT_NAME ,C.PROC_FUNC_ID PROC_FUNC_ID ,C.REMARK1 REMARK1 ,C.REMARK2 REMARK2 ,C.REMARK3 REMARK3,C.REMARK4 REMARK4,C.REMARK5 REMARK5,PC.PIPE_CLASS_NAME PIPE_CLASS_NAME ,CFT.CMPNT_FUNC_TYPE_DESC CMPNT_FUNC_TYPE_DESC,CFT.CMPNT_FUNC_TYPE_NAME CMPNT_FUNC_TYPE_NAME,CH.CMPNT_HANDLE_DESC CMPNT_HANDLE_DESC,CH.CMPNT_HANDLE_NAME CMPNT_HANDLE_NAME,CL.CMPNT_LOC_DESC CMPNT_LOC_DESC,CL.CMPNT_LOC_NAME CMPNT_LOC_NAME,CMFR.CMPNT_MFR_DESC CMPNT_MFR_DESC,CMFR.CMPNT_MFR_NAME CMPNT_MFR_NAME,CMOD.CMPNT_MOD_DESC CMPNT_MOD_DESC,CMOD.CMPNT_MOD_NAME CMPNT_MOD_NAME,CSYS.CMPNT_SYS_IO_TYPE_DESC CMPNT_SYS_IO_TYPE_DESC,CSYS.CMPNT_SYS_IO_TYPE_NAME CMPNT_SYS_IO_TYPE_NAME,C.CMPNT_CRITICAL_ID CMPNT_CRITICAL_ID,C.FREQUENCY_ID FREQUENCY_ID,C.NUMBER_OF_PHASES_ID NUMBER_OF_PHASES_ID,C.OPERATING_MODE_ID OPERATING_MODE_ID,C.POWER_FACTOR_FULL_LOAD POWER_FACTOR_FULL_LOAD,C.RATED_VOLTAGE_ID RATED_VOLTAGE_ID,C.FULL_LOAD_CURRENT FULL_LOAD_CURRENT,C.STARTING_CURRENT STARTING_CURRENT,C.RATED_ACTIVE_LOAD RATED_ACTIVE_LOAD,C.RATED_APPARENT_LOAD RATED_APPARENT_LOAD,C.RATED_REACTIVE_LOAD RATED_REACTIVE_LOAD,C.POWER_SUPPLY_TYPE_FLAG OWER_SUPPLY_TYPE_FLAG,C.POWER_DISTRIBUTION_BOARD POWER_DISTRIBUTION_BOARD,C.CELL CELL,C.ZZCOINCIDENCEFACTOR ZZCOINCIDENCEFACTOR,C.ZCOINCIDENCEFACTOR ZCOINCIDENCEFACTOR,C.YCOINCIDENCEFACTOR YCOINCIDENCEFACTOR,C.XCOINCIDENCEFACTOR XCOINCIDENCEFACTOR,C.PHASE1 PHASE1,C.PHASE2 PHASE2,C.PHASE3 PHASE3,C.CMPNT_IS_CIRCUITE_TYPE_ID CMPNT_IS_CIRCUITE_TYPE_ID,C.CMPNT_CERTIF_ID CMPNT_CERTIF_ID,C.REQUIRES_POWER_SUPPLY REQUIRES_POWER_SUPPLY,C.POWER_SUPPLY_TYPE_FLAG POWER_SUPPLY_TYPE_FLAG,C.CIRCUIT CIRCUIT FROM COMPONENT C,COMPONENT_FUNCTION_TYPE CFT,COMPONENT_HANDLE CH,COMPONENT_LOCATION CL,COMPONENT_MFR CMFR,COMPONENT_MOD CMOD,COMPONENT_SYS_IO_TYPE CSYS,PROCESS_FUNCTION CPF,PIPE_CLASS PC WHERE C.CMPNT_FUNC_TYPE_ID = CFT.CMPNT_FUNC_TYPE_ID AND CFT.PROC_FUNC_ID = CPF.PROC_FUNC_ID AND C.CMPNT_HANDLE_ID = CH.CMPNT_HANDLE_ID AND C.CMPNT_HANDLE_ID = CH.CMPNT_HANDLE_ID AND C.CMPNT_LOC_ID = CL.CMPNT_LOC_ID AND C.CMPNT_MFR_ID = CMFR.CMPNT_MFR_ID AND C.CMPNT_MOD_ID = CMOD.CMPNT_MOD_ID AND C.CMPNT_SYS_IO_TYPE_ID = CSYS.CMPNT_SYS_IO_TYPE_ID AND CMPNT_ID > 0 AND MASTER_CMPNT_ID = 0 AND CFT.PROC_FUNC_CAT_ID <> 20 AND PC.PIPE_CLASS_ID = C.PIPE_CLASS_ID;
CREATE OR REPLACE VIEW SCHEMA_VIEW_ELEC_EQUIPMENT_1 AS SELECT DRAWING.DWG_NAME,ELECTRICAL_EQUIPMENT.ELECT_EQUIP_NAME ELECT_EQUIP_NAME, ELECTRICAL_EQUIPMENT.ELECT_EQUIP_TYPE_ID ELECT_EQUIP_TYPE_ID, ELECTRICAL_EQUIPMENT.TYPICAL_SCHEMATIC TYPICAL_SCHEMATIC, ELECTRICAL_EQUIPMENT_TYPE.ELECT_EQUIP_TYPE_NAME ELECT_EQUIP_TYPE_NAME, ELECTRICAL_EQUIPMENT.ELECT_EQUIP_ID ELECT_EQUIP_ID FROM ELECTRICAL_EQUIPMENT, ELECTRICAL_EQUIPMENT_TYPE, DRAWING WHERE DRAWING.DWG_ID = ELECTRICAL_EQUIPMENT.DWG_SCHEMATIC_ID AND   ELECTRICAL_EQUIPMENT.ELECT_EQUIP_ID > 0 AND   ELECTRICAL_EQUIPMENT.ELECT_EQUIP_TYPE_ID = ELECTRICAL_EQUIPMENT_TYPE.ELECT_EQUIP_TYPE_ID;
CREATE OR REPLACE VIEW hybrid_control_valve_view (cmpnt_id,min_case_id,min_case_name,max_case_id,max_case_name,nor_case_id,nor_case_name, min_pd_flow_min,min_pd_flow_uid,min_pd_flow_uflg,max_pd_flow_max,max_pd_flow_uid,max_pd_flow_uflg,nor_pd_flow_nor,nor_pd_flow_uid, nor_pd_flow_uflg,min_pd_press_min,min_pd_press_uid,min_pd_press_uflg,max_pd_press_max,max_pd_press_uid,max_pd_press_uflg,nor_pd_press_nor, nor_pd_press_uid,nor_pd_press_uflg,min_pd_press_drp_min,min_pd_press_drp_uid,max_pd_press_drp_max,max_pd_press_drp_uid,nor_pd_press_drp_nor, nor_pd_press_drp_uid,min_pd_temp_min,min_pd_temp_uid,max_pd_temp_max,max_pd_temp_uid,nor_pd_temp_nor,nor_pd_temp_uid,min_pd_dens_min, min_pd_dens_uid,max_pd_dens_max,max_pd_dens_uid,nor_pd_dens_nor,nor_pd_dens_uid,min_pd_spec_grav_min,max_pd_spec_grav_max, nor_pd_spec_grav_nor,min_pd_compres_flow_min,max_pd_compres_flow_max,nor_pd_compres_flow_nor,min_pd_visc_min,min_pd_visc_uid,max_pd_visc_max, max_pd_visc_uid,nor_pd_visc_nor,nor_pd_visc_uid,min_pd_cp_cv_min,max_pd_cp_cv_max,nor_pd_cp_cv_nor,min_pd_vap_press_min,min_pd_vap_press_uid, min_pd_vap_press_uflg,max_pd_vap_press_max,max_pd_vap_press_uid,max_pd_vap_press_uflg,nor_pd_vap_press_nor,nor_pd_vap_press_uid, nor_pd_vap_press_uflg,min_pd_fluid_phase,max_pd_fluid_phase,nor_pd_fluid_phase,min_pd_fluid_name,max_pd_fluid_name,nor_pd_fluid_name, min_fluid_id,max_fluid_id,nor_fluid_id,min_pd_api_group_id,max_pd_api_group_id,nor_pd_api_group_id,min_pd_gas_sg_as_mm,max_pd_gas_sg_as_mm, nor_pd_gas_sg_as_mm,min_pd_critic_press,max_pd_critic_press,nor_pd_critic_press,min_pd_critic_press_uid,max_pd_critic_press_uid, nor_pd_critic_press_uid,min_pd_critic_press_uflg,max_pd_critic_press_uflg,nor_pd_critic_press_uflg,min_pd_molecular_mass, max_pd_molecular_mass,nor_pd_molecular_mass,max_cv_vlv_cv_max,nor_cv_vlv_cv_nor,min_cv_vlv_cv_min,max_cv_vlv_kv_max,nor_cv_vlv_kv_nor,min_cv_vlv_kv_min, max_cv_sound_lvl_max,nor_cv_sound_lvl_nor, min_cv_sound_lvl_min) AS select MN.CMPNT_ID,MN.CASE_ID,MN.CASE_NAME,MX.CASE_ID,MX.CASE_NAME,NOR.CASE_ID,NOR.CASE_NAME,MN.PD_FLOW_MIN, MN.PD_FLOW_UID,MN.PD_FLOW_UFLG,MX.PD_FLOW_MAX,MX.PD_FLOW_UID,MX.PD_FLOW_UFLG,NOR.PD_FLOW_NOR,NOR.PD_FLOW_UID,NOR.PD_FLOW_UFLG, MN.PD_PRESS_MIN,MN.PD_PRESS_UID,MN.PD_PRESS_UFLG,MX.PD_PRESS_MAX,MX.PD_PRESS_UID,MX.PD_PRESS_UFLG,NOR.PD_PRESS_NOR,NOR.PD_PRESS_UID, NOR.PD_PRESS_UFLG,MN.PD_PRESS_DRP_MIN,MN.PD_PRESS_DRP_UID,MX.PD_PRESS_DRP_MAX,MX.PD_PRESS_DRP_UID,NOR.PD_PRESS_DRP_NOR, NOR.PD_PRESS_DRP_UID,MN.PD_TEMP_MIN,MN.PD_TEMP_UID,MX.PD_TEMP_MAX,MX.PD_TEMP_UID,NOR.PD_TEMP_NOR,NOR.PD_TEMP_UID, MN.PD_DENS_MIN,MN.PD_DENS_UID,MX.PD_DENS_MAX,MX.PD_DENS_UID,NOR.PD_DENS_NOR,NOR.PD_DENS_UID,MN.PD_SPEC_GRAV_MIN, MX.PD_SPEC_GRAV_MAX,NOR.PD_SPEC_GRAV_NOR,MN.PD_COMPRES_FLOW_MIN,MX.PD_COMPRES_FLOW_MAX,NOR.PD_COMPRES_FLOW_NOR, MN.PD_VISC_MIN,MN.PD_VISC_UID,MX.PD_VISC_MAX,MX.PD_VISC_UID,NOR.PD_VISC_NOR,NOR.PD_VISC_UID,MN.PD_CP_CV_MIN, MX.PD_CP_CV_MAX,NOR.PD_CP_CV_NOR,MN.PD_VAP_PRESS_MIN,MN.PD_VAP_PRESS_UID,MN.PD_VAP_PRESS_UFLG,MX.PD_VAP_PRESS_MAX, MX.PD_VAP_PRESS_UID,MX.PD_VAP_PRESS_UFLG,NOR.PD_VAP_PRESS_NOR,NOR.PD_VAP_PRESS_UID,NOR.PD_VAP_PRESS_UFLG, MN.PD_FLUID_PHASE as MIN_PD_FLUID_PHASE,MX.PD_FLUID_PHASE as MAX_PD_FLUID_PHASE,NOR.PD_FLUID_PHASE as NOR_PD_FLUID_PHASE, MN.PD_FLUID_NAME as MIN_PD_FLUID_NAME,MX.PD_FLUID_NAME as MAX_PD_FLUID_NAME,NOR.PD_FLUID_NAME as NOR_PD_FLUID_NAME, MN.FLUID_ID as MIN_FLUID_ID,MX.FLUID_ID as MAX_FLUID_ID,NOR.FLUID_ID as NOR_FLUID_ID,MN.PD_API_GROUP_ID as MIN_PD_API_GROUP_ID, MX.PD_API_GROUP_ID as MAX_PD_API_GROUP_ID,NOR.PD_API_GROUP_ID as NOR_PD_API_GROUP_ID,MN.PD_GAS_SG_AS_MM as MIN_PD_GAS_SG_AS_MM, MX.PD_GAS_SG_AS_MM as MAX_PD_GAS_SG_AS_MM,NOR.PD_GAS_SG_AS_MM as NOR_PD_GAS_SG_AS_MM,MN.PD_CRITIC_PRESS as MIN_PD_CRITIC_PRESS, MX.PD_CRITIC_PRESS as MAX_PD_CRITIC_PRESS,NOR.PD_CRITIC_PRESS as NOR_PD_CRITIC_PRESS,MN.PD_CRITIC_PRESS_UID as MIN_PD_CRITIC_PRESS_UID, MX.PD_CRITIC_PRESS_UID as MAX_PD_CRITIC_PRESS_UID,NOR.PD_CRITIC_PRESS_UID as NOR_PD_CRITIC_PRESS_UID, MN.PD_CRITIC_PRESS_UFLG as MIN_PD_CRITIC_PRESS_UFLG,MX.PD_CRITIC_PRESS_UFLG as MAX_PD_CRITIC_PRESS_UFLG, NOR.PD_CRITIC_PRESS_UFLG as NOR_PD_CRITIC_PRESS_UFLG,MN.PD_MOLECULAR_MASS as MIN_PD_MOLECULAR_MASS, MX.PD_MOLECULAR_MASS as MAX_PD_MOLECULAR_MASS,NOR.PD_MOLECULAR_MASS as NOR_PD_MOLECULAR_MASS, MX.CV_VLV_CV_MAX,NOR.CV_VLV_CV_NOR,MN.CV_VLV_CV_MIN,MX.CV_VLV_KV_MAX,NOR.CV_VLV_KV_NOR,MN.CV_VLV_KV_MIN, MX.CV_SOUND_LVL_MAX,NOR.CV_SOUND_LVL_NOR,MN.CV_SOUND_LVL_MIN from MIN_CASE  MN,MAX_CASE  MX,NOR_CASE  NOR where MN.CMPNT_ID = MX.CMPNT_ID and MN.CMPNT_ID = NOR.CMPNT_ID UNION ALL SELECT CMPNT_ID,0,'',0,'',0,'',0, '','',0,'','',0,'','', 0,'','',0,'','',0,'','', 0,'',0,'',0, '',0,'',0,'',0,'', 0,'',0,'',0,'',0, 0,0,0,0,0, 0,'',0,'',0,'',0, 0,0,0,'','',0, '','',0,'','', '' as MIN_PD_FLUID_PHASE,'' as MAX_PD_FLUID_PHASE,'' as NOR_PD_FLUID_PHASE, '' as MIN_PD_FLUID_NAME,'' as MAX_PD_FLUID_NAME,'' as NOR_PD_FLUID_NAME, 0 as MIN_FLUID_ID,0 as MAX_FLUID_ID,0 as NOR_FLUID_ID,0 as MIN_PD_API_GROUP_ID, 0 as MAX_PD_API_GROUP_ID,0 as NOR_PD_API_GROUP_ID,0 as MIN_PD_GAS_SG_AS_MM, 0 as MAX_PD_GAS_SG_AS_MM,0 as NOR_PD_GAS_SG_AS_MM,0 as MIN_PD_CRITIC_PRESS, 0 as MAX_PD_CRITIC_PRESS,0 as NOR_PD_CRITIC_PRESS,'' as MIN_PD_CRITIC_PRESS_UID, '' as MAX_PD_CRITIC_PRESS_UID,'' as NOR_PD_CRITIC_PRESS_UID, '' as MIN_PD_CRITIC_PRESS_UFLG,'' as MAX_PD_CRITIC_PRESS_UFLG, '' as NOR_PD_CRITIC_PRESS_UFLG,0 as MIN_PD_MOLECULAR_MASS, 0 as MAX_PD_MOLECULAR_MASS,0 as NOR_PD_MOLECULAR_MASS,0, 0,0, 0,0,0, 0,0,0 from COMPONENT WHERE cmpnt_id not in (select cmpnt_id from MIN_CASE);
CREATE OR REPLACE VIEW SCHEMA_VIEW_UNIT AS SELECT PAU.UNIT_NAME UNIT_NAME FROM PLANT_AREA_UNIT PAU WHERE PAU.PLANT_ID > 0;
CREATE OR REPLACE VIEW SCHEMA_VIEW_FIELDBUS_INSTR AS SELECT DISTINCT C.CMPNT_ID CMPNT_ID, CPF.PROC_FUNC_NAME PROC_FUNC_NAME, C.CMPNT_SUFF CMPNT_SUFF, C.PREFIX PREFIX, C.CMPNT_NUM CMPNT_NUM, C.CMPNT_FUNC_TYPE_ID CMPNT_FUNC_TYPE_ID, C.CMPNT_HANDLE_ID CMPNT_HANDLE_ID, C.CMPNT_NAME CMPNT_NAME, C.CMPNT_NOTE CMPNT_NOTE, C.CMPNT_SEQ CMPNT_SEQ, C.CMPNT_SERV CMPNT_SERV, C.CMPNT_SYS_IO_TYPE_ID CMPNT_SYS_IO_TYPE_ID, C.EQUIP_ID EQUIP_ID, C.LINE_ID LINE_ID, C.LOOP_ID LOOP_ID, C.OLD_CMPNT_NAME OLD_CMPNT_NAME, C.PROC_FUNC_ID PROC_FUNC_ID, C.REMARK1 REMARK1, C.REMARK2 REMARK2, C.REMARK3 REMARK3, C.REMARK4 REMARK4, C.REMARK5 REMARK5, CFT.CMPNT_FUNC_TYPE_DESC CMPNT_FUNC_TYPE_DESC, CFT.CMPNT_FUNC_TYPE_NAME CMPNT_FUNC_TYPE_NAME, CH.CMPNT_HANDLE_DESC CMPNT_HANDLE_DESC, CH.CMPNT_HANDLE_NAME CMPNT_HANDLE_NAME, CL.CMPNT_LOC_DESC CMPNT_LOC_DESC, CL.CMPNT_LOC_NAME CMPNT_LOC_NAME, CMFR.CMPNT_MFR_DESC CMPNT_MFR_DESC, CMFR.CMPNT_MFR_NAME CMPNT_MFR_NAME, CMOD.CMPNT_MOD_DESC CMPNT_MOD_DESC, CMOD.CMPNT_MOD_NAME CMPNT_MOD_NAME, CSYS.CMPNT_SYS_IO_TYPE_DESC CMPNT_SYS_IO_TYPE_DESC, CSYS.CMPNT_SYS_IO_TYPE_NAME CMPNT_SYS_IO_TYPE_NAME, CMFR.MFR_COMPANY_IDENTIFICATION MFR_COMPANY_IDENTIFICATION, FBMFR.MFR_FUNC_DESC MFR_FUNC_DESC, C.FIELDBUS_DEVICE_REV FIELDBUS_DEVICE_REV, CFT.DEVICE_TYPE_ID DEVICE_TYPE_ID , C.FB_DEV_ADDRESS FB_DEV_ADDRESS, C.FB_DEV_ID FB_DEV_ID, C.BACKUP_LINK_MASTER BACKUP_LINK_MASTER FROM COMPONENT C, COMPONENT_FUNCTION_TYPE CFT, COMPONENT_HANDLE CH, COMPONENT_LOCATION CL, COMPONENT_MFR CMFR, COMPONENT_MOD CMOD, COMPONENT_SYS_IO_TYPE CSYS, PROCESS_FUNCTION CPF, FUNCTION_BLOCK_MFR_FUNC_REV FBMFR WHERE C.CMPNT_FUNC_TYPE_ID = CFT.CMPNT_FUNC_TYPE_ID AND CFT.PROC_FUNC_ID = CPF.PROC_FUNC_ID AND C.CMPNT_HANDLE_ID = CH.CMPNT_HANDLE_ID AND C.CMPNT_LOC_ID = CL.CMPNT_LOC_ID AND C.CMPNT_MFR_ID = CMFR.CMPNT_MFR_ID AND C.CMPNT_MOD_ID = CMOD.CMPNT_MOD_ID AND C.CMPNT_SYS_IO_TYPE_ID = CSYS.CMPNT_SYS_IO_TYPE_ID AND CMPNT_ID > 0 AND MASTER_CMPNT_ID = 0 AND CFT.PROC_FUNC_CAT_ID <> 20 AND C.CMPNT_SYS_IO_TYPE_ID = 7 AND FBMFR.CMPNT_FUNC_TYPE_ID = C.CMPNT_FUNC_TYPE_ID AND FBMFR.CMPNT_MFR_ID = C.CMPNT_MFR_ID;
CREATE OR REPLACE VIEW SCHEMA_VIEW_CARD_2 ( STRIP_NAME, POSITION, REDUNDANT_FLG, SERIES, STRIP_TYPE_DESC, PANEL_ID, STRIP_ID ) AS SELECT PANEL_STRIP.STRIP_NAME STRIP_NAME, (CABINET_RACK.rack_seq - 1) * CABINET_RACK.slot_count + PANEL_STRIP.POSITION POSITION, PANEL_STRIP.REDUNDANT_FLG REDUNDANT_FLG, PANEL_STRIP.SERIES SERIES, STRIP_TYPE.STRIP_TYPE_DESC STRIP_TYPE_DESC, PANEL_STRIP.PANEL_ID PANEL_ID, PANEL_STRIP.STRIP_ID STRIP_ID FROM PANEL_STRIP, STRIP_TYPE, CABINET_RACK WHERE PANEL_STRIP.PANEL_ID > 0 AND PANEL_STRIP.STRIP_ID > 0 AND PANEL_STRIP.STRIP_TYPE_ID = STRIP_TYPE.STRIP_TYPE_ID AND PANEL_STRIP.PANEL_ID = CABINET_RACK.PANEL_ID AND PANEL_STRIP.RACK_ID = CABINET_RACK.RACK_ID;
CREATE OR REPLACE VIEW NOR_CASE AS SELECT NOR_PD.CMPNT_ID,NOR_PD.CASE_ID,NOR_CASE.CASE_NAME,NOR_PD.PD_FLOW_NOR, NOR_PD.PD_FLOW_UID,NOR_PD.PD_FLOW_UFLG, NOR_PD.PD_PRESS_NOR,NOR_PD.PD_PRESS_UID,NOR_PD.PD_PRESS_UFLG, NOR_PD.PD_PRESS_DRP_NOR,NOR_PD.PD_PRESS_DRP_UID, NOR_PD.PD_TEMP_NOR,NOR_PD.PD_TEMP_UID,NOR_PD.PD_DENS_NOR,NOR_PD.PD_DENS_UID,NOR_PD.PD_SPEC_GRAV_NOR, NOR_PD.PD_COMPRES_FLOW_NOR,NOR_PD.PD_VISC_NOR,NOR_PD.PD_VISC_UID,NOR_PD.PD_CP_CV_NOR, NOR_PD.PD_VAP_PRESS_NOR,NOR_PD.PD_VAP_PRESS_UID,NOR_PD.PD_VAP_PRESS_UFLG, NOR_PD.PD_FLUID_PHASE as NOR_PD_FLUID_PHASE, NOR_PD.PD_FLUID_NAME as NOR_PD_FLUID_NAME, NOR_PD.FLUID_ID as NOR_FLUID_ID,NOR_PD.PD_API_GROUP_ID as NOR_PD_API_GROUP_ID, NOR_PD.PD_GAS_SG_AS_MM as NOR_PD_GAS_SG_AS_MM, NOR_PD.PD_CRITIC_PRESS as NOR_PD_CRITIC_PRESS, NOR_PD.PD_CRITIC_PRESS_UID as NOR_PD_CRITIC_PRESS_UID, NOR_PD.PD_CRITIC_PRESS_UFLG as NOR_PD_CRITIC_PRESS_UFLG, NOR_PD.PD_MOLECULAR_MASS as NOR_PD_MOLECULAR_MASS, NOR_PD.PD_FLUID_PHASE, NOR_PD.PD_FLUID_NAME, NOR_PD.FLUID_ID, NOR_PD.PD_API_GROUP_ID, NOR_PD.PD_GAS_SG_AS_MM, NOR_PD.PD_CRITIC_PRESS, NOR_PD.PD_CRITIC_PRESS_UID, NOR_PD.PD_CRITIC_PRESS_UFLG, NOR_PD.PD_MOLECULAR_MASS, NOR_CV.CV_VLV_CV_NOR, NOR_CV.CV_VLV_KV_NOR, NOR_CV.CV_SOUND_LVL_NOR FROM PD_GENERAL  NOR_PD, CONTROL_VALVE  NOR_CV, PROCESS_CONDITION  NOR_CASE WHERE NOR_PD.HYBRID_NORM = 2 AND NOR_CV.CASE_ID = NOR_PD.CASE_ID AND NOR_PD.CASE_ID = NOR_CASE.CASE_ID AND NOR_PD.CMPNT_ID = NOR_CV.CMPNT_ID AND NOR_PD.CASE_ID = NOR_CASE.CASE_ID UNION ALL SELECT NOR_PD.CMPNT_ID,NOR_PD.CASE_ID,NOR_CASE.CASE_NAME,NOR_PD.PD_FLOW_MIN, NOR_PD.PD_FLOW_UID,NOR_PD.PD_FLOW_UFLG, NOR_PD.PD_PRESS_MIN,NOR_PD.PD_PRESS_UID,NOR_PD.PD_PRESS_UFLG, NOR_PD.PD_PRESS_DRP_MIN,NOR_PD.PD_PRESS_DRP_UID, NOR_PD.PD_TEMP_MIN,NOR_PD.PD_TEMP_UID,NOR_PD.PD_DENS_MIN,NOR_PD.PD_DENS_UID,NOR_PD.PD_SPEC_GRAV_MIN, NOR_PD.PD_COMPRES_FLOW_MIN,NOR_PD.PD_VISC_MIN,NOR_PD.PD_VISC_UID,NOR_PD.PD_CP_CV_MIN, NOR_PD.PD_VAP_PRESS_MIN,NOR_PD.PD_VAP_PRESS_UID,NOR_PD.PD_VAP_PRESS_UFLG, NOR_PD.PD_FLUID_PHASE as NOR_PD_FLUID_PHASE, NOR_PD.PD_FLUID_NAME as NOR_PD_FLUID_NAME, NOR_PD.FLUID_ID as NOR_FLUID_ID,NOR_PD.PD_API_GROUP_ID as NOR_PD_API_GROUP_ID, NOR_PD.PD_GAS_SG_AS_MM as NOR_PD_GAS_SG_AS_MM, NOR_PD.PD_CRITIC_PRESS as NOR_PD_CRITIC_PRESS, NOR_PD.PD_CRITIC_PRESS_UID as NOR_PD_CRITIC_PRESS_UID, NOR_PD.PD_CRITIC_PRESS_UFLG as NOR_PD_CRITIC_PRESS_UFLG, NOR_PD.PD_MOLECULAR_MASS as NOR_PD_MOLECULAR_MASS, NOR_PD.PD_FLUID_PHASE, NOR_PD.PD_FLUID_NAME, NOR_PD.FLUID_ID, NOR_PD.PD_API_GROUP_ID, NOR_PD.PD_GAS_SG_AS_MM, NOR_PD.PD_CRITIC_PRESS, NOR_PD.PD_CRITIC_PRESS_UID, NOR_PD.PD_CRITIC_PRESS_UFLG, NOR_PD.PD_MOLECULAR_MASS, NOR_CV.CV_VLV_CV_MIN, NOR_CV.CV_VLV_KV_MIN, NOR_CV.CV_SOUND_LVL_MIN FROM PD_GENERAL NOR_PD, CONTROL_VALVE  NOR_CV, PROCESS_CONDITION  NOR_CASE WHERE NOR_PD.HYBRID_NORM = 1 AND NOR_CV.CASE_ID = NOR_PD.CASE_ID AND NOR_PD.CASE_ID = NOR_CASE.CASE_ID AND NOR_PD.CMPNT_ID = NOR_CV.CMPNT_ID AND NOR_PD.CASE_ID = NOR_CASE.CASE_ID UNION ALL SELECT NOR_PD.CMPNT_ID,NOR_PD.CASE_ID,NOR_CASE.CASE_NAME,NOR_PD.PD_FLOW_MAX, NOR_PD.PD_FLOW_UID,NOR_PD.PD_FLOW_UFLG, NOR_PD.PD_PRESS_MAX,NOR_PD.PD_PRESS_UID,NOR_PD.PD_PRESS_UFLG, NOR_PD.PD_PRESS_DRP_MAX,NOR_PD.PD_PRESS_DRP_UID, NOR_PD.PD_TEMP_MAX,NOR_PD.PD_TEMP_UID,NOR_PD.PD_DENS_MAX,NOR_PD.PD_DENS_UID,NOR_PD.PD_SPEC_GRAV_MAX, NOR_PD.PD_COMPRES_FLOW_MAX,NOR_PD.PD_VISC_MAX,NOR_PD.PD_VISC_UID,NOR_PD.PD_CP_CV_MAX, NOR_PD.PD_VAP_PRESS_MAX,NOR_PD.PD_VAP_PRESS_UID,NOR_PD.PD_VAP_PRESS_UFLG, NOR_PD.PD_FLUID_PHASE as NOR_PD_FLUID_PHASE, NOR_PD.PD_FLUID_NAME as NOR_PD_FLUID_NAME, NOR_PD.FLUID_ID as NOR_FLUID_ID,NOR_PD.PD_API_GROUP_ID as NOR_PD_API_GROUP_ID, NOR_PD.PD_GAS_SG_AS_MM as NOR_PD_GAS_SG_AS_MM, NOR_PD.PD_CRITIC_PRESS as NOR_PD_CRITIC_PRESS, NOR_PD.PD_CRITIC_PRESS_UID as NOR_PD_CRITIC_PRESS_UID, NOR_PD.PD_CRITIC_PRESS_UFLG as NOR_PD_CRITIC_PRESS_UFLG, NOR_PD.PD_MOLECULAR_MASS as NOR_PD_MOLECULAR_MASS, NOR_PD.PD_FLUID_PHASE, NOR_PD.PD_FLUID_NAME, NOR_PD.FLUID_ID, NOR_PD.PD_API_GROUP_ID, NOR_PD.PD_GAS_SG_AS_MM, NOR_PD.PD_CRITIC_PRESS, NOR_PD.PD_CRITIC_PRESS_UID, NOR_PD.PD_CRITIC_PRESS_UFLG, NOR_PD.PD_MOLECULAR_MASS, NOR_CV.CV_VLV_CV_MAX, NOR_CV.CV_VLV_KV_MAX, NOR_CV.CV_SOUND_LVL_MAX FROM PD_GENERAL NOR_PD, CONTROL_VALVE  NOR_CV, PROCESS_CONDITION  NOR_CASE WHERE NOR_PD.HYBRID_NORM = 3 AND NOR_CV.CASE_ID = NOR_PD.CASE_ID AND NOR_PD.CASE_ID = NOR_CASE.CASE_ID AND NOR_PD.CMPNT_ID = NOR_CV.CMPNT_ID AND NOR_PD.CASE_ID = NOR_CASE.CASE_ID;
CREATE OR REPLACE VIEW MIN_CASE AS SELECT MIN_PD.CMPNT_ID,MIN_PD.CASE_ID,MIN_CASE.CASE_NAME,MIN_PD.PD_FLOW_MIN, MIN_PD.PD_FLOW_UID,MIN_PD.PD_FLOW_UFLG, MIN_PD.PD_PRESS_MIN,MIN_PD.PD_PRESS_UID,MIN_PD.PD_PRESS_UFLG, MIN_PD.PD_PRESS_DRP_MIN,MIN_PD.PD_PRESS_DRP_UID, MIN_PD.PD_TEMP_MIN,MIN_PD.PD_TEMP_UID,MIN_PD.PD_DENS_MIN,MIN_PD.PD_DENS_UID,MIN_PD.PD_SPEC_GRAV_MIN, MIN_PD.PD_COMPRES_FLOW_MIN,MIN_PD.PD_VISC_MIN,MIN_PD.PD_VISC_UID,MIN_PD.PD_CP_CV_MIN, MIN_PD.PD_VAP_PRESS_MIN,MIN_PD.PD_VAP_PRESS_UID,MIN_PD.PD_VAP_PRESS_UFLG, MIN_PD.PD_FLUID_PHASE as MIN_PD_FLUID_PHASE, MIN_PD.PD_FLUID_NAME as MIN_PD_FLUID_NAME, MIN_PD.FLUID_ID as MIN_FLUID_ID,MIN_PD.PD_API_GROUP_ID as MIN_PD_API_GROUP_ID, MIN_PD.PD_GAS_SG_AS_MM as MIN_PD_GAS_SG_AS_MM, MIN_PD.PD_CRITIC_PRESS as MIN_PD_CRITIC_PRESS, MIN_PD.PD_CRITIC_PRESS_UID as MIN_PD_CRITIC_PRESS_UID, MIN_PD.PD_CRITIC_PRESS_UFLG as MIN_PD_CRITIC_PRESS_UFLG, MIN_PD.PD_MOLECULAR_MASS as MIN_PD_MOLECULAR_MASS, MIN_PD.PD_FLUID_PHASE, MIN_PD.PD_FLUID_NAME, MIN_PD.FLUID_ID, MIN_PD.PD_API_GROUP_ID, MIN_PD.PD_GAS_SG_AS_MM, MIN_PD.PD_CRITIC_PRESS, MIN_PD.PD_CRITIC_PRESS_UID, MIN_PD.PD_CRITIC_PRESS_UFLG, MIN_PD.PD_MOLECULAR_MASS, MIN_CV.CV_VLV_CV_MIN, MIN_CV.CV_VLV_KV_MIN, MIN_CV.CV_SOUND_LVL_MIN FROM PD_GENERAL  MIN_PD, CONTROL_VALVE  MIN_CV, PROCESS_CONDITION  MIN_CASE WHERE MIN_PD.HYBRID_MIN = 1 AND MIN_CV.CASE_ID = MIN_PD.CASE_ID AND MIN_PD.CASE_ID = MIN_CASE.CASE_ID AND MIN_PD.CMPNT_ID = MIN_CV.CMPNT_ID AND MIN_PD.CASE_ID = MIN_CASE.CASE_ID UNION ALL SELECT MIN_PD.CMPNT_ID,MIN_PD.CASE_ID,MIN_CASE.CASE_NAME,MIN_PD.PD_FLOW_NOR, MIN_PD.PD_FLOW_UID,MIN_PD.PD_FLOW_UFLG, MIN_PD.PD_PRESS_NOR,MIN_PD.PD_PRESS_UID,MIN_PD.PD_PRESS_UFLG, MIN_PD.PD_PRESS_DRP_NOR,MIN_PD.PD_PRESS_DRP_UID, MIN_PD.PD_TEMP_NOR,MIN_PD.PD_TEMP_UID,MIN_PD.PD_DENS_NOR,MIN_PD.PD_DENS_UID,MIN_PD.PD_SPEC_GRAV_NOR, MIN_PD.PD_COMPRES_FLOW_NOR,MIN_PD.PD_VISC_NOR,MIN_PD.PD_VISC_UID,MIN_PD.PD_CP_CV_NOR, MIN_PD.PD_VAP_PRESS_NOR,MIN_PD.PD_VAP_PRESS_UID,MIN_PD.PD_VAP_PRESS_UFLG, MIN_PD.PD_FLUID_PHASE as MIN_PD_FLUID_PHASE, MIN_PD.PD_FLUID_NAME as MIN_PD_FLUID_NAME, MIN_PD.FLUID_ID as MIN_FLUID_ID,MIN_PD.PD_API_GROUP_ID as MIN_PD_API_GROUP_ID, MIN_PD.PD_GAS_SG_AS_MM as MIN_PD_GAS_SG_AS_MM, MIN_PD.PD_CRITIC_PRESS as MIN_PD_CRITIC_PRESS, MIN_PD.PD_CRITIC_PRESS_UID as MIN_PD_CRITIC_PRESS_UID, MIN_PD.PD_CRITIC_PRESS_UFLG as MIN_PD_CRITIC_PRESS_UFLG, MIN_PD.PD_MOLECULAR_MASS as MIN_PD_MOLECULAR_MASS, MIN_PD.PD_FLUID_PHASE, MIN_PD.PD_FLUID_NAME, MIN_PD.FLUID_ID, MIN_PD.PD_API_GROUP_ID, MIN_PD.PD_GAS_SG_AS_MM, MIN_PD.PD_CRITIC_PRESS, MIN_PD.PD_CRITIC_PRESS_UID, MIN_PD.PD_CRITIC_PRESS_UFLG, MIN_PD.PD_MOLECULAR_MASS, MIN_CV.CV_VLV_CV_NOR, MIN_CV.CV_VLV_KV_NOR, MIN_CV.CV_SOUND_LVL_NOR FROM PD_GENERAL  MIN_PD, CONTROL_VALVE  MIN_CV, PROCESS_CONDITION  MIN_CASE WHERE MIN_PD.HYBRID_MIN = 2 AND MIN_CV.CASE_ID = MIN_PD.CASE_ID AND MIN_PD.CASE_ID = MIN_CASE.CASE_ID AND MIN_PD.CMPNT_ID = MIN_CV.CMPNT_ID AND MIN_PD.CASE_ID = MIN_CASE.CASE_ID UNION ALL SELECT MIN_PD.CMPNT_ID,MIN_PD.CASE_ID,MIN_CASE.CASE_NAME,MIN_PD.PD_FLOW_MAX, MIN_PD.PD_FLOW_UID,MIN_PD.PD_FLOW_UFLG, MIN_PD.PD_PRESS_MAX,MIN_PD.PD_PRESS_UID,MIN_PD.PD_PRESS_UFLG, MIN_PD.PD_PRESS_DRP_MAX,MIN_PD.PD_PRESS_DRP_UID, MIN_PD.PD_TEMP_MAX,MIN_PD.PD_TEMP_UID,MIN_PD.PD_DENS_MAX,MIN_PD.PD_DENS_UID,MIN_PD.PD_SPEC_GRAV_MAX, MIN_PD.PD_COMPRES_FLOW_MAX,MIN_PD.PD_VISC_MAX,MIN_PD.PD_VISC_UID,MIN_PD.PD_CP_CV_MAX, MIN_PD.PD_VAP_PRESS_MAX,MIN_PD.PD_VAP_PRESS_UID,MIN_PD.PD_VAP_PRESS_UFLG, MIN_PD.PD_FLUID_PHASE as MIN_PD_FLUID_PHASE, MIN_PD.PD_FLUID_NAME as MIN_PD_FLUID_NAME, MIN_PD.FLUID_ID as MIN_FLUID_ID,MIN_PD.PD_API_GROUP_ID as MIN_PD_API_GROUP_ID, MIN_PD.PD_GAS_SG_AS_MM as MIN_PD_GAS_SG_AS_MM, MIN_PD.PD_CRITIC_PRESS as MIN_PD_CRITIC_PRESS, MIN_PD.PD_CRITIC_PRESS_UID as MIN_PD_CRITIC_PRESS_UID, MIN_PD.PD_CRITIC_PRESS_UFLG as MIN_PD_CRITIC_PRESS_UFLG, MIN_PD.PD_MOLECULAR_MASS as MIN_PD_MOLECULAR_MASS, MIN_PD.PD_FLUID_PHASE, MIN_PD.PD_FLUID_NAME, MIN_PD.FLUID_ID, MIN_PD.PD_API_GROUP_ID, MIN_PD.PD_GAS_SG_AS_MM, MIN_PD.PD_CRITIC_PRESS, MIN_PD.PD_CRITIC_PRESS_UID, MIN_PD.PD_CRITIC_PRESS_UFLG, MIN_PD.PD_MOLECULAR_MASS, MIN_CV.CV_VLV_CV_MAX, MIN_CV.CV_VLV_KV_MAX, MIN_CV.CV_SOUND_LVL_MAX FROM PD_GENERAL  MIN_PD, CONTROL_VALVE  MIN_CV, PROCESS_CONDITION  MIN_CASE WHERE MIN_PD.HYBRID_MIN = 3 AND MIN_CV.CASE_ID = MIN_PD.CASE_ID AND MIN_PD.CASE_ID = MIN_CASE.CASE_ID AND MIN_PD.CMPNT_ID = MIN_CV.CMPNT_ID AND MIN_PD.CASE_ID = MIN_CASE.CASE_ID;
CREATE OR REPLACE VIEW SCHEMA_VIEW_FUNCTION_BLOCK (CS_TAG_NAME, BLOCK_TYPE_INDEX, BLOCK_ID) AS SELECT DISTINCT CST.CS_TAG_NAME CS_TAG_NAME, CFB.BLOCK_TYPE_INDEX BLOCK_TYPE_INDEX, CFB.BLOCK_ID FROM CONTROL_SYSTEM_TAG CST, CHANNEL CH, PANEL_STRIP PS, STRIP_MFR SM, CONTROLLER CTRL, COMPONENT_FUNCTION_BLOCK CFB, COMPONENT C WHERE PS.DEF_FLG = 'N' AND PS.CONTROLLER_ID > 0 AND PS.CONTROLLER_ID = CTRL.CONTROLLER_ID AND PS.PLANT_ID > 0 AND PS.CMPNT_SYS_IO_TYPE_ID = 7 AND PS.STRIP_MFR_ID = SM.STRIP_MFR_ID AND SM.STRIP_MFR_NAME = 'Emerson Process' AND PS.PANEL_ID = CH.PANEL_ID AND PS.STRIP_ID = CH.STRIP_ID AND CH.PANEL_ID = CST.PANEL_ID AND CH.STRIP_ID = CST.STRIP_ID AND CH.CHANNEL_TYPE_ID > 0 AND CH.CHANNEL_ID = CST.CHANNEL_ID AND CST.CS_TAG_ID > 0 AND CST.CMPNT_ID = CFB.CMPNT_ID AND C.CMPNT_ID = CFB.CMPNT_ID AND C.MASTER_CMPNT_ID > 0;
CREATE OR REPLACE VIEW SCHEMA_VIEW_PIPING_PORT_1 AS SELECT PP.CMPNT_ID CMPNT_ID,PP.PIPING_PORT_ID PIPING_PORT_ID,PP.PIPING_PORT_NAME PIPING_PORT_NAME,PP.STATUS STATUS,PP.DIM_CLASS_ID DIM_CLASS_ID,PP.DIM_END_PREP_ID DIM_END_PREP_ID,PP.DIM_SIZE DIM_SIZE FROM PIPING_PORT PP WHERE PP.CMPNT_ID > 0 AND PP.PIPING_PORT_ID > 0;
CREATE OR REPLACE VIEW SCHEMA_VIEW_PLANT (PLANT_NAME,ADDR1,ADDR2,CITY,STATE,ZIP,COUNTRY,PLANT_NOTE,OWNER_ID,LOCATION,PLANT_ID ) AS SELECT PLANT.PLANT_NAME PLANT_NAME,PLANT.ADDR1 ADDR1,PLANT.ADDR2 ADDR2,PLANT.CITY CITY ,PLANT.STATE STATE,PLANT.ZIP ZIP,PLANT.COUNTRY COUNTRY,PLANT.PLANT_NOTE PLANT_NOTE,PLANT.OWNER_ID OWNER_ID,PLANT.LOCATION LOCATION,PLANT.PLANT_ID PLANT_ID FROM PLANT WHERE PLANT.PLANT_ID > 0;
CREATE OR REPLACE VIEW SCHEMA_VIEW_INSTRUMENT_1 AS SELECT C.CMPNT_ID CMPNT_ID, CPF.PROC_FUNC_NAME PROC_FUNC_NAME, C.CMPNT_SUFF CMPNT_SUFF, C.PREFIX PREFIX, C.CMPNT_NUM CMPNT_NUM, C.CMPNT_FUNC_TYPE_ID CMPNT_FUNC_TYPE_ID, C.CMPNT_HANDLE_ID CMPNT_HANDLE_ID, C.CMPNT_NAME CMPNT_NAME, C.CMPNT_NOTE CMPNT_NOTE, C.CMPNT_SEQ CMPNT_SEQ, C.CMPNT_SERV CMPNT_SERV, C.CMPNT_SYS_IO_TYPE_ID CMPNT_SYS_IO_TYPE_ID, C.EQUIP_ID EQUIP_ID, C.LINE_ID LINE_ID, C.LOOP_ID LOOP_ID, C.OLD_CMPNT_NAME OLD_CMPNT_NAME, C.PROC_FUNC_ID PROC_FUNC_ID, C.REMARK1 REMARK1, C.REMARK2 REMARK2, C.REMARK3 REMARK3, C.REMARK4 REMARK4, C.REMARK5 REMARK5, PC.PIPE_CLASS_NAME PIPE_CLASS_NAME, CFT.CMPNT_FUNC_TYPE_DESC CMPNT_FUNC_TYPE_DESC, CFT.CMPNT_FUNC_TYPE_NAME CMPNT_FUNC_TYPE_NAME, CH.CMPNT_HANDLE_DESC CMPNT_HANDLE_DESC, CH.CMPNT_HANDLE_NAME CMPNT_HANDLE_NAME, CL.CMPNT_LOC_DESC CMPNT_LOC_DESC, CL.CMPNT_LOC_NAME CMPNT_LOC_NAME, CMFR.CMPNT_MFR_DESC CMPNT_MFR_DESC, CMFR.CMPNT_MFR_NAME CMPNT_MFR_NAME, CMOD.CMPNT_MOD_DESC CMPNT_MOD_DESC, CMOD.CMPNT_MOD_NAME CMPNT_MOD_NAME, CSYS.CMPNT_SYS_IO_TYPE_DESC CMPNT_SYS_IO_TYPE_DESC, CSYS.CMPNT_SYS_IO_TYPE_NAME CMPNT_SYS_IO_TYPE_NAME , C.CELL CELL, C.POWER_DISTRIBUTION_BOARD POWER_DISTRIBUTION_BOARD, C.CIRCUIT CIRCUIT, D.DWG_NAME PID_NUM FROM COMPONENT C, COMPONENT_FUNCTION_TYPE CFT, COMPONENT_HANDLE CH, COMPONENT_LOCATION CL, COMPONENT_MFR CMFR, COMPONENT_MOD CMOD, COMPONENT_SYS_IO_TYPE CSYS, PROCESS_FUNCTION CPF, PIPE_CLASS PC, DRAWING D WHERE C.CMPNT_FUNC_TYPE_ID = CFT.CMPNT_FUNC_TYPE_ID AND CFT.PROC_FUNC_ID = CPF.PROC_FUNC_ID AND C.CMPNT_HANDLE_ID = CH.CMPNT_HANDLE_ID AND C.CMPNT_HANDLE_ID = CH.CMPNT_HANDLE_ID AND C.CMPNT_LOC_ID = CL.CMPNT_LOC_ID AND C.CMPNT_MFR_ID = CMFR.CMPNT_MFR_ID AND C.CMPNT_MOD_ID = CMOD.CMPNT_MOD_ID AND C.CMPNT_SYS_IO_TYPE_ID = CSYS.CMPNT_SYS_IO_TYPE_ID AND CMPNT_ID > 0 AND MASTER_CMPNT_ID = 0 AND CFT.PROC_FUNC_CAT_ID <> 20 AND PC.PIPE_CLASS_ID = C.PIPE_CLASS_ID AND C.DWG_ID=D.DWG_ID;
CREATE OR REPLACE VIEW RANGE AS  select distinct c.cmpnt_id, c.dwg_id , c.proj_id , c.site_id , c.plant_id , c.area_id , c.unit_id , c.chg_num , c.user_name , c.chg_status , c.chg_date , NVL(f.pd_f_alarm_high_high,0) + NVL(l.pd_l_alarm_high_high,0) + NVL(p.pd_p_alarm_high_high,0) + NVL(a.pd_a_alarm_high_high,0) + NVL(t.pd_t_alarm_high_high,0) alarm_high_high, NVL(f.pd_f_alarm_high,0) + NVL(l.pd_l_alarm_high,0) + NVL(p.pd_p_alarm_high,0) + NVL(a.pd_a_alarm_high,0) + NVL(t.pd_t_alarm_high,0) alarm_high, NVL(f.pd_f_alarm_low_low,0) + NVL(l.pd_l_alarm_low_low,0) + NVL(p.pd_p_alarm_low_low,0) + NVL(a.pd_a_alarm_low_low,0) + NVL(t.pd_t_alarm_low_low,0) alarm_low_low, NVL(f.pd_f_alarm_low,0) + NVL(l.pd_l_alarm_low,0) + NVL(p.pd_p_alarm_low,0) + NVL(a.pd_a_alarm_low,0) + NVL(t.pd_t_alarm_low,0) alarm_low, ltrim(f.pd_f_trip_alarm_uflg,' ') || ltrim(p.pd_p_trip_alarm_uflg,' ') || ltrim(a.pd_a_trip_alarm_uflg,' ') trip_alarm_uflg, ltrim(f.pd_f_trip_alarm_uid,' ') || ltrim(l.pd_l_trip_alarm_uid,' ') || ltrim(p.pd_p_trip_alarm_uid,' ') || ltrim(a.pd_a_trip_alarm_uid,' ') || ltrim(t.pd_t_trip_alarm_uid,' ') trip_alarm_uid , NVL(f.pd_f_range_min,0) + NVL(l.pd_l_range_min,0) + NVL(p.pd_p_range_min,0) + NVL(a.pd_param_range_min,0) + NVL(t.pd_t_range_min,0) range_min, NVL(f.pd_f_range_max,0) + NVL(l.pd_l_range_max,0) + NVL(p.pd_p_range_max,0) + NVL(a.pd_param_range_max,0) + NVL(t.pd_t_range_max,0) range_max, ltrim(f.pd_f_range_uid,' ') || ltrim(l.pd_l_range_uid,' ') || ltrim(p.pd_p_range_uid,' ') || ltrim(a.pd_param_uid,' ')   || ltrim(t.pd_t_range_uid,' ') range_uid, ltrim(f.pd_f_range_uflg,' ') || ltrim(p.pd_p_range_uflg,' ') || ltrim(a.pd_param_uflg,' ') param_uflg from component c,analyzer a,flow f,pressure p,temperature t,level_instrument l where a.cmpnt_id (+)= c.cmpnt_id and f.cmpnt_id (+)= c.cmpnt_id and l.cmpnt_id (+)= c.cmpnt_id and p.cmpnt_id (+)= c.cmpnt_id and t.cmpnt_id (+)= c.cmpnt_id ;
CREATE OR REPLACE VIEW MAX_CASE AS SELECT MAX_PD.CMPNT_ID,MAX_PD.CASE_ID,MAX_CASE.CASE_NAME,MAX_PD.PD_FLOW_MAX, MAX_PD.PD_FLOW_UID,MAX_PD.PD_FLOW_UFLG, MAX_PD.PD_PRESS_MAX,MAX_PD.PD_PRESS_UID,MAX_PD.PD_PRESS_UFLG, MAX_PD.PD_PRESS_DRP_MAX,MAX_PD.PD_PRESS_DRP_UID, MAX_PD.PD_TEMP_MAX,MAX_PD.PD_TEMP_UID,MAX_PD.PD_DENS_MAX,MAX_PD.PD_DENS_UID,MAX_PD.PD_SPEC_GRAV_MAX, MAX_PD.PD_COMPRES_FLOW_MAX,MAX_PD.PD_VISC_MAX,MAX_PD.PD_VISC_UID,MAX_PD.PD_CP_CV_MAX, MAX_PD.PD_VAP_PRESS_MAX,MAX_PD.PD_VAP_PRESS_UID,MAX_PD.PD_VAP_PRESS_UFLG, MAX_PD.PD_FLUID_PHASE as MAX_PD_FLUID_PHASE, MAX_PD.PD_FLUID_NAME as MAX_PD_FLUID_NAME, MAX_PD.FLUID_ID as MAX_FLUID_ID,MAX_PD.PD_API_GROUP_ID as MAX_PD_API_GROUP_ID, MAX_PD.PD_GAS_SG_AS_MM as MAX_PD_GAS_SG_AS_MM, MAX_PD.PD_CRITIC_PRESS as MAX_PD_CRITIC_PRESS, MAX_PD.PD_CRITIC_PRESS_UID as MAX_PD_CRITIC_PRESS_UID, MAX_PD.PD_CRITIC_PRESS_UFLG as MAX_PD_CRITIC_PRESS_UFLG, MAX_PD.PD_MOLECULAR_MASS as MAX_PD_MOLECULAR_MASS, MAX_PD.PD_FLUID_PHASE, MAX_PD.PD_FLUID_NAME, MAX_PD.FLUID_ID, MAX_PD.PD_API_GROUP_ID, MAX_PD.PD_GAS_SG_AS_MM, MAX_PD.PD_CRITIC_PRESS, MAX_PD.PD_CRITIC_PRESS_UID, MAX_PD.PD_CRITIC_PRESS_UFLG, MAX_PD.PD_MOLECULAR_MASS, MAX_CV.CV_VLV_CV_MAX, MAX_CV.CV_VLV_KV_MAX, MAX_CV.CV_SOUND_LVL_MAX FROM PD_GENERAL  MAX_PD, CONTROL_VALVE  MAX_CV, PROCESS_CONDITION  MAX_CASE WHERE MAX_PD.HYBRID_MAX = 3 AND MAX_CV.CASE_ID = MAX_PD.CASE_ID AND MAX_PD.CASE_ID = MAX_CASE.CASE_ID AND MAX_PD.CMPNT_ID = MAX_CV.CMPNT_ID AND MAX_PD.CASE_ID = MAX_CASE.CASE_ID UNION ALL SELECT MAX_PD.CMPNT_ID,MAX_PD.CASE_ID,MAX_CASE.CASE_NAME,MAX_PD.PD_FLOW_MIN, MAX_PD.PD_FLOW_UID,MAX_PD.PD_FLOW_UFLG, MAX_PD.PD_PRESS_MIN,MAX_PD.PD_PRESS_UID,MAX_PD.PD_PRESS_UFLG, MAX_PD.PD_PRESS_DRP_MIN,MAX_PD.PD_PRESS_DRP_UID, MAX_PD.PD_TEMP_MIN,MAX_PD.PD_TEMP_UID,MAX_PD.PD_DENS_MIN,MAX_PD.PD_DENS_UID,MAX_PD.PD_SPEC_GRAV_MIN, MAX_PD.PD_COMPRES_FLOW_MIN,MAX_PD.PD_VISC_MIN,MAX_PD.PD_VISC_UID,MAX_PD.PD_CP_CV_MIN, MAX_PD.PD_VAP_PRESS_MIN,MAX_PD.PD_VAP_PRESS_UID,MAX_PD.PD_VAP_PRESS_UFLG, MAX_PD.PD_FLUID_PHASE as MAX_PD_FLUID_PHASE, MAX_PD.PD_FLUID_NAME as MAX_PD_FLUID_NAME, MAX_PD.FLUID_ID as MAX_FLUID_ID,MAX_PD.PD_API_GROUP_ID as MAX_PD_API_GROUP_ID, MAX_PD.PD_GAS_SG_AS_MM as MAX_PD_GAS_SG_AS_MM, MAX_PD.PD_CRITIC_PRESS as MAX_PD_CRITIC_PRESS, MAX_PD.PD_CRITIC_PRESS_UID as MAX_PD_CRITIC_PRESS_UID, MAX_PD.PD_CRITIC_PRESS_UFLG as MAX_PD_CRITIC_PRESS_UFLG, MAX_PD.PD_MOLECULAR_MASS as MAX_PD_MOLECULAR_MASS, MAX_PD.PD_FLUID_PHASE, MAX_PD.PD_FLUID_NAME, MAX_PD.FLUID_ID, MAX_PD.PD_API_GROUP_ID, MAX_PD.PD_GAS_SG_AS_MM, MAX_PD.PD_CRITIC_PRESS, MAX_PD.PD_CRITIC_PRESS_UID, MAX_PD.PD_CRITIC_PRESS_UFLG, MAX_PD.PD_MOLECULAR_MASS, MAX_CV.CV_VLV_CV_MIN, MAX_CV.CV_VLV_KV_MIN, MAX_CV.CV_SOUND_LVL_MIN FROM PD_GENERAL  MAX_PD, CONTROL_VALVE  MAX_CV, PROCESS_CONDITION  MAX_CASE WHERE MAX_PD.HYBRID_MAX = 1 AND MAX_CV.CASE_ID = MAX_PD.CASE_ID AND MAX_PD.CASE_ID = MAX_CASE.CASE_ID AND MAX_PD.CMPNT_ID = MAX_CV.CMPNT_ID AND MAX_PD.CASE_ID = MAX_CASE.CASE_ID UNION ALL SELECT MAX_PD.CMPNT_ID,MAX_PD.CASE_ID,MAX_CASE.CASE_NAME,MAX_PD.PD_FLOW_NOR, MAX_PD.PD_FLOW_UID,MAX_PD.PD_FLOW_UFLG, MAX_PD.PD_PRESS_NOR,MAX_PD.PD_PRESS_UID,MAX_PD.PD_PRESS_UFLG, MAX_PD.PD_PRESS_DRP_NOR,MAX_PD.PD_PRESS_DRP_UID, MAX_PD.PD_TEMP_NOR,MAX_PD.PD_TEMP_UID,MAX_PD.PD_DENS_NOR,MAX_PD.PD_DENS_UID,MAX_PD.PD_SPEC_GRAV_NOR, MAX_PD.PD_COMPRES_FLOW_NOR,MAX_PD.PD_VISC_NOR,MAX_PD.PD_VISC_UID,MAX_PD.PD_CP_CV_NOR, MAX_PD.PD_VAP_PRESS_NOR,MAX_PD.PD_VAP_PRESS_UID,MAX_PD.PD_VAP_PRESS_UFLG, MAX_PD.PD_FLUID_PHASE as MAX_PD_FLUID_PHASE, MAX_PD.PD_FLUID_NAME as MAX_PD_FLUID_NAME, MAX_PD.FLUID_ID as MAX_FLUID_ID,MAX_PD.PD_API_GROUP_ID as MAX_PD_API_GROUP_ID, MAX_PD.PD_GAS_SG_AS_MM as MAX_PD_GAS_SG_AS_MM, MAX_PD.PD_CRITIC_PRESS as MAX_PD_CRITIC_PRESS, MAX_PD.PD_CRITIC_PRESS_UID as MAX_PD_CRITIC_PRESS_UID, MAX_PD.PD_CRITIC_PRESS_UFLG as MAX_PD_CRITIC_PRESS_UFLG, MAX_PD.PD_MOLECULAR_MASS as MAX_PD_MOLECULAR_MASS, MAX_PD.PD_FLUID_PHASE, MAX_PD.PD_FLUID_NAME, MAX_PD.FLUID_ID, MAX_PD.PD_API_GROUP_ID, MAX_PD.PD_GAS_SG_AS_MM, MAX_PD.PD_CRITIC_PRESS, MAX_PD.PD_CRITIC_PRESS_UID, MAX_PD.PD_CRITIC_PRESS_UFLG, MAX_PD.PD_MOLECULAR_MASS, MAX_CV.CV_VLV_CV_NOR, MAX_CV.CV_VLV_KV_NOR, MAX_CV.CV_SOUND_LVL_NOR FROM PD_GENERAL  MAX_PD, CONTROL_VALVE  MAX_CV, PROCESS_CONDITION  MAX_CASE WHERE MAX_PD.HYBRID_MAX = 2 AND MAX_CV.CASE_ID = MAX_PD.CASE_ID AND MAX_PD.CASE_ID = MAX_CASE.CASE_ID AND MAX_PD.CMPNT_ID = MAX_CV.CMPNT_ID AND MAX_PD.CASE_ID = MAX_CASE.CASE_ID;
CREATE OR REPLACE VIEW REVISION_SPEC AS SELECT rev_id ,dwg_id ,proj_id ,site_id ,chg_num ,chg_status ,chg_date ,user_name ,plant_id ,area_id ,unit_id ,rev_no ,rev_create_by ,rev_date ,rev_desc ,rev_chk_by ,rev_appr_by ,rev_sign  FROM REVISION ;
Create or Replace View MATRIX_DDP_VIEW as   Select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn01,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 1  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn02,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 2  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn03,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 3  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn04,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 4  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn05,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 5  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn06,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 6  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn07,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 7  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn08,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 8  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn09,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 9  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn10,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 10  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn11,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 11  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn12,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 12  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn13,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 13  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn14,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 14  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn15,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 15  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn16,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 16  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn17,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 17  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn18,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 18  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn19,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 19  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn20,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 20  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn21,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 21  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn22,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 22  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn23,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 23  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn24,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 24  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn25,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 25  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn26,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 26  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn27,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 27  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn28,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 28  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn29,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 29  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg   Union  select distinct c.cmpnt_id,c.cmpnt_mod_id,  bsc.style_id, bsc.column_order,   nvl(bsc.not_zero_flg,'N') not_zero_flg,   min(nvl(cd.dim_grp_udfn30,-1)) dim_grp_udfn  from browse_style_column bsc,dimensional_group dg,   component_dimensional cd,component c   where bsc.style_id = dg.dim_grp_id   and dg.dim_grp_id = cd.dim_grp_id   and cd.cmpnt_id = c.cmpnt_id   and bsc.column_order = 30  and nvl(c.cmpnt_mod_id,0) > 0  group by c.cmpnt_id,c.cmpnt_mod_id,bsc.style_id,  bsc.column_order,bsc.not_zero_flg ;
Create or Replace View MATRIX_DDP1_VIEW as   Select distinct cmpnt_id,cmpnt_mod_id,style_id,   not_zero_flg,min(dim_grp_udfn) dim_grp_udfn  from MATRIX_DDP_VIEW group by cmpnt_id,cmpnt_mod_id,style_id,not_zero_flg;
Create or Replace View DDP_EXPORT_VIEW as Select distinct c.cmpnt_name cmpnt_name, pau.unit_num unit_num, cd.dim_pipe_design_area dim_pipe_design_area, l.line_num line_num, l.line_size line_size, e.equip_name equip_name, c.cmpnt_id cmpnt_id, dg.dim_grp_name dim_grp_name, dg.dim_grp_cad_code dim_grp_cad_code, cmfr.cmpnt_mfr_name cmpnt_mfr_name, cmod.cmpnt_mod_name cmpnt_mod_name, ds.dim_status_name dim_status_name, ds.rev_number dim_revision_number, ds.chg_date chg_date, cd.dim_inlet_size proc_conn1_size, pcc1.proc_connect_class_name proc_conn1_class_name, pcep1.proc_connect_end_prep_name proc_conn1_end_prep_name, pcep1.proc_connect_end_prep_des_cod proc_conn1_end_suffix, l.line_sched proc_conn1_line_sched, cd.dim_outlet_size proc_conn2_size, pcc2.proc_connect_class_name proc_conn2_class_name, pcep2.proc_connect_end_prep_name proc_conn2_end_prep_name, pcep2.proc_connect_end_prep_des_cod proc_conn2_end_suffix, l.line_sched proc_conn2_line_sched, cd.DIM_3_SIZE proc_conn3_size, pcc3.proc_connect_class_name proc_conn3_class_name, pcep3.PROC_CONNECT_END_PREP_NAME proc_conn3_end_prep_name, pcep3.proc_connect_end_prep_des_cod proc_conn3_end_suffix, l.line_sched proc_conn3_line_sched, cd.DIM_4_SIZE proc_conn4_size, pcc4.PROC_CONNECT_CLASS_NAME proc_conn4_class_name, pcep4.PROC_CONNECT_END_PREP_NAME proc_conn4_end_prep_name, pcep4.proc_connect_end_prep_des_cod proc_conn4_end_suffix, l.line_sched proc_conn4_line_sched, c.DRY_WEIGHT weight_dry, c.FULL_WEIGHT weight_wet, cd.dim_grp_udfn01 DIM_PARAM01, cd.dim_grp_udfn02 DIM_PARAM02, cd.dim_grp_udfn03 DIM_PARAM03, cd.dim_grp_udfn04 DIM_PARAM04, cd.dim_grp_udfn05 DIM_PARAM05, cd.dim_grp_udfn06 DIM_PARAM06, cd.dim_grp_udfn07 DIM_PARAM07, cd.dim_grp_udfn08 DIM_PARAM08, cd.dim_grp_udfn09 DIM_PARAM09, cd.dim_grp_udfn10 DIM_PARAM10, cd.dim_grp_udfn11 DIM_PARAM11, cd.dim_grp_udfn12 DIM_PARAM12, cd.dim_grp_udfn13 DIM_PARAM13, cd.dim_grp_udfn14 DIM_PARAM14, cd.dim_grp_udfn15 DIM_PARAM15, cd.dim_grp_udfn16 DIM_PARAM16, cd.dim_grp_udfn17 DIM_PARAM17, cd.dim_grp_udfn18 DIM_PARAM18, cd.dim_grp_udfn19 DIM_PARAM19, cd.dim_grp_udfn20 DIM_PARAM20, cd.dim_grp_udfn21 DIM_PARAM21, cd.dim_grp_udfn22 DIM_PARAM22, cd.dim_grp_udfn23 DIM_PARAM23, cd.dim_grp_udfn24 DIM_PARAM24, cd.dim_grp_udfn25 DIM_PARAM25, cd.dim_grp_udfn26 DIM_PARAM26, cd.dim_grp_udfn27 DIM_PARAM27, cd.dim_grp_udfn28 DIM_PARAM28, cd.dim_grp_udfn29 DIM_PARAM29, cd.dim_grp_udfn30 DIM_PARAM30 from component c, plant_area_unit pau, COMPONENT_MOD CMOD, COMPONENT_MFR CMFR, component_dimensional cd, line l, equipment e, dimensional_group dg, dimensional_status ds, process_connection_class pcc1, process_connection_class pcc2, process_connection_class pcc3, process_connection_class pcc4, process_connection_end_prep pcep1, process_connection_end_prep pcep2, process_connection_end_prep pcep3, process_connection_end_prep pcep4, MATRIX_DDP1_VIEW bsc where c.unit_id = pau.unit_id AND c.CMPNT_MOD_ID = cmod.CMPNT_MOD_ID AND c.CMPNT_MFR_ID = cmfr.CMPNT_MFR_ID and c.cmpnt_id = cd.cmpnt_id and c.line_id = l.line_id and c.equip_id = e.equip_id and cd.dim_grp_id = dg.dim_grp_id and cd.DIM_INLET_CLASS_ID = pcc1.PROC_CONNECT_CLASS_ID and cd.DIM_INLET_END_PREP_ID = pcep1.PROC_CONNECT_END_PREP_ID and cd.DIM_OUTLET_CLASS_ID = pcc2.PROC_CONNECT_CLASS_ID and cd.DIM_OUTLET_END_PREP_ID = pcep2.PROC_CONNECT_END_PREP_ID and cd.DIM_3_CLASS_ID = pcc3.PROC_CONNECT_CLASS_ID and cd.DIM_3_END_PREP_ID = pcep3.PROC_CONNECT_END_PREP_ID and cd.DIM_4_CLASS_ID = pcc4.PROC_CONNECT_CLASS_ID and cd.DIM_4_END_PREP_ID = pcep4.PROC_CONNECT_END_PREP_ID and cd.dim_status_id = ds.dim_status_id and nvl(c.cmpnt_mfr_id,0) > 0 and nvl(c.cmpnt_mod_id,0) > 0 and nvl(cd.dim_grp_id,0) > 0 and nvl(cd.DIM_INLET_CLASS_ID,0) > 0 and nvl(cd.DIM_INLET_END_PREP_ID,0) > 0 and nvl(cd.DIM_OUTLET_CLASS_ID,0) > 0 and nvl(cd.DIM_OUTLET_END_PREP_ID,0) > 0 and cd.DIM_INLET_SIZE is NOT NULL and cd.DIM_OUTLET_SIZE is NOT NULL and cd.cmpnt_id = ds.cmpnt_id and ((dg.connect_point_3 = 'Y' and nvl(cd.DIM_3_size,0) > 0 and nvl(DIM_3_CLASS_ID,0) > 0 and nvl(DIM_3_END_PREP_ID,0) > 0) or dg.connect_point_3 is null or dg.connect_point_3 = 'N') and ((dg.connect_point_4 = 'Y' and nvl(cd.DIM_4_size,0) > 0 and nvl(DIM_4_CLASS_ID,0) > 0 and nvl(DIM_4_END_PREP_ID,0) > 0) or dg.connect_point_4 is null or dg.connect_point_4 <> 'Y' ) and bsc.cmpnt_id = c.cmpnt_id and bsc.cmpnt_id = cd.cmpnt_id and bsc.cmpnt_id = ds.cmpnt_id and bsc.style_id = dg.dim_grp_id and bsc.cmpnt_mod_id = c.cmpnt_mod_id and (bsc.dim_grp_udfn > 0 or (bsc.dim_grp_udfn = 0 and bsc.not_zero_flg <> 'Y'));
CREATE OR REPLACE VIEW SCHEMA_VIEW_EPROJECT AS SELECT P.ENGINEER_NAME ENGINEER_NAME FROM ENGINEERING_PROJECT P;
CREATE OR REPLACE VIEW TERM_FROM_VIEW AS  SELECT DISTINCT W.CABLE_ID,W.CABLE_SET_ID,W.WIRE_ID,P.PANEL_NAME,PS.STRIP_NAME,PST.TERM_NUM FROM  WIRE   W, PANEL   P, PANEL_STRIP   PS, PANEL_STRIP_TERM   PST, WIRE_TERMINAL   WT WHERE W.CABLE_ID=WT.CABLE_ID AND W.CABLE_SET_ID=WT.CABLE_SET_ID AND W.WIRE_ID=WT.WIRE_ID AND WT.PANEL_ID=P.PANEL_ID AND WT.PANEL_ID=PS.PANEL_ID AND WT.STRIP_ID=PS.STRIP_ID AND WT.PANEL_ID=PST.PANEL_ID AND WT.STRIP_ID=PST.STRIP_ID AND WT.TERM_ID=PST.TERM_ID AND WT.CABLE_SIDE=1;
CREATE OR REPLACE VIEW TERM_TO_VIEW AS  SELECT DISTINCT W.CABLE_ID,W.CABLE_SET_ID,W.WIRE_ID,P.PANEL_NAME,PS.STRIP_NAME,PST.TERM_NUM FROM  WIRE   W, PANEL   P, PANEL_STRIP   PS, PANEL_STRIP_TERM   PST, WIRE_TERMINAL   WT WHERE W.CABLE_ID=WT.CABLE_ID AND W.CABLE_SET_ID=WT.CABLE_SET_ID AND W.WIRE_ID=WT.WIRE_ID AND WT.PANEL_ID=P.PANEL_ID AND WT.PANEL_ID=PS.PANEL_ID AND WT.STRIP_ID=PS.STRIP_ID AND WT.PANEL_ID=PST.PANEL_ID AND WT.STRIP_ID=PST.STRIP_ID AND WT.TERM_ID=PST.TERM_ID AND WT.CABLE_SIDE=2;
CREATE OR REPLACE VIEW SCHEMA_VIEW_LOOP_1 AS SELECT L.LOOP_ID LOOP_ID, L.LOOP_FUNC_ID LOOP_FUNC_ID, L.LOOP_NAME LOOP_NAME, L.LOOP_NOTE LOOP_NOTE, L.LOOP_PROC_ID LOOP_PROC_ID, L.LOOP_SERV LOOP_SERV, L.LOOP_TYPE_ID LOOP_TYPE_ID, L.OLD_LOOP_NAME OLD_LOOP_NAME, L.LOOP_NUM LOOP_NUM, L.LOOP_SUFF LOOP_SUFF, L.LOOP_PREFIX LOOP_PREFIX, LF.LOOP_FUNC_NAME LOOP_FUNC_NAME, LP.LOOP_PROC_NAME LOOP_PROC_NAME, LT.LOOP_TYPE_NAME LOOP_TYPE_NAME, P.PLANT_NAME PLANT_NAME, PA.AREA_NAME AREA_NAME, PAU.UNIT_NAME UNIT_NAME, PAU.UNIT_NUM UNIT_NUM FROM LOOP L, LOOP_FUNCTION LF, LOOP_PROC LP, LOOP_TYPE LT, PLANT P, PLANT_AREA PA, PLANT_AREA_UNIT PAU WHERE L.PLANT_ID = P.PLANT_ID AND L.AREA_ID = PA.AREA_ID AND L.UNIT_ID = PAU.UNIT_ID AND L.LOOP_FUNC_ID = LF.LOOP_FUNC_ID AND L.LOOP_PROC_ID = LP.LOOP_PROC_ID AND L.LOOP_TYPE_ID = LT.LOOP_TYPE_ID AND L.LOOP_ID > 0;
CREATE OR REPLACE VIEW PANEL_FROM_VIEW AS  SELECT DISTINCT C.CABLE_ID,P.PANEL_ID,P.PANEL_NAME FROM  CABLE   C, PANEL   P, WIRE_TERMINAL   WT WHERE C.CABLE_ID=WT.CABLE_ID AND WT.PANEL_ID=P.PANEL_ID AND WT.CABLE_SIDE=1 UNION ALL SELECT 0   CABLE_ID,0   PANEL_ID,' '   PANEL_NAME FROM  CABLE   C WHERE NOT EXISTS(SELECT 'X' FROM  WIRE_TERMINAL   WT WHERE C.CABLE_ID=WT.CABLE_ID AND WT.CABLE_SIDE=1);
CREATE OR REPLACE VIEW PANEL_TO_VIEW AS  SELECT DISTINCT C.CABLE_ID,P.PANEL_ID,P.PANEL_NAME FROM  CABLE   C, PANEL   P, WIRE_TERMINAL   WT WHERE C.CABLE_ID=WT.CABLE_ID AND WT.PANEL_ID=P.PANEL_ID AND WT.CABLE_SIDE=2 UNION ALL SELECT 0   CABLE_ID,0   PANEL_ID,' '   PANEL_NAME FROM  CABLE   C WHERE NOT EXISTS(SELECT 'X' FROM  WIRE_TERMINAL   WT WHERE C.CABLE_ID=WT.CABLE_ID AND WT.CABLE_SIDE=2);
CREATE OR REPLACE VIEW TERM_LEFT_VIEW  AS SELECT PS.STRIP_NAME,PST.TERM_NUM,C.CABLE_ID,C.CABLE_NUM,CS.CABLE_SET_ID,CS.CABLE_SET_NAME,W.WIRE_ID,W.WIRE_TAG,W.WIRE_COLOR_ID,W.SET_LEVEL,PST.PANEL_ID,PST.STRIP_ID,PST.TERM_ID,WT.CABLE_SIDE,W.INSTALL_INDEX1_ID,W.INSTALL_INDEX2_ID,W.INSTALL_INDEX3_ID,W.INSTALL_INDEX4_ID,W.INSTALL_INDEX5_ID FROM  PANEL_STRIP   PS, PANEL_STRIP_TERM   PST, WIRE   W, WIRE_TERMINAL   WT, CABLE_SET   CS, CABLE   C, PANEL_TEMP   PT WHERE(W.CABLE_ID=WT.CABLE_ID AND W.CABLE_SET_ID=WT.CABLE_SET_ID AND W.WIRE_ID=WT.WIRE_ID) AND(CS.CABLE_ID=W.CABLE_ID AND CS.CABLE_SET_ID=W.CABLE_SET_ID) AND(C.CABLE_ID=W.CABLE_ID) AND(PS.PANEL_ID=WT.PANEL_ID) AND(PS.STRIP_ID=WT.STRIP_ID) AND(PST.PANEL_ID=WT.PANEL_ID AND PST.STRIP_ID=WT.STRIP_ID AND PST.TERM_ID=WT.TERM_ID) AND PS.PANEL_ID=PT.PANEL_ID AND WT.TERM_SIDE='L';
CREATE OR REPLACE VIEW SCHEMA_VIEW_DRAWING AS SELECT D.DWG_NAME DWG_NAME FROM DRAWING D WHERE D.DWG_ID > 0;
CREATE OR REPLACE VIEW TERM_RIGHT_VIEW AS  SELECT PS.STRIP_NAME,PST.TERM_NUM,C.CABLE_ID,C.CABLE_NUM,CS.CABLE_SET_ID,CS.CABLE_SET_NAME,W.WIRE_ID,W.WIRE_TAG,W.WIRE_COLOR_ID,W.SET_LEVEL,PST.PANEL_ID,PST.STRIP_ID,PST.TERM_ID,WT.CABLE_SIDE,W.INSTALL_INDEX1_ID,W.INSTALL_INDEX2_ID,W.INSTALL_INDEX3_ID,W.INSTALL_INDEX4_ID,W.INSTALL_INDEX5_ID FROM  PANEL_STRIP   PS, PANEL_STRIP_TERM   PST, WIRE   W, WIRE_TERMINAL   WT, CABLE_SET   CS, CABLE   C, PANEL_TEMP   PT WHERE(W.CABLE_ID=WT.CABLE_ID AND W.CABLE_SET_ID=WT.CABLE_SET_ID AND W.WIRE_ID=WT.WIRE_ID) AND(CS.CABLE_ID=W.CABLE_ID AND CS.CABLE_SET_ID=W.CABLE_SET_ID) AND(C.CABLE_ID=W.CABLE_ID) AND(PS.PANEL_ID=WT.PANEL_ID) AND(PS.STRIP_ID=WT.STRIP_ID) AND(PST.PANEL_ID=WT.PANEL_ID AND PST.STRIP_ID=WT.STRIP_ID AND PST.TERM_ID=WT.TERM_ID) AND PS.PANEL_ID=PT.PANEL_ID AND WT.TERM_SIDE='R';
create or replace view v_instrument_function_block as  select c1.cmpnt_id, cfb.block_type_id, fbt.block_type_name, count( cfb.block_id) block_count, 1 block_exists, min(cfb.exec_time) exec_time, wg.group_name From component_function_block cfb, component c1, component c2, function_block_type fbt, wire_group wg where (c2.cmpnt_id = cfb.cmpnt_id and fbt.block_type_id = cfb.block_type_id  and wg.wire_group_id = c1.wire_group_id ) and ((  c2.master_cmpnt_id = 0 and c1.cmpnt_id = c2.cmpnt_id ) or ( c2.master_cmpnt_id > 0 and c1.cmpnt_id = c2.master_cmpnt_id ))group by c1.cmpnt_id, cfb.block_type_id,  fbt.block_type_name, wg.group_name union all select c1.cmpnt_id, 0 block_type_id,  ' ' block_type_name, 0 block_count,0 block_exists, 0 exec_time, wg.group_name from component c1, wire_group wg where not exists ( select 'x' from component_function_block cfb where  c1.cmpnt_id = cfb.cmpnt_id) and  not exists( select 'x' from component c2, component_function_block cfb where  c2.master_cmpnt_id > 0 and c1.cmpnt_id = c2.master_cmpnt_id and c1.cmpnt_id = cfb.cmpnt_id ) and wg.wire_group_id = c1.wire_group_id;
create or replace view instr_cstag_channel_panel as select c.cmpnt_id tag, max(cst.cs_tag_name) cst, max(ch.channel_name) ch, max(p.panel_name) p from component c, control_system_tag cst, channel ch, panel p where c.cmpnt_id > 0 and c.cmpnt_id = cst.cmpnt_id (+) and cst.channel_id = ch.channel_id (+) and cst.panel_id = p.panel_id (+) group by c.cmpnt_id;
CREATE OR REPLACE VIEW SCHEMA_VIEW_EQUIPMENT_6 AS SELECT E.EQUIP_DESC EQUIP_DESC,E.EQUIP_NAME EQUIP_NAME,E.EQUIP_TYPE_ID EQUIP_TYPE_ID,ET.EQUIP_TYPE_NAME EQUIP_TYPE_NAME,E.EQUIP_ID EQUIP_ID FROM EQUIPMENT E, EQUIPMENT_TYPE ET WHERE E.EQUIP_TYPE_ID = ET.EQUIP_TYPE_ID AND EQUIP_ID > 0 ;
CREATE OR REPLACE VIEW PANEL_LEFT_VIEW AS  SELECT TLV.PANEL_ID,TLV.STRIP_ID,TLV.TERM_ID,P.PANEL_NAME,TLV.CABLE_NUM,TLV.CABLE_SET_NAME,TLV.WIRE_TAG,TLV.STRIP_NAME,TLV.TERM_NUM,TLV.WIRE_COLOR_ID,TLV.SET_LEVEL,TLV.INSTALL_INDEX1_ID,TLV.INSTALL_INDEX2_ID,TLV.INSTALL_INDEX3_ID,TLV.INSTALL_INDEX4_ID,TLV.INSTALL_INDEX5_ID FROM  TERM_LEFT_VIEW   TLV, PANEL   P, WIRE_TERMINAL   WT WHERE TLV.CABLE_ID=WT.CABLE_ID AND TLV.CABLE_SET_ID=WT.CABLE_SET_ID AND TLV.WIRE_ID=WT.WIRE_ID AND WT.PANEL_ID=P.PANEL_ID AND WT.CABLE_SIDE=1 UNION ALL SELECT TLV.PANEL_ID,TLV.STRIP_ID,TLV.TERM_ID,' '  PANEL_NAME,TLV.CABLE_NUM,TLV.CABLE_SET_NAME,TLV.WIRE_TAG,TLV.STRIP_NAME,TLV.TERM_NUM,TLV.WIRE_COLOR_ID,TLV.SET_LEVEL,TLV.INSTALL_INDEX1_ID,TLV.INSTALL_INDEX2_ID,TLV.INSTALL_INDEX3_ID,TLV.INSTALL_INDEX4_ID,TLV.INSTALL_INDEX5_ID FROM  TERM_LEFT_VIEW   TLV WHERE NOT EXISTS(SELECT 'X' FROM  PANEL   P, WIRE_TERMINAL   WT WHERE TLV.CABLE_ID=WT.CABLE_ID AND TLV.CABLE_SET_ID=WT.CABLE_SET_ID AND TLV.WIRE_ID=WT.WIRE_ID AND WT.PANEL_ID=P.PANEL_ID AND WT.CABLE_SIDE=1);
CREATE OR REPLACE VIEW SCHEMA_VIEW_CIRCUIT_1 AS SELECT CIRCUIT_NAME CIRCUIT_NAME,CIRCUIT_DESC CIRCUIT_DESC,CIRCUIT_ID CIRCUIT_ID FROM CIRCUIT WHERE CIRCUIT_ID > 0;
CREATE OR REPLACE VIEW PANEL_RIGHT_VIEW AS  SELECT TRV.PANEL_ID,TRV.STRIP_ID,TRV.TERM_ID,TRV.CABLE_NUM,TRV.CABLE_SET_NAME,TRV.WIRE_TAG,TRV.STRIP_NAME,TRV.TERM_NUM,P.PANEL_NAME,TRV.WIRE_COLOR_ID,TRV.SET_LEVEL,TRV.INSTALL_INDEX1_ID,TRV.INSTALL_INDEX2_ID,TRV.INSTALL_INDEX3_ID,TRV.INSTALL_INDEX4_ID,TRV.INSTALL_INDEX5_ID FROM  TERM_RIGHT_VIEW   TRV, PANEL   P, WIRE_TERMINAL   WT WHERE TRV.CABLE_ID=WT.CABLE_ID AND TRV.CABLE_SET_ID=WT.CABLE_SET_ID AND TRV.WIRE_ID=WT.WIRE_ID AND WT.PANEL_ID=P.PANEL_ID AND WT.CABLE_SIDE=2 UNION ALL SELECT TRV.PANEL_ID,TRV.STRIP_ID,TRV.TERM_ID,TRV.CABLE_NUM,TRV.CABLE_SET_NAME,TRV.WIRE_TAG,TRV.STRIP_NAME,TRV.TERM_NUM,' '   PANEL_NAME,TRV.WIRE_COLOR_ID,TRV.SET_LEVEL,TRV.INSTALL_INDEX1_ID,TRV.INSTALL_INDEX2_ID,TRV.INSTALL_INDEX3_ID,TRV.INSTALL_INDEX4_ID,TRV.INSTALL_INDEX5_ID FROM  TERM_RIGHT_VIEW   TRV WHERE NOT EXISTS(SELECT 'X' FROM  PANEL   P, WIRE_TERMINAL   WT WHERE TRV.CABLE_ID=WT.CABLE_ID AND TRV.CABLE_SET_ID=WT.CABLE_SET_ID AND TRV.WIRE_ID=WT.WIRE_ID AND WT.PANEL_ID=P.PANEL_ID AND WT.CABLE_SIDE=2);
CREATE OR REPLACE VIEW view_line ( cmpnt_id,insulation_type,insulation_desc,pipe_mat_name,linear_exp_coef,linear_exp_coef_add,linear_exp_coef_uid, border_temp, temp_min, temp_max, temp_uid ) AS SELECT component.cmpnt_id, pd_insulation.insulation_type, pd_insulation.insulation_desc, pipe_material.pipe_mat_name, pipe_material.linear_exp_coef, pipe_material.linear_exp_coef_add, pipe_material.linear_exp_coef_uid, pipe_material.border_temp, pipe_material.temp_min, pipe_material.temp_max, pipe_material.temp_uid FROM component, line, pd_insulation, pipe_material WHERE ( line.line_id = component.line_id ) and ( pd_insulation.pd_insulation_id = line.pd_insulation_id ) and ( line.pipe_orif_mat_id = pipe_material.pipe_orif_mat_id );
create or replace view device_cable_view as  select distinct c.cmpnt_id, cb.* from component c, cable cb, panel_component pc, wire_terminal wt where c.cmpnt_id = pc.cmpnt_id and pc.panel_id = wt.panel_id and wt.cable_id = cb.cable_id  UNION ALL select distinct c.cmpnt_id, cb.*  from component c, cable cb where cb.cable_id = 1 and not exists (select 'x'   from wire_terminal wt , panel_component  pc   where pc.cmpnt_id = c.cmpnt_id and wt.panel_id = pc.panel_id) ;
create or replace view device_panel_view as  select distinct c.cmpnt_id, p.* from component c, panel p, panel_component pc where c.cmpnt_id = pc.cmpnt_id and pc.panel_id = p.panel_id UNION ALL select c.cmpnt_id, p.* from component c, panel p where p.panel_id = 0 and not exists (select 'x'  from panel_component  pc, panel p   where pc.cmpnt_id = c.cmpnt_id and p.panel_id = pc.panel_id) ;
CREATE OR REPLACE VIEW schema_view_line_6 (ansi_din,line_internal_dia,line_num,line_uom,line_sched,line_size,line_type_id,wall_thick,line_type_name,line_id,liquid_compres_calc_flg,pd_angle_of_repose,pd_build_tend,pd_chim_abstr_num,pd_coagulat,pd_colored,pd_compres_base,pd_compres_flow_max,pd_compres_flow_min,pd_compres_flow_nor,pd_contain_parts,pd_corrosive,pd_cp_cv_max,pd_cp_cv_min,pd_cp_cv_nor,pd_critic_press,pd_critic_press_uflg,pd_critic_press_uid,pd_dens_at_base,pd_dens_at_bas_uid,pd_dens_grav_flg,pd_dens_max,pd_dens_max_uid,pd_dens_min,pd_dens_min_uid,pd_dens_nor,pd_dens_nor_uid,pd_dens_uid,pd_design_temp_max,pd_design_temp_min,pd_design_temp_uid,pd_erosive,pd_flow_max,pd_flow_max_uflg,pd_flow_max_uid,pd_flow_min,pd_flow_min_uflg,pd_flow_min_uid,pd_flow_nor,pd_flow_nor_uflg,pd_flow_nor_uid,pd_flow_uflg,pd_flow_uid,pd_fluid_name,pd_fluid_phase,pd_fluid_stat,pd_gas_comp_dens_flg,pd_gas_mm_grav_flg,pd_gas_sg_as_mm,pd_heat_max,pd_heat_max_uid,pd_heat_min,pd_heat_min_uid,pd_heat_nor,pd_heat_nor_uid,pd_heat_uid,pd_latent_heat_max,pd_latent_heat_max_uid,pd_latent_heat_min,pd_latent_heat_min_uid,pd_latent_heat_nor,pd_latent_heat_nor_uid,pd_latent_heat_uid,pd_line_eq_flg,pd_molecular_mass,pd_note,pd_oxidizing,pd_press_base,pd_press_base_uid,pd_press_des,pd_press_des_min,pd_press_des_min_uflg,pd_press_des_min_uid,pd_press_des_uflg,pd_press_des_uid,pd_press_drp_max,pd_press_drp_max_uid,pd_press_drp_min,pd_press_drp_min_uid,pd_press_drp_nor,pd_press_drp_nor_uid,pd_press_drp_uid,pd_press_max,pd_press_max_uflg,pd_press_max_uid,pd_press_min,pd_press_min_uflg,pd_press_min_uid,pd_press_nor,pd_press_nor_uflg,pd_press_nor_uid,pd_press_uflg,pd_press_uid,pd_pulsation,pd_saturat_temp,pd_solidfy,pd_source,pd_spec_grav_base,pd_spec_grav_max,pd_spec_grav_min,pd_spec_grav_nor,pd_temp_base,pd_temp_base_uid,pd_temp_max,pd_temp_max_uid,pd_temp_min,pd_temp_min_uid,pd_temp_nor,pd_temp_nor_uid,pd_temp_uid,pd_term_shock,pd_toxic,pd_transparent,pd_vap_press_max,pd_vap_press_max_uflg,pd_vap_press_max_uid,pd_vap_press_min,pd_vap_press_min_uflg,pd_vap_press_min_uid,pd_vap_press_nor,pd_vap_press_nor_uflg,pd_vap_press_nor_uid,pd_vap_press_uflg,pd_vap_press_uid,pd_velocity_max,pd_velocity_max_uid,pd_velocity_min,pd_velocity_min_uid,pd_velocity_nor,pd_velocity_nor_uid,pd_velocity_uid,pd_vibration,pd_visc_max,pd_visc_max_uid,pd_visc_min,pd_visc_min_uid,pd_visc_nor,pd_visc_nor_uid,pd_visc_uid,pipe_size,rtg,pipe_class_name,pid_num)  AS SELECT l.ansi_din ansi_din,l.line_internal_dia line_internal_dia,l.line_num line_num,l.line_uom line_uom,l.line_sched line_sched,l.line_size line_size,l.line_type_id line_type_id,l.wall_thick wall_thick,lt.line_type_name line_type_name,pd.line_id line_id,pd.liquid_compres_calc_flg liquid_compres_calc_flg,pd.pd_angle_of_repose pd_angle_of_repose,pd.pd_build_tend pd_build_tend,pd.pd_chim_abstr_num pd_chim_abstr_num,pd.pd_coagulat pd_coagulat,pd.pd_colored pd_colored,pd.pd_compres_base pd_compres_base,pd.pd_compres_flow_max pd_compres_flow_max,pd.pd_compres_flow_min pd_compres_flow_min,pd.pd_compres_flow_nor pd_compres_flow_nor,pd.pd_contain_parts pd_contain_parts,pd.pd_corrosive pd_corrosive,pd.pd_cp_cv_max pd_cp_cv_max,pd.pd_cp_cv_min pd_cp_cv_min,pd.pd_cp_cv_nor pd_cp_cv_nor,pd.pd_critic_press pd_critic_press,pd.pd_critic_press_uflg pd_critic_press_uflg,pd.pd_critic_press_uid pd_critic_press_uid,pd.pd_dens_at_base pd_dens_at_base,pd.pd_dens_at_bas_uid pd_dens_at_bas_uid,pd.pd_dens_grav_flg pd_dens_grav_flg,pd.pd_dens_max pd_dens_max,pd.pd_dens_uid pd_dens_max_uid,pd.pd_dens_min pd_dens_min,pd.pd_dens_uid pd_dens_min_uid,pd.pd_dens_nor pd_dens_nor,pd.pd_dens_uid pd_dens_nor_uid,pd.pd_dens_uid pd_dens_uid,pd.pd_design_temp_max pd_design_temp_max,pd.pd_design_temp_min pd_design_temp_min,pd.pd_design_temp_uid pd_design_temp_uid,pd.pd_erosive pd_erosive,pd.pd_flow_max pd_flow_max,pd.pd_flow_uflg pd_flow_max_uflg,pd.pd_flow_uid pd_flow_max_uid,pd.pd_flow_min pd_flow_min,pd.pd_flow_uflg pd_flow_min_uflg,pd.pd_flow_uid pd_flow_min_uid,pd.pd_flow_nor pd_flow_nor,pd.pd_flow_uflg pd_flow_nor_uflg,pd.pd_flow_uid pd_flow_nor_uid,pd.pd_flow_uflg pd_flow_uflg,pd.pd_flow_uid pd_flow_uid,pd.pd_fluid_name pd_fluid_name,pd.pd_fluid_phase pd_fluid_phase,pd.pd_fluid_stat pd_fluid_stat,pd.pd_gas_comp_dens_flg pd_gas_comp_dens_flg,pd.pd_gas_mm_grav_flg pd_gas_mm_grav_flg,pd.pd_gas_sg_as_mm pd_gas_sg_as_mm,pd.pd_heat_max pd_heat_max,pd.pd_heat_uid pd_heat_max_uid,pd.pd_heat_min pd_heat_min,pd.pd_heat_uid pd_heat_min_uid,pd.pd_heat_nor pd_heat_nor,pd.pd_heat_uid pd_heat_nor_uid,pd.pd_heat_uid pd_heat_uid,pd.pd_latent_heat_max pd_latent_heat_max,pd.pd_latent_heat_uid pd_latent_heat_max_uid,pd.pd_latent_heat_min pd_latent_heat_min,pd.pd_latent_heat_uid pd_latent_heat_min_uid,pd.pd_latent_heat_nor pd_latent_heat_nor,pd.pd_latent_heat_uid pd_latent_heat_nor_uid,pd.pd_latent_heat_uid pd_latent_heat_uid,pd.pd_line_eq_flg pd_line_eq_flg,pd.pd_molecular_mass pd_molecular_mass,pd.pd_note pd_note,pd.pd_oxidizing pd_oxidizing,pd.pd_press_base pd_press_base,pd.pd_press_base_uid pd_press_base_uid,pd.pd_press_des pd_press_des,pd.pd_press_des_min pd_press_des_min,pd.pd_press_des_min_uflg pd_press_des_min_uflg,pd.pd_press_des_min_uid pd_press_des_min_uid,pd.pd_press_des_uflg pd_press_des_uflg,pd.pd_press_des_uid pd_press_des_uid,pd.pd_press_drp_max pd_press_drp_max,pd.pd_press_drp_uid pd_press_drp_max_uid,pd.pd_press_drp_min pd_press_drp_min,pd.pd_press_drp_uid pd_press_drp_min_uid,pd.pd_press_drp_nor pd_press_drp_nor,pd.pd_press_drp_uid pd_press_drp_nor_uid,pd.pd_press_drp_uid pd_press_drp_uid,pd.pd_press_max pd_press_max,pd.pd_press_uflg pd_press_max_uflg,pd.pd_press_uid pd_press_max_uid,pd.pd_press_min pd_press_min,pd.pd_press_uflg pd_press_min_uflg,pd.pd_press_uid pd_press_min_uid,pd.pd_press_nor pd_press_nor,pd.pd_press_uflg pd_press_nor_uflg,pd.pd_press_uid pd_press_nor_uid,pd.pd_press_uflg pd_press_uflg,pd.pd_press_uid pd_press_uid,pd.pd_pulsation pd_pulsation,pd.pd_saturat_temp pd_saturat_temp,pd.pd_solidfy pd_solidfy,pd.pd_source pd_source,pd.pd_spec_grav_base pd_spec_grav_base,pd.pd_spec_grav_max pd_spec_grav_max,pd.pd_spec_grav_min pd_spec_grav_min,pd.pd_spec_grav_nor pd_spec_grav_nor,pd.pd_temp_base pd_temp_base,pd.pd_temp_base_uid pd_temp_base_uid,pd.pd_temp_max pd_temp_max,pd.pd_temp_uid pd_temp_max_uid,pd.pd_temp_min pd_temp_min,pd.pd_temp_uid pd_temp_min_uid,pd.pd_temp_nor pd_temp_nor,pd.pd_temp_uid pd_temp_nor_uid,pd.pd_temp_uid pd_temp_uid,pd.pd_term_shock pd_term_shock,pd.pd_toxic pd_toxic,pd.pd_transparent pd_transparent,pd.pd_vap_press_max pd_vap_press_max,pd.pd_vap_press_uflg pd_vap_press_max_uflg,pd.pd_vap_press_uid pd_vap_press_max_uid,pd.pd_vap_press_min pd_vap_press_min,pd.pd_vap_press_uflg pd_vap_press_min_uflg,pd.pd_vap_press_uid pd_vap_press_min_uid,pd.pd_vap_press_nor pd_vap_press_nor,pd.pd_vap_press_uflg pd_vap_press_nor_uflg,pd.pd_vap_press_uid pd_vap_press_nor_uid,pd.pd_vap_press_uflg pd_vap_press_uflg,pd.pd_vap_press_uid pd_vap_press_uid,pd.pd_velocity_max pd_velocity_max,pd.pd_velocity_uid pd_velocity_max_uid,pd.pd_velocity_min pd_velocity_min,pd.pd_velocity_uid pd_velocity_min_uid,pd.pd_velocity_nor pd_velocity_nor,pd.pd_velocity_uid pd_velocity_nor_uid,pd.pd_velocity_uid pd_velocity_uid,pd.pd_vibration pd_vibration,pd.pd_visc_max pd_visc_max,pd.pd_visc_uid pd_visc_max_uid,pd.pd_visc_min pd_visc_min,pd.pd_visc_uid pd_visc_min_uid,pd.pd_visc_nor pd_visc_nor,pd.pd_visc_uid pd_visc_nor_uid,pd.pd_visc_uid pd_visc_uid,l.pipe_size pipe_size,l.rtg rtg,pc.pipe_class_name pipe_class_name,d.dwg_name pid_num  FROM line l,line_type lt,pd_general pd,pipe_class pc,drawing d WHERE l.line_type_id = lt.line_type_id AND l.line_id = pd.line_id AND l.line_id > 0 AND pd.governing_case = 1 AND pc.pipe_class_id = l.pipe_class_id AND l.dwg_id = d.dwg_id;
create or replace view control_system_view as select distinct c.cmpnt_id, cs.cs_tag_name, p.panel_name from component c, control_system_tag cs, panel p where c.cmpnt_id = cs.cmpnt_id and cs.panel_id = p.panel_id UNION ALL select distinct c.cmpnt_id, ' ', ' ' from component c where not exists (select 'x'  from control_system_tag cs   where c.cmpnt_id = cs.cmpnt_id   );
CREATE OR REPLACE VIEW SCHEMA_VIEW_AREA AS SELECT PA.AREA_NAME AREA_NAME FROM PLANT_AREA PA WHERE PA.PLANT_ID > 0;
CREATE OR REPLACE VIEW SCHEMA_VIEW_CABINETRACK_8 ( CABINET_RACK_DESC, CABINET_RACK_NAME, RACK_SEQ, SLOT_COUNT, RACK_ID) AS SELECT CR.CABINET_RACK_DESC CABINET_RACK_DESC, CR.CABINET_RACK_NAME CABINET_RACK_NAME, CR.RACK_SEQ RACK_SEQ, CR.SLOT_COUNT SLOT_COUNT, CR.RACK_ID RACK_ID FROM CABINET_RACK CR WHERE CR.PANEL_ID > 0;
CREATE OR REPLACE VIEW SCHEMA_VIEW_PANEL_3 AS SELECT P.PANEL_NAME PANEL_NAME, P.CS_NETWORK_NO CS_NETWORK_NO, P.CS_NODE_NO CS_NODE_NO, P.PANEL_NOTE PANEL_NOTE, P.CMPNT_CRITICAL_ID CMPNT_CRITICAL_ID,P.FREQUENCY_ID FREQUENCY_ID,P.NUMBER_OF_PHASES_ID NUMBER_OF_PHASES_ID,   P.OPERATING_MODE_ID OPERATING_MODE_ID,P.POWER_FACTOR_FULL_LOAD POWER_FACTOR_FULL_LOAD,P.RATED_VOLTAGE_ID RATED_VOLTAGE_ID,P.FULL_LOAD_CURRENT FULL_LOAD_CURRENT,P.STARTING_CURRENT STARTING_CURRENT,P.RATED_ACTIVE_LOAD RATED_ACTIVE_LOAD,P.RATED_APPARENT_LOAD RATED_APPARENT_LOAD,P.RATED_REACTIVE_LOAD RATED_REACTIVE_LOAD,P.POWER_SUPPLY_TYPE_FLAG OWER_SUPPLY_TYPE_FLAG,P.POWER_DISTRIBUTION_BOARD POWER_DISTRIBUTION_BOARD,P.CELL CELL,P.ZZCOINCIDENCEFACTOR ZZCOINCIDENCEFACTOR,P.ZCOINCIDENCEFACTOR ZCOINCIDENCEFACTOR,P.YCOINCIDENCEFACTOR YCOINCIDENCEFACTOR,P.XCOINCIDENCEFACTOR XCOINCIDENCEFACTOR,P.PHASE1 PHASE1,P.PHASE2 PHASE2,P.PHASE3 PHASE3,P.PANEL_TYPE_ID PANEL_TYPE_ID,P.PANEL_CATEGORY_ID PANEL_CATEGORY_ID,PT.PANEL_TYPE_NAME PANEL_TYPE_NAME,P.POWER_SUPPLY_TYPE_FLAG POWER_SUPPLY_TYPE_FLAG,P.CIRCUIT CIRCUIT, P.PANEL_ID PANEL_ID FROM PANEL P, PANEL_TYPE PT WHERE P.PANEL_ID > 0 AND P.DEF_FLG = 'N' AND P.PANEL_TYPE_ID = PT.PANEL_TYPE_ID;
CREATE OR REPLACE VIEW SCHEMA_VIEW_CONTROLSYSTEMTAG_1 AS SELECT CS_TAG_ID, CS_TAG_NAME CS_TAG_NAME, CMPNT_ID FROM CONTROL_SYSTEM_TAG WHERE CS_TAG_ID > 0;
CREATE OR REPLACE VIEW SCHEMA_VIEW_INSTRUMENT_2 (CMPNT_ID,PROC_FUNC_NAME,CMPNT_SUFF,PREFIX,CMPNT_NUM,CMPNT_FUNC_TYPE_ID,CMPNT_HANDLE_ID,CMPNT_NAME,CMPNT_NOTE,CMPNT_SEQ,CMPNT_SERV,CMPNT_SYS_IO_TYPE_ID,EQUIP_ID,LINE_ID,LOOP_ID,OLD_CMPNT_NAME,PROC_FUNC_ID,REMARK1,REMARK2,REMARK3,REMARK4,REMARK5,PIPE_CLASS_NAME,CMPNT_FUNC_TYPE_DESC,CMPNT_FUNC_TYPE_NAME,CMPNT_HANDLE_DESC,CMPNT_HANDLE_NAME,CMPNT_LOC_DESC,CMPNT_LOC_NAME,CMPNT_MFR_DESC,CMPNT_MFR_NAME,CMPNT_MOD_DESC,CMPNT_MOD_NAME,CMPNT_SYS_IO_TYPE_DESC,CMPNT_SYS_IO_TYPE_NAME,DIM_GRP_ID,DIM_STATUS_ID,DIM_REV_ID,SUSPECT_FLG,DIM_GRP_NAME,DIM_GRP_DESC,DRY_WEIGHT,FULL_WEIGHT,UOM_ID,DIM_GRP_UDFN01,DIM_GRP_UDFN02,DIM_GRP_UDFN03,DIM_GRP_UDFN04,DIM_GRP_UDFN05,DIM_GRP_UDFN06,DIM_GRP_UDFN07,DIM_GRP_UDFN08,DIM_GRP_UDFN09,DIM_GRP_UDFN10,DIM_GRP_UDFN11,DIM_GRP_UDFN12,DIM_GRP_UDFN13,DIM_GRP_UDFN14,DIM_GRP_UDFN15,DIM_GRP_UDFN16,DIM_GRP_UDFN17,DIM_GRP_UDFN18,DIM_GRP_UDFN19,DIM_GRP_UDFN20,DIM_GRP_UDFN21,DIM_GRP_UDFN22,DIM_GRP_UDFN23,DIM_GRP_UDFN24,DIM_GRP_UDFN25,DIM_GRP_UDFN26,DIM_GRP_UDFN27,DIM_GRP_UDFN28,DIM_GRP_UDFN29,DIM_GRP_UDFN30 ) AS SELECT C.CMPNT_ID CMPNT_ID,CPF.PROC_FUNC_NAME PROC_FUNC_NAME,C.CMPNT_SUFF CMPNT_SUFF,C.PREFIX PREFIX,C.CMPNT_NUM CMPNT_NUM,C.CMPNT_FUNC_TYPE_ID CMPNT_FUNC_TYPE_ID,C.CMPNT_HANDLE_ID CMPNT_HANDLE_ID,C.CMPNT_NAME CMPNT_NAME,C.CMPNT_NOTE CMPNT_NOTE,C.CMPNT_SEQ CMPNT_SEQ,C.CMPNT_SERV CMPNT_SERV,C.CMPNT_SYS_IO_TYPE_ID CMPNT_SYS_IO_TYPE_ID,C.EQUIP_ID EQUIP_ID,C.LINE_ID LINE_ID,C.LOOP_ID LOOP_ID,C.OLD_CMPNT_NAME OLD_CMPNT_NAME,C.PROC_FUNC_ID PROC_FUNC_ID,C.REMARK1 REMARK1,C.REMARK2 REMARK2,C.REMARK3 REMARK3,C.REMARK4 REMARK4,C.REMARK5 REMARK5,PC.PIPE_CLASS_NAME PIPE_CLASS_NAME,CFT.CMPNT_FUNC_TYPE_DESC CMPNT_FUNC_TYPE_DESC,CFT.CMPNT_FUNC_TYPE_NAME CMPNT_FUNC_TYPE_NAME,CH.CMPNT_HANDLE_DESC CMPNT_HANDLE_DESC,CH.CMPNT_HANDLE_NAME CMPNT_HANDLE_NAME,CL.CMPNT_LOC_DESC CMPNT_LOC_DESC,CL.CMPNT_LOC_NAME CMPNT_LOC_NAME,CMFR.CMPNT_MFR_DESC CMPNT_MFR_DESC,CMFR.CMPNT_MFR_NAME CMPNT_MFR_NAME,CMOD.CMPNT_MOD_DESC CMPNT_MOD_DESC,CMOD.CMPNT_MOD_NAME CMPNT_MOD_NAME,CSYS.CMPNT_SYS_IO_TYPE_DESC CMPNT_SYS_IO_TYPE_DESC,CSYS.CMPNT_SYS_IO_TYPE_NAME CMPNT_SYS_IO_TYPE_NAME,CD.DIM_GRP_ID DIM_GRP_ID,CD.DIM_STATUS_ID DIM_STATUS_ID,CD.DIM_REV_ID DIM_REV_ID,CD.SUSPECT_FLG SUSPECT_FLG,DG.DIM_GRP_NAME DIM_GRP_NAME,DG.DIM_GRP_DESC DIM_GRP_DESC,C.DRY_WEIGHT DRY_WEIGHT,C.FULL_WEIGHT FULL_WEIGHT,C.UOM_ID UOM_ID,CD.DIM_GRP_UDFN01 DIM_GRP_UDFN01,CD.DIM_GRP_UDFN02 DIM_GRP_UDFN02,CD.DIM_GRP_UDFN03 DIM_GRP_UDFN03,CD.DIM_GRP_UDFN04 DIM_GRP_UDFN04,CD.DIM_GRP_UDFN05 DIM_GRP_UDFN05,CD.DIM_GRP_UDFN06 DIM_GRP_UDFN06,CD.DIM_GRP_UDFN07 DIM_GRP_UDFN07,CD.DIM_GRP_UDFN08 DIM_GRP_UDFN08,CD.DIM_GRP_UDFN09 DIM_GRP_UDFN09,CD.DIM_GRP_UDFN10 DIM_GRP_UDFN10,CD.DIM_GRP_UDFN11 DIM_GRP_UDFN11,CD.DIM_GRP_UDFN12 DIM_GRP_UDFN12,CD.DIM_GRP_UDFN13 DIM_GRP_UDFN13,CD.DIM_GRP_UDFN14 DIM_GRP_UDFN14,CD.DIM_GRP_UDFN15 DIM_GRP_UDFN15,CD.DIM_GRP_UDFN16 DIM_GRP_UDFN16,CD.DIM_GRP_UDFN17 DIM_GRP_UDFN17,CD.DIM_GRP_UDFN18 DIM_GRP_UDFN18,CD.DIM_GRP_UDFN19 DIM_GRP_UDFN19,CD.DIM_GRP_UDFN20 DIM_GRP_UDFN20,CD.DIM_GRP_UDFN21 DIM_GRP_UDFN21,CD.DIM_GRP_UDFN22 DIM_GRP_UDFN22,CD.DIM_GRP_UDFN23 DIM_GRP_UDFN23,CD.DIM_GRP_UDFN24 DIM_GRP_UDFN24,CD.DIM_GRP_UDFN25 DIM_GRP_UDFN25,CD.DIM_GRP_UDFN26 DIM_GRP_UDFN26,CD.DIM_GRP_UDFN27 DIM_GRP_UDFN27,CD.DIM_GRP_UDFN28 DIM_GRP_UDFN28,CD.DIM_GRP_UDFN29 DIM_GRP_UDFN29,CD.DIM_GRP_UDFN30 DIM_GRP_UDFN30 FROM COMPONENT C,COMPONENT_FUNCTION_TYPE CFT,COMPONENT_HANDLE CH,COMPONENT_LOCATION CL,COMPONENT_MFR CMFR,COMPONENT_MOD CMOD,COMPONENT_SYS_IO_TYPE CSYS,PROCESS_FUNCTION CPF,COMPONENT_DIMENSIONAL CD,DIMENSIONAL_GROUP DG,PIPE_CLASS PC WHERE C.CMPNT_FUNC_TYPE_ID = CFT.CMPNT_FUNC_TYPE_ID AND CFT.PROC_FUNC_ID = CPF.PROC_FUNC_ID AND C.CMPNT_HANDLE_ID = CH.CMPNT_HANDLE_ID AND C.CMPNT_HANDLE_ID = CH.CMPNT_HANDLE_ID AND C.CMPNT_LOC_ID = CL.CMPNT_LOC_ID AND C.CMPNT_MFR_ID = CMFR.CMPNT_MFR_ID AND C.CMPNT_MOD_ID = CMOD.CMPNT_MOD_ID AND C.CMPNT_SYS_IO_TYPE_ID = CSYS.CMPNT_SYS_IO_TYPE_ID AND C.CMPNT_ID > 0 AND MASTER_CMPNT_ID = 0 AND CFT.PROC_FUNC_CAT_ID <> 20 AND C.CMPNT_ID = CD.CMPNT_ID AND CD.DIM_GRP_ID = DG.DIM_GRP_ID AND DG.DIM_GRP_ID > 0 AND PC.PIPE_CLASS_ID=C.PIPE_CLASS_ID;
CREATE OR REPLACE VIEW SCHEMA_VIEW_PANEL_2 AS SELECT P.PANEL_NAME PANEL_NAME, P.CS_NETWORK_NO CS_NETWORK_NO, P.CS_NODE_NO CS_NODE_NO, P.PANEL_NOTE PANEL_NOTE,  P.PANEL_ID PANEL_ID FROM PANEL P WHERE P.PANEL_ID > 0 AND P.DEF_FLG = 'N';
CREATE OR REPLACE VIEW SCHEMA_VIEW_CONTROLLER_1 AS SELECT CONTROLLER.CONTROLLER_NAME CONTROLLER_NAME, CONTROLLER.REDUNDANT_FLG REDUNDANT_FLG, CONTROLLER.CONTROLLER_ID FROM CONTROLLER WHERE CONTROLLER.CONTROLLER_ID > 0;
CREATE OR REPLACE VIEW VIEW_MEASURING_COMPONENT (MATERIAL,CONCENTRATION_MIN,CONCENTRATION_NOR,CONCENTRATION_MAX, CONCENTRATION_UID,LINE_CMPNT_ID,ANALYZER_FLG,CMPNT_ID)  AS SELECT  MEASURING_COMPONENT.MATERIAL, LINE_COMPONENT.CONCENTRATION_MIN, LINE_COMPONENT.CONCENTRATION_NOR, LINE_COMPONENT.CONCENTRATION_MAX, LINE_COMPONENT.CONCENTRATION_UID, LINE_COMPONENT.LINE_CMPNT_ID, COMPONENT.ANALYZER_FLG,COMPONENT.CMPNT_ID  FROM  COMPONENT, LINE_COMPONENT, MEASURING_COMPONENT  WHERE (COMPONENT.LINE_CMPNT_ID = LINE_COMPONENT.LINE_CMPNT_ID AND  COMPONENT.PROC_FUNC_ID = 5 AND  LINE_COMPONENT.MEASURING_ID = MEASURING_COMPONENT.MEASURING_ID)  UNION  SELECT '',0,0,0,'',0,'',COMPONENT.CMPNT_ID  FROM   COMPONENT, LINE_COMPONENT, MEASURING_COMPONENT  WHERE (COMPONENT.LINE_CMPNT_ID <> LINE_COMPONENT.LINE_CMPNT_ID OR  COMPONENT.LINE_CMPNT_ID = 0 OR COMPONENT.LINE_CMPNT_ID IS NULL) AND  COMPONENT.PROC_FUNC_ID <> 5  UNION  SELECT '',0,0,0,'',0,'',COMPONENT.CMPNT_ID  FROM  COMPONENT  WHERE COMPONENT.PROC_FUNC_ID = 5 AND  COMPONENT.LINE_CMPNT_ID IS NULL;
CREATE OR REPLACE VIEW SCHEMA_VIEW_PANEL_1 AS SELECT P.PANEL_NAME PANEL_NAME,P.PANEL_TYPE_ID PANEL_TYPE_ID,P.PANEL_CATEGORY_ID PANEL_CATEGORY_ID,PT.PANEL_TYPE_NAME PANEL_TYPE_NAME,P.PANEL_NOTE PANEL_NOTE, P.PANEL_ID PANEL_ID FROM PANEL P, PANEL_TYPE PT WHERE P.PANEL_ID > 0 AND P.DEF_FLG = 'N' AND P.PANEL_TYPE_ID = PT.PANEL_TYPE_ID;
CREATE OR REPLACE VIEW SCHEMA_VIEW_CARD_1 AS SELECT PANEL_STRIP.STRIP_NAME STRIP_NAME,PANEL_STRIP.POSITION POSITION,PANEL_STRIP.REDUNDANT_FLG REDUNDANT_FLG,PANEL_STRIP.SERIES SERIES,STRIP_TYPE.STRIP_TYPE_DESC STRIP_TYPE_DESC,PANEL_STRIP.PANEL_ID PANEL_ID, PANEL_STRIP.STRIP_ID STRIP_ID FROM PANEL_STRIP, STRIP_TYPE WHERE PANEL_STRIP.PANEL_ID > 0 AND   PANEL_STRIP.STRIP_ID > 0 AND   PANEL_STRIP.STRIP_TYPE_ID = STRIP_TYPE.STRIP_TYPE_ID;
CREATE OR REPLACE VIEW ANALYZER_MASTER_VIEW AS SELECT C1.CMPNT_ID AS CMPNT_MASTER_ID,C1.CMPNT_NAME AS CMPNT_NAME1,C2.CMPNT_NAME AS CMPNT_NAME2,C2.CMPNT_ID AS CMPNT_ID2,SSD.SPEC_UDF_C10 AS FUNC_LOCATION,SSD.SPEC_UDF_C11 AS PROCESS_LOCATION,SSD.SPEC_UDF_C14 AS SERIAL_NUMBER,SSD.SPEC_UDF_C15 AS WIN_NUMBER,SSD.SPEC_UDF_C16 AS ANALYZER_SHELTER_ID,SSD.SPEC_UDF_C01 AS AREA_CLASSIFICATION, SSD.SPEC_UDF_C06 AS EQA,SSD.SPEC_UDF_C24 AS ACCURACY_PRIORITY,SSD.SPEC_UDF_C26 AS NUMBER_OF_STREAMS,SSD.SPEC_UDF_C27 AS NUMBER_OF_PROGRAMS,SSD.SPEC_UDF_C19 AS REDUNDANT,SSD.SPEC_UDF_C20 AS COMM_PROTOCOL_ANALYZER,SSD.SPEC_UDF_C21 AS COMM_PROTOCOL_DCS,SSD.SPEC_UDF_C61 AS MFR_USER,SSD.SPEC_UDF_C100 AS MODEL_USER,C2.SPEC_CMPNT_PO_NO AS ORDER_NUMBER,C2.SPEC_CMPNT_PRICE AS PRISE,C2.SPEC_CMPNT_PO_ITEM_NO AS ITEM_NUMBER,C2.SPEC_CMPNT_SN AS MFR_SERIAL_NUMBER,C2.CMPNT_SERV AS SERVICE,C2.EQUIP_ID AS EQUIP_ID,E.EQUIP_NAME AS EQUIP_NAME,L.LINE_NUM AS LINE_NAME,D.DWG_NAME AS PID FROM COMPONENT  C1,COMPONENT  C2,SPEC_SHEET_DATA  SSD,EQUIPMENT  E,LINE  L,DRAWING  D WHERE C1.MASTER_CMPNT_ID = C2.CMPNT_ID AND C1.ANALYZER_FLG = 'S' AND C2.CMPNT_ID = SSD.CMPNT_ID AND C2.EQUIP_ID = E.EQUIP_ID AND C2.LINE_ID = L.LINE_ID AND C2.DWG_ID = D.DWG_ID UNION SELECT C1.CMPNT_ID AS CMPNT_MASTER_ID, C1.CMPNT_NAME AS CMPNT_NAME1, '' AS CMPNT_NAME2, C1.CMPNT_ID AS CMPNT_ID2, '', '', '', '', '', '', '','','','','','','','','','','','','','',0 ,'','','' FROM COMPONENT  C1 WHERE (C1.ANALYZER_FLG IS NULL OR C1.ANALYZER_FLG = '') UNION SELECT C1.CMPNT_ID AS CMPNT_MASTER_ID,C1.CMPNT_NAME AS CMPNT_NAME1,'' AS CMPNT_NAME2,C1.CMPNT_ID AS CMPNT_ID2,'','','','','','', '','','','','','','','','','','','','','',0 ,'','','' FROM COMPONENT  C1 WHERE C1.ANALYZER_FLG = 'M' AND C1.PROC_FUNC_ID = 5 UNION SELECT C1.CMPNT_ID AS CMPNT_MASTER_ID,C1.CMPNT_NAME AS CMPNT_NAME1,'' AS CMPNT_NAME2,C1.CMPNT_ID AS CMPNT_ID2,'','','','','','', '','','','','','','','','','','','','','',0 ,'','','' FROM COMPONENT  C1 WHERE C1.ANALYZER_FLG = 'C' AND C1.PROC_FUNC_ID = 5;