求救，在线等待.....

Question

报错如下：select a.INTERVENTION_FACT_KY,
substr(a.Srvc_Delivery_Method_Dim_Ky,-3,3),
b.PRODUCT_ID,
b.PRODUCT_HIER_ITEM_DN,
c.PRODUCT_LINE_CD,
c.PRODUCT_LINE_NM,
nvl(c.PRODUCT_LINE_CD,'OT'),
nvl(c.PRODUCT_LINE_CD,'UNKNOW'),
'proc_b1',
sysdate
from 
Test_source.INTERVENTION_F as a join 
Test_source.PRODUCT_HIER_D as b on
Test_source.INTERVENTION_F.REPORTING_PRODUCT_NUMBER_ID = 
Test_source.PRODUCT_HIER_D.PRODUCT_ID join
Test_source.ESG_PRODUCT_LINE as c on
Test_source.ESG_PRODUCT_LINE.RAS_PRODUCT_LINE_CD = 
Test_source.PRODUCT_HIER_D.PRODUCT_HIER_LEVEL_02_CD
where Test_source.INTERVENTION_F.LOGICAL_DELETE_FG ='N'; ORA-00933: SQL command not properly ended  怎么回事；源表字段
create table ESG_PRODUCT_LINE
(
  PRODUCT_LINE_CD     VARCHAR2(2 CHAR) not null,
  PRODUCT_LINE_NM     VARCHAR2(50 CHAR),
  RAS_PRODUCT_LINE_CD VARCHAR2(3 CHAR),
  REPORTING_FG        VARCHAR2(1 CHAR),
  INSERT_TS           DATE not null,
  INSERT_USER_NM      VARCHAR2(96 CHAR) not null,
  UPDATE_TS           DATE,
  UPDATE_USER_NM      VARCHAR2(96 CHAR)
)create table INTERVENTION_F
(
  INTERVENTION_FACT_KY           NUMBER(38) not null,
  SRVC_DELIVERY_METHOD_DIM_KY    NUMBER(38) not null,
  ACTUAL_LABOR_HOURS_QT          NUMBER(9,2),
  ACTUAL_LABOR_COST_USD_AM       NUMBER(15,4),
  BILLED_LABOR_COST_USD_AM       NUMBER(15,4),
  BILLED_TRAVEL_COST_USD_AM      NUMBER(15,4),
  ACTUAL_MISC_COST_USD_AM        NUMBER(15,4),
  BILLED_MISC_COST_USD_AM        NUMBER(15,4),
  ACTUAL_PART_CT                 NUMBER(5),
  ACTUAL_PART_COST_USD_AM        NUMBER(15,4),
  BILLED_PART_COST_USD_AM        NUMBER(15,4),
  INTERVENTION_CT                NUMBER(5),
  INSERT_USER_NM                 VARCHAR2(96 CHAR) not null,
  INSERT_TS                      DATE not null,
  UPDATE_USER_NM                 VARCHAR2(96 CHAR),
  UPDATE_TS                      DATE,
  E2E_EVENT_DIM_KY               NUMBER(38) not null,
  INTERVENTION_START_DT_DIM_KY   NUMBER(38) not null,
  INTERVENTION_FINISH_DT_DIM_KY  NUMBER(38) not null,
  ORIG_LOG_DT_DIM_KY             NUMBER(38) not null,
  SCHED_FIX_DT_DIM_KY            NUMBER(38) not null,
  ACCTG_DT_DIM_KY                NUMBER(38) not null,
  ENTERPRISE_ACCTG_DT_DIM_KY     NUMBER(38) not null,
  CODE_DIM_KY                    NUMBER(38) not null,
  FLAG_DIM_KY                    NUMBER(38) not null,
  BILLED_PL_PRODUCT_HIER_HDIM_KY NUMBER(38) not null,
  SRVC_PROVIDER_HDIM_KY          NUMBER(38) not null,
  WARR_STATUS_DIM_KY             NUMBER(38) not null,
  SOURCE_SYSTEM_DIM_KY           NUMBER(38) not null,
  REPAIR_CLASS_KY                NUMBER(38),
  RAS_PRODUCT_DIM_KY             NUMBER(38),
  SRVC_EVENT_FACT_KY             NUMBER(38),
  PROD_REF_ID                    NUMBER(38),
  REPORTING_PRODUCT_NUMBER_ID    VARCHAR2(50 CHAR),
  ACTUAL_TRAVEL_COST_USD_AM      NUMBER(15,4),
  ACTUAL_TRAVEL_HOURS_QT         NUMBER(9,2),
  BILLED_PL_PRODUCT_HIER_DIM_KY  NUMBER(38),
  EVENT_KY                       NUMBER(38),
  INTERVENTION_RPT_DT_DIM_KY     NUMBER(38) not null,
  LATEST_MATERIAL_INSERT_TS      DATE,
  LOGICAL_DELETE_FG              CHAR(1 CHAR),
  LOGICAL_DELETE_TS              DATE,
  LOGICAL_DELETE_USER_NM         VARCHAR2(32 CHAR),
  PRODUCT_HIER_DIM_KY            NUMBER(38),
  PRODUCT_HIER_HDIM_KY           NUMBER(38),
  PRODUCT_PURCH_DT_DIM_KY        NUMBER(38),
  PRODUCT_SERIAL_NUMBER_ID       VARCHAR2(90 CHAR),
  ACTUAL_OVERTIME_COST_USD_AM    NUMBER(15,4),
  SRVC_LOCATION_CTRY_GEO_HDIM_KY NUMBER(38),
  SRVC_NOTE_DIM_KY               NUMBER(38),
  SRVC_PROVIDER_DIM_KY           NUMBER(38),
  SUPPORT_CASE_FACT_KY           NUMBER(38),
  CUST_CONTACT_DIM_KY            NUMBER(38),
  UPDATE_NOT_PROCESSEED_FG       CHAR(1 CHAR),
  REPAIR_SITE_OFFICE_CODE_KY     NUMBER(38),
  REPAIR_SITE_ENTITY_CODE_KY     NUMBER(38),
  DESTINATION_OFFICE_CODE_KY     NUMBER(38),
  DESTINATION_ENTITY_CODE_KY     NUMBER(38),
  RESPONSIBLE_OFFICE_CODE_KY     NUMBER(38),
  RESPONSIBLE_ENTITY_CODE_KY     NUMBER(38),
  SUPPORT_OFFICE_CODE_KY         NUMBER(38),
  SUPPORT_ENTITY_CODE_KY         NUMBER(38),
  SRVC_DELIVERY_TYPE_DIM_KY      NUMBER(38)
)
create table PRODUCT_HIER_D
(
  PRODUCT_HIER_DIM_KY          NUMBER(38) not null,
  SOURCE_KY                    NUMBER(38) not null,
  PRODUCT_ID                   VARCHAR2(18 CHAR),
  PARENT_PRODUCT_ID            VARCHAR2(18 CHAR),
  PRODUCT_HIER_ITEM_NM         VARCHAR2(40 CHAR),
  PRODUCT_HIER_ITEM_DN         VARCHAR2(40 CHAR),
  PRODUCT_TYPE_CD              VARCHAR2(2 CHAR),
  PRODUCT_TYPE_NM              VARCHAR2(15 CHAR),
  PRODUCT_HIER_LEVEL_CD        VARCHAR2(18 CHAR),
  PRODUCT_HIER_LEVEL_NR        VARCHAR2(1 CHAR),
  PRODUCT_HIER_LEVEL_NM        VARCHAR2(18 CHAR),
  PRODUCT_HIER_LEVEL_00_CD     VARCHAR2(18 CHAR),
  PRODUCT_HIER_LEVEL_00_NM     VARCHAR2(20 CHAR),
  PRODUCT_HIER_LEVEL_00_DN     VARCHAR2(40 CHAR),
  PRODUCT_HIER_LEVEL_01_CD     VARCHAR2(18 CHAR),
  PRODUCT_HIER_LEVEL_01_NM     VARCHAR2(20 CHAR),
  PRODUCT_HIER_LEVEL_01_DN     VARCHAR2(40 CHAR),
  PRODUCT_HIER_LEVEL_02_CD     VARCHAR2(18 CHAR),
  PRODUCT_HIER_LEVEL_02_NM     VARCHAR2(20 CHAR),
  PRODUCT_HIER_LEVEL_02_DN     VARCHAR2(40 CHAR),
  PRODUCT_HIER_LEVEL_03_CD     VARCHAR2(18 CHAR),
  PRODUCT_HIER_LEVEL_03_NM     VARCHAR2(20 CHAR),
  PRODUCT_HIER_LEVEL_03_DN     VARCHAR2(40 CHAR),
  PRODUCT_HIER_LEVEL_04_CD     VARCHAR2(18 CHAR),
  PRODUCT_HIER_LEVEL_04_NM     VARCHAR2(20 CHAR),
  PRODUCT_HIER_LEVEL_04_DN     VARCHAR2(40 CHAR),
  PRODUCT_HIER_LEVEL_05_CD     VARCHAR2(18 CHAR),
  PRODUCT_HIER_LEVEL_05_NM     VARCHAR2(20 CHAR),
  PRODUCT_HIER_LEVEL_05_DN     VARCHAR2(40 CHAR),
  PRODUCT_HIER_LEVEL_06_CD     VARCHAR2(18 CHAR),
  PRODUCT_HIER_LEVEL_06_NM     VARCHAR2(20 CHAR),
  PRODUCT_HIER_LEVEL_06_DN     VARCHAR2(40 CHAR),
  PRODUCT_HIER_LEVEL_07_CD     VARCHAR2(18 CHAR),
  PRODUCT_HIER_LEVEL_07_NM     VARCHAR2(20 CHAR),
  PRODUCT_HIER_LEVEL_07_DN     VARCHAR2(40 CHAR),
  PRODUCT_HIER_LEVEL_08_CD     VARCHAR2(20 CHAR),
  PRODUCT_HIER_LEVEL_08_NM     VARCHAR2(20 CHAR),
  PRODUCT_HIER_LEVEL_08_DN     VARCHAR2(40 CHAR),
  PRODUCT_HIER_ODM_CD          VARCHAR2(3 CHAR),
  PRODUCT_HIER_PRODUCT_CATG_NM VARCHAR2(20 CHAR),
  PART_NUMBER_FORMAT_CD        VARCHAR2(2 CHAR),
  SRC_NM                       VARCHAR2(16 CHAR),
  HPS_SRC_NM                   VARCHAR2(16 CHAR) not null,
  INSERT_USER_NM               VARCHAR2(96 CHAR) not null,
  INSERT_TS                    DATE not null,
  UPDATE_USER_NM               VARCHAR2(96 CHAR),
  UPDATE_TS                    DATE
)
目标表：
create table BILLED_PL_CODE_R
(
INTERVENTION_KY NUMBER(38) not null,
SRVC_DELIVERY_DIM_KY NUMBER(38),
PRD_ID VARCHAR2(18 CHAR),
PRD_HIER_ITEM_DN VARCHAR2(40 CHAR),
PRD_LINE_CD VARCHAR2(40 CHAR),
PRD_LINE_NM VARCHAR2(40 CHAR),
  PL_ACTUAL      VARCHAR2(6 CHAR) not null,
  PL_USED        VARCHAR2(21 CHAR),
  INSERT_USER_NM VARCHAR2(288 CHAR) default USER not null,
  INSERT_TS      DATE default SYSDATE not null
)

Answer 1

SELECT a.intervention_fact_ky, SUBSTR (a.srvc_delivery_method_dim_ky, -3, 3),
       b.product_id, b.product_hier_item_dn, c.product_line_cd,
       c.product_line_nm, NVL (c.product_line_cd, 'OT'),
       NVL (c.product_line_cd, 'UNKNOW'), 'proc_b1', SYSDATE
  FROM test_source.intervention_f a JOIN test_source.product_hier_d b ON a.reporting_product_number_id = b.product_id
       JOIN test_source.esg_product_line c ON c.ras_product_line_cd = b.product_hier_level_02_cd
 WHERE test_source.intervention_f.logical_delete_fg = 'N';