Product Structure Replication Query

Replicate Product Structure

NOTE: Modify to fit the data.

Example: plant 20 based on plant 12

INSERT INTO artprstr (
  SESSION_NO,
  TRANS_NO,
  SEQUENCE_CODE,
  ASSY_PRODUCT_CODE,
  COMP_PRODUCT_CODE,
  QTY_ASSEMBLY,
  IMPORTED_FLAG,
  MEMO,
  LAST_CHANGE_DATE,
  LAST_CHANGE_USER,
  ACTIVE_FLAG)
Select
  0,
  GEN_ID(COFX_GEN,1),
  SEQUENCE_CODE,
  substr(ASSY_PRODUCT_CODE,1,strlen(ASSY_PRODUCT_CODE)-2)||'20',
  substr(COMP_PRODUCT_CODE,1,strlen(COMP_PRODUCT_CODE)-2)||'20',
  QTY_ASSEMBLY,
  IMPORTED_FLAG,
  MEMO,
  '10/01/02',
  'HIT',
  ACTIVE_FLAG
FROM artprSTR
  WHERE substr(ASSY_PRODUCT_CODE,strlen(ASSY_PRODUCT_CODE)-1,strlen(ASSY_PRODUCT_CODE)) = '12';