Home Verkennen Help
Registreren Inloggen
NEW-Enterprise
/
reliability-platform-project
11
0
Vork 0
Bestanden Issues 0 Pull-aanvragen 0 Wiki
Boom: 7394049743
Aftakkingen Labels
reliability-...
/
SQL
/
view_sql

view_sql 2.8 KB
Geschiedenis Ruwe

123456789101112131415161718192021 
  1. CREATE OR REPLACE VIEW V_SYS_DELIVERY_MD
    2. 

  2. (DOCUMENT_ID,DOCUMENT_NAME,DOCUMENT_TYPE,LIFE_STATE,RELEASE_FLAG,INSERT_TIME,INSERT_USER_ID)
    3. 

  3. AS
    4. 

  4. SELECT DOCUMENT_ID, DOCUMENT_NAME, '002', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_BS_DOCUMENT UNION
    5. 

  5. SELECT PROJECT_INFO_ID, PROJECT_NAME, '004', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_WB_PROJECT_INFO UNION
    6. 

  6. SELECT PROJECT_ID, PROJECT_NAME, '005', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_WDA_PROJECT UNION
    7. 

  7. SELECT ASSESSMENT_ID, ASSESSMENT_NAME, '014', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_RA_ASSESSMENT UNION
    8. 

  8. SELECT PA_ANALYSIS_ID, PA_ANALYSIS_NAME, '015', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_PA_ANALYSIS UNION
    9. 

  9. SELECT TS_ID, TS_NAME, '019', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_TS_INFO WHERE TARGET_TYPE='31' UNION
    10. 

  10. SELECT TS_ID, TS_NAME, '020', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_TS_INFO WHERE TARGET_TYPE='32' UNION
    11. 

  11. SELECT PLAN_ID, PLAN_NAME, '022', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_RGT_PLAN UNION
    12. 

  12. SELECT SCHEDULE_ID, SCHEDULE_NAME, '023', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_RGT_SCHEDULE UNION
    13. 

  13. SELECT TRACK_ID, TRACK_NAME, '024', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_RGT_TRACK UNION
    14. 

  14. SELECT ANALYSIS_ID, ANALYSIS_NAME, '031', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_LD_ANALYSIS UNION
    15. 

  15. SELECT MULTI_CHART_ID, MULTI_CHART_NAME, '032', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_LD_MULTI_CHART UNION
    16. 

  16. SELECT DA_ID, DA_NAME, '034', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_DA_INFO UNION
    17. 

  17. SELECT FMEA_ID, FMEA_NAME, '035', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_DFMEA_INFO UNION
    18. 

  18. SELECT T.FMEA_ID, N.FMEA_NAME, '045', T.LIFE_STATE, if(T.LIFE_STATE='20', 1, 0) RELEASE_FLAG, T.INSERT_TIME, T.INSERT_USER_ID FROM T_RDFM_INFO T INNER JOIN T_RDFM_INFO_NLS N ON T.FMEA_ID=N.FMEA_ID AND N.LKEY=1 UNION
    19. 

  19. SELECT T.FMEA_ID, N.FMEA_NAME, '046', T.LIFE_STATE, if(T.LIFE_STATE='20', 1, 0) RELEASE_FLAG, T.INSERT_TIME, T.INSERT_USER_ID FROM T_RPFM_INFO T INNER JOIN T_RPFM_INFO_NLS N ON T.FMEA_ID=N.FMEA_ID AND N.LKEY=1 UNION
    20. 

  20. SELECT PD_ID, PD_NAME, '037', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_PD_INFO UNION
    21. 

  21. SELECT FMEA_ID, FMEA_NAME, '038', LIFE_STATE, if(LIFE_STATE='20', 1, 0) RELEASE_FLAG, INSERT_TIME, INSERT_USER_ID FROM T_PFMEA_INFO;
    22.