CREATE OR REPLACE VIEW STS.V_SUM_MROKG510
(JOSA_NO, JOSA_DATE, PDA_NO, SAUPNO, JUMINNO, SANGHO, DPYO_NM, TEL_NO, UPJONG, NEW_ZIP1, NEW_ZIP2, NEW_JUSO1, NEW_JUSO2, NEW_JUSO3, NEW_BUNJI, NEW_DORO, NEW_GMNO, NEW_GMNO2, NEW_GMNM, SAN_YN, KGCODE, PL_SD1, PL_SD2, PL_SD3, PL_SD4, PL_SD5, PL_SIZE, QTY, KG_MEMO, PS_JANGSO, DR_JC_YN, DR_JC_GARO, DR_JC_SERO, JBCODE, JB_YN, JM_GUBN, KG_WICHI, KGM_TYPE, JB_SANGTAE, JANGSO_GB, START_PSILJA, HG_YN, HG_NO, HG_SIN_ILJA, AJDO_ILJA, END_ILJA, GGJ_SANGHO, GGJ_DNAME, GGJ_TEL, KGJ_PRT_YN, KGJ_PRT_SEQ, INS_DATE, INS_MAN, MOD_DATE, MOD_MAN, GETAPV_PERM_NO, KGJ_PRT_DATE, FIND_DATA, HJDONG, REINVEST, NEW_JUSO4, PLCD, JUNCTION_YN, CENT_SIDE_YN, PS_JANGSO_TOP, SEND_DATE, GETAPV_INS_DATE, GETAPV_MOD_DATE, GETAPV_DEL_DATE, GETAPV_STATUS, WORK_CODE, WORK_DATE, WORK_MEMO, PRTCHKYN) 
AS
SELECT JOSA_NO,
       JOSA_DATE,
       PDA_NO,
       SAUPNO,
       JUMINNO,
       SANGHO,
       DPYO_NM,
       TEL_NO,
       UPJONG,
       NEW_ZIP1,
       NEW_ZIP2,
       NEW_JUSO1,
       NEW_JUSO2,
       NEW_JUSO3,
       NEW_BUNJI,
       NEW_DORO,
       NEW_GMNO,
       --NEW_GMNO2,
       --2013-10-24 JSK ǹȣ2 NULL ϶ 0 ־ Ͱ ߺ  ʵ 
       nvl(NEW_GMNO2,'0') as NEW_GMNO2,
       NEW_GMNM,
       SAN_YN,
       KGCODE,
       PL_SD1,
       PL_SD2,
       PL_SD3,
       PL_SD4,
       PL_SD5,
       PL_SIZE,
       QTY,
       KG_MEMO,
       PS_JANGSO,
       DR_JC_YN,
       DR_JC_GARO,
       DR_JC_SERO,
       JBCODE,
       JB_YN,
       JM_GUBN,
       KG_WICHI,
       KGM_TYPE,
       JB_SANGTAE,
       JANGSO_GB,
       START_PSILJA,
       HG_YN,
       HG_NO,
       HG_SIN_ILJA,
       AJDO_ILJA,
       END_ILJA,
       GGJ_SANGHO,
       GGJ_DNAME,
       GGJ_TEL,
       KGJ_PRT_YN,
       KGJ_PRT_SEQ,
       INS_DATE,
       INS_MAN,
       MOD_DATE,
       MOD_MAN,
       GETAPV_PERM_NO,
       KGJ_PRT_DATE,
       FIND_DATA,
       HJDONG,
       REINVEST,
       NEW_JUSO4,
       PLCD,
       JUNCTION_YN,
       CENT_SIDE_YN,
       PS_JANGSO_TOP,
       SEND_DATE,
       GETAPV_INS_DATE,
       GETAPV_MOD_DATE,
       GETAPV_DEL_DATE,
       GETAPV_STATUS,
       WORK_CODE,
       WORK_DATE,
       WORK_MEMO,
       PRTCHKYN 
  FROM MROKG510 
 WHERE JB_SANGTAE IS NULL 
       OR JB_SANGTAE NOT IN ('1','2');

commit;
