INSERT INTO CABNABNMST(
FACTORY, -- WE1
ABN_NO, -- A202500001
USER_ID, -- S00711
USER_NAME, -- Chao Li
USER_GROUP, -- ADMIN_GROUP
USER_AREA, --
DATE_REPORT, -- 20251011103414
SERIOUS_INCIDENT,
QUALITY_FLAG, -- Y
SAFETY_FLAG,
ENVIRONMENT_FLAG,
FACILITY_FLAG,
EQP_FLAG,
QUALITY_APPR_FLAG,
SAFETY_APPR_FLAG,
ENVIRONMENT_APPR_FLAG,
FACILITY_APPR_FLAG,
EQP_APPR_FLAG,
PROBLEM_AREA,
PROBLEM_CATEGORY, -- Others
SUMMARY, -- ITTEST
DESCRIPTION, -- ITTEST
ROOT_CAUSE, --
ACTION_TAKEN,
MAT_DISPOSITION,
ROOT_CAUSE_CATEGORY,
RFC_FLAG,
OCC_DET_DIFF,
OCC_DEPARTMENT,
OCC_TIME, -- 20251011102154
DET_DEPARTMENT,
DET_TIME,
MAT_SEARCH_TYPE,
QUERY_BASED_ON, -- O
AFCT_TIME_FROM, -- 20251011102149
AFCT_TIME_TO, -- 20251011102149
MAT_ACTION,
TAG_CODE,
REP_PRODUCT,
REP_LOT,
ABN_CMF_1,
ABN_CMF_2, -- M600000
ABN_CMF_3, -- 0
ABN_CMF_4, -- 生产制造系统(MES)
ABN_CMF_5,
ABN_CMF_6,
ABN_CMF_7,
ABN_CMF_8, -- M600000
ABN_CMF_9,
ABN_CMF_10,
ABN_CMF_11,
ABN_CMF_12,
ABN_CMF_13,
ABN_CMF_14,
ABN_CMF_15,
ABN_CMF_16,
ABN_CMF_17,
ABN_CMF_18,
ABN_CMF_19,
ABN_CMF_20,
ABN_STATUS
)
VALUES (
:CABNABNMST_N.FACTORY,
:CABNABNMST_N.ABN_NO,
:CABNABNMST_N.USER_ID,
:CABNABNMST_N.USER_NAME,
:CABNABNMST_N.USER_GROUP,
:CABNABNMST_N.USER_AREA,
:CABNABNMST_N.DATE_REPORT,
:CABNABNMST_N.SERIOUS_INCIDENT,
:CABNABNMST_N.QUALITY_FLAG,
:CABNABNMST_N.SAFETY_FLAG,
:CABNABNMST_N.ENVIRONMENT_FLAG,
:CABNABNMST_N.FACILITY_FLAG,
:CABNABNMST_N.EQP_FLAG,
:CABNABNMST_N.QUALITY_APPR_FLAG,
:CABNABNMST_N.SAFETY_APPR_FLAG,
:CABNABNMST_N.ENVIRONMENT_APPR_FLAG,
:CABNABNMST_N.FACILITY_APPR_FLAG,
:CABNABNMST_N.EQP_APPR_FLAG,
:CABNABNMST_N.PROBLEM_AREA,
:CABNABNMST_N.PROBLEM_CATEGORY,
:CABNABNMST_N.SUMMARY,
:CABNABNMST_N.DESCRIPTION,
:CABNABNMST_N.ROOT_CAUSE,
:CABNABNMST_N.ACTION_TAKEN,
:CABNABNMST_N.MAT_DISPOSITION,
:CABNABNMST_N.ROOT_CAUSE_CATEGORY,
:CABNABNMST_N.RFC_FLAG,
:CABNABNMST_N.OCC_DET_DIFF,
:CABNABNMST_N.OCC_DEPARTMENT,
:CABNABNMST_N.OCC_TIME,
:CABNABNMST_N.DET_DEPARTMENT,
:CABNABNMST_N.DET_TIME,
:CABNABNMST_N.MAT_SEARCH_TYPE,
:CABNABNMST_N.QUERY_BASED_ON,
:CABNABNMST_N.AFCT_TIME_FROM,
:CABNABNMST_N.AFCT_TIME_TO,
:CABNABNMST_N.MAT_ACTION,
:CABNABNMST_N.TAG_CODE,
:CABNABNMST_N.REP_PRODUCT,
:CABNABNMST_N.REP_LOT,
:CABNABNMST_N.ABN_CMF_1,
:CABNABNMST_N.ABN_CMF_2,
:CABNABNMST_N.ABN_CMF_3,
:CABNABNMST_N.ABN_CMF_4,
:CABNABNMST_N.ABN_CMF_5,
:CABNABNMST_N.ABN_CMF_6,
:CABNABNMST_N.ABN_CMF_7,
:CABNABNMST_N.ABN_CMF_8,
:CABNABNMST_N.ABN_CMF_9,
:CABNABNMST_N.ABN_CMF_10,
:CABNABNMST_N.ABN_CMF_11,
:CABNABNMST_N.ABN_CMF_12,
:CABNABNMST_N.ABN_CMF_13,
:CABNABNMST_N.ABN_CMF_14,
:CABNABNMST_N.ABN_CMF_15,
:CABNABNMST_N.ABN_CMF_16,
:CABNABNMST_N.ABN_CMF_17,
:CABNABNMST_N.ABN_CMF_18,
:CABNABNMST_N.ABN_CMF_19,
:CABNABNMST_N.ABN_CMF_20,
:CABNABNMST_N.ABN_STATUS
); 改写这条SQL,值就是注释里面的内容
最新发布