COMM_BUMON.SOSIKINM_L6,
COMM_BUMON.SYOKUSEI_CD,
INFT_KARI_NYUTEN.NYUTEN_YMD,
INFT_KARI_NYUTEN.KENSYU_YOTEI_YMD,
INFT_KARI_NYUTEN.KENSYU_TIME,
INFT_KARI_MENSETU.MENNSETU_YMD,
INFT_KARI_NYUTEN.TAITEN_YOTEI_YMD,
INFT_KARI_NYUTEN.STATUS_KBN,
INFT_KARI_NYUTEN.INS_YMD_HMS,
INFT_KARI_NYUTEN.INS_USER_ID,
INFT_KARI_NYUTEN.UPD_YMD_HMS,
INFT_KARI_NYUTEN.UPD_USER_IDFROM
INFT_KARI_NYUTEN,INFT_KARI_SUMIRE,INFT_KARI_MENSETU
,COMM_BUMON,COMM_TORI,COMM_SUMIRE_KBNWHERE
INFT_KARI_NYUTEN.KARI_KANRI_NO = INFT_KARI_SUMIRE.KARI_KANRI_NO
AND INFT_KARI_NYUTEN.KARI_KANRI_NO = INFT_KARI_MENSETU.KARI_KANRI_NO(+)
AND INFT_KARI_NYUTEN.EDANO = INFT_KARI_MENSETU.EDANO(+)
AND INFT_KARI_NYUTEN.S_BUMON_CD = COMM_BUMON.SOSIKI_CD(+)
AND INFT_KARI_SUMIRE.TORI_CD = COMM_TORI.TORI_CD(+)
AND INFT_KARI_NYUTEN.SUMIRE_KBN = COMM_SUMIRE_KBN.SUMIRE_KBN(+)
AND (INFT_KARI_MENSETU.MENSETU_KBN = '01' OR INFT_KARI_MENSETU.MENSETU_KBN IS NULL)
AND INFT_KARI_NYUTEN.STATUS_KBN IN('0','1','Z')
AND INFT_KARI_NYUTEN.NYUTEN_YMD >= TO_CHAR(SYSDATE,'YYYYMMDD')
UNION
SELECT
INFT_NYUTEN.KSYA_CD,
INFT_NYUTEN.TNP_CD,
INFT_NYUTEN.KANRI_NO,
INFT_NYUTEN.EDANO,
INFT_NYUTEN.SUMIRE_KBN,
COMM_SUMIRE_KBN.SUMIRE_KBN_NM,
COMM_SUMIRE_KBN.SUMIRE_KBN_RNM,
INFT_SUMIRE.JYUGYOIN_NO,
INFT_SUMIRE.ANAME_SEI,
INFT_SUMIRE.ANAME_MEI,
INFT_SUMIRE.KNAME_SEI,
INFT_SUMIRE.KNAME_MEI,
INFT_SUMIRE.TORI_CD,
COMM_TORI.TORI_NM,
INFT_SUMIRE.HAKEN_KAISYA,
INFT_NYUTEN.S_BUMON_CD,
COMM_BUMON.SOSIKINM_L4,
COMM_BUMON.SOSIKINM_L5,
COMM_BUMON.SOSIKINM_L6,
COMM_BUMON.SYOKUSEI_CD,
INFT_NYUTEN.NYUTEN_YMD,
INFT_NYUTEN.KENSYU_YOTEI_YMD,
INFT_NYUTEN.KENSYU_TIME,
INFT_MENSETU.MENNSETU_YMD,
INFT_NYUTEN.TAITEN_YOTEI_YMD,
INFT_NYUTEN.STATUS_KBN,
INFT_NYUTEN.INS_YMD_HMS,
INFT_NYUTEN.INS_USER_ID,
INFT_NYUTEN.UPD_YMD_HMS,
INFT_NYUTEN.UPD_USER_ID
FROM
INFT_NYUTEN,INFT_SUMIRE,INFT_MENSETU
,COMM_BUMON,COMM_TORI,COMM_SUMIRE_KBN
WHERE
INFT_NYUTEN.KANRI_NO = INFT_SUMIRE.KANRI_NO
AND INFT_NYUTEN.KANRI_NO = INFT_MENSETU.KANRI_NO(+)
AND INFT_NYUTEN.EDANO = INFT_MENSETU.EDANO(+)
AND INFT_NYUTEN.S_BUMON_CD = COMM_BUMON.SOSIKI_CD(+)
AND INFT_SUMIRE.TORI_CD = COMM_TORI.TORI_CD(+)
AND INFT_NYUTEN.SUMIRE_KBN = COMM_SUMIRE_KBN.SUMIRE_KBN(+)
AND (INFT_MENSETU.MENSETU_KBN = '01' OR INFT_MENSETU.MENSETU_KBN IS NULL)
AND INFT_NYUTEN.STATUS_KBN IN('2','3')
AND INFT_NYUTEN.NYUTEN_YMD >= TO_CHAR(SYSDATE,'YYYYMMDD')
/
COMMENT ON TABLE SUMIRE.VW_NYUTEN_YOTEILIST IS 'VW_入店予定者リスト'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.KSYA_CD IS '会社コード'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.TNP_CD IS '店舗コード'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.KANRI_NO IS '管理番号'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.EDANO IS '枝番'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.SUMIRE_KBN IS 'すみれ区分'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.SUMIRE_KBN_NM IS 'すみれ区分名称'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.SUMIRE_KBN_RNM IS 'すみれ区分略称'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.JYUGYOIN_NO IS '従业员番号'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.ANAME_SEI IS '氏名カナ_姓'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.ANAME_MEI IS '氏名カナ_名'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.KNAME_SEI IS '氏名汉字_姓'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.KNAME_MEI IS '氏名汉字_名'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.TORI_CD IS '取引先コード'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.TORI_NM IS '取引先名称'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.HAKEN_KAISYA IS '派遣会社名'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.S_BUMON_CD IS '所属部门コード'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.SOSIKINM_L4 IS '组织汉字名称４阶层'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.SOSIKINM_L5 IS '组织汉字名称５阶层'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.SOSIKINM_L6 IS '组织汉字名称６阶层'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.SYOKUSEI_CD IS '职制コード'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.NYUTEN_YMD IS '入店日'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.KENSYU_YOTEI_YMD IS '研修予定日'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.KENSYU_TIME IS '研修时刻'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.MENNSETU_YMD IS '面接実施日'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.TAITEN_YOTEI_YMD IS '退店予定日'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.STATUS_KBN IS '状态区分'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.INS_YMD_HMS IS '登録日时'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.INS_USER_ID IS '登録ユーザ'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.UPD_YMD_HMS IS '変更日时'
/
COMMENT ON COLUMN SUMIRE.VW_NYUTEN_YOTEILIST.UPD_USER_ID IS '変更ユーザ'
/
温馨提示：答案为网友推荐，仅供参考