根据DER_DESIGN_NAME、DER_DESIGN_VERSION、PARTPN将bom_functiontemp表中的数据转移至bom_function表中
MERGE INTO bom_function bf USING bom_functiontemp bft ON (
bf.der_design_name = bft.der_design_name
AND bf.der_design_version = bft.der_design_version
AND bf.partpn = bft.partpn
AND bf.instance_name = bft.instance_name
)
WHEN MATCHED THEN
UPDATE
SET bf.GMT_CREATED = bft.GMT_CREATED,
bf.GMT_MODIFIED = bft.GMT_MODIFIED,
bf.CIRCUIT_NO = bft.CIRCUIT_NO,
bf.COMPOSITE_NAME = bft.COMPOSITE_NAME,
bf.COMPOSITEPN = bft.COMPOSITEPN,
bf.COMPOSITE_VERSION = bft.COMPOSITE_VERSION,
bf.COST = bft.COST,
bf.DER_DESIGN_LEVEL = bft.DER_DESIGN_LEVEL,
bf.DER_HARNESSPN = bft.DER_HARNESSPN,
bf.FUNCTION_CODE = bft.FUNCTION_CODE,
bf.MC_TYPE_CODE = bft.MC_TYPE_CODE,
bf.MULTICORE_NAME = bft.MULTICORE_NAME,
bf.OPTION_CODE = bft.OPTION_CODE,
bf.PROJECT_NAME = bft.PROJECT_NAME,
bf.QUANTITY = bft.QUANTITY,
bf.RELATED_CAVITY = bft.RELATED_CAVITY,
bf.RELATED_CONN = bft.RELATED_CONN,
bf.RELATED_WIRE = bft.RELATED_WIRE,
bf.TWIST_RATE = bft.TWIST_RATE,
bf.TYPE_CODE = bft.TYPE_CODE,
bf.UNIT = bft.UNIT,
bf.WEIGHT = bft.WEIGHT,
bf.WIRE_COLOR = bft.WIRE_COLOR,
bf.WIRE_CSA = bft.WIRE_CSA,
bf.WIRE_DESCRIPTION = bft.WIRE_DESCRIPTION,
bf.WIRE_FROM = bft.WIRE_FROM,
bf.WIRE_FROM_CAVITY = bft.WIRE_FROM_CAVITY,
bf.WIRE_MATERIAL_CODE = bft.WIRE_MATERIAL_CODE,
bf.WIRE_TO = bft.WIRE_TO,
bf.WIRE_TO_CAVITY = bft.WIRE_TO_CAVITY,
bf.WIRE_USAGE = bft.WIRE_USAGE
WHEN NOT MATCHED THEN
INSERT (
bf.id,
bf.GMT_CREATED,
bf.GMT_MODIFIED,
bf.CIRCUIT_NO,
bf.COMPOSITE_NAME,
bf.COMPOSITEPN,
bf.COMPOSITE_VERSION,
bf.COST,
bf.DER_DESIGN_LEVEL,
bf.DER_DESIGN_NAME,
bf.DER_DESIGN_VERSION,
bf.DER_HARNESSPN,
bf.FUNCTION_CODE,
bf.INSTANCE_NAME,
bf.MC_TYPE_CODE,
bf.MULTICORE_NAME,
bf.OPTION_CODE,
bf.PARTPN,
bf.PROJECT_NAME,
bf.QUANTITY,
bf.RELATED_CAVITY,
bf.RELATED_CONN,
bf.RELATED_WIRE,
bf.TWIST_RATE,
bf.TYPE_CODE,
bf.UNIT,
bf.WEIGHT,
bf.WIRE_COLOR,
bf.WIRE_CSA,
bf.WIRE_DESCRIPTION,
bf.WIRE_FROM,
bf.WIRE_FROM_CAVITY,
bf.WIRE_MATERIAL_CODE,
bf.WIRE_TO,
bf.WIRE_TO_CAVITY,
bf.WIRE_USAGE
)
VALUES
(
hibernate_sequence.nextval,
bft.GMT_CREATED,
bft.GMT_MODIFIED,
bft.CIRCUIT_NO,
bft.COMPOSITE_NAME,
bft.COMPOSITEPN,
bft.COMPOSITE_VERSION,
bft.COST,
bft.DER_DESIGN_LEVEL,
bft.DER_DESIGN_NAME,
bft.DER_DESIGN_VERSION,
bft.DER_HARNESSPN,
bft.FUNCTION_CODE,
bft.INSTANCE_NAME,
bft.MC_TYPE_CODE,
bft.MULTICORE_NAME,
bft.OPTION_CODE,
bft.PARTPN,
bft.PROJECT_NAME,
bft.QUANTITY,
bft.RELATED_CAVITY,
bft.RELATED_CONN,
bft.RELATED_WIRE,
bft.TWIST_RATE,
bft.TYPE_CODE,
bft.UNIT,
bft.WEIGHT,
bft.WIRE_COLOR,
bft.WIRE_CSA,
bft.WIRE_DESCRIPTION,
bft.WIRE_FROM,
bft.WIRE_FROM_CAVITY,
bft.WIRE_MATERIAL_CODE,
bft.WIRE_TO,
bft.WIRE_TO_CAVITY,
bft.WIRE_USAGE)