Analytics Software

Hi

I'm adding new source s_addr_per to w_party_org_d where the source is siebel 8.1.1. I tried run this sql in source database and it is throwing an error ORA-00920: invalid relational operator
00920. 00000 - "invalid relational operator"
*Cause:
*Action:
Error at Line: 115 Column: 9


SELECT S_ORG_EXT.ROW_ID,
S_ORG_EXT.CREATED,
S_ORG_EXT.ACTIVE_FLG,
S_ORG_EXT.INT_ORG_FLG,
S_ORG_EXT.NAME,
S_ORG_EXT.PRTNR_FLG,
S_ORG_EXT.BASE_CURCY_CD,
S_ORG_EXT.CMPT_FLG,
S_ORG_EXT.LOC,
S_ORG_EXT.OU_TYPE_CD,
S_ORG_EXT_X.ATTRIB_01,
S_ORG_EXT_X.ATTRIB_02,
S_ORG_EXT_X.ATTRIB_03,
S_ORG_EXT_X.ATTRIB_08,
S_ORG_EXT_X.ATTRIB_14,
S_ORG_EXT_X.ATTRIB_15,
S_ORG_EXT_X.ATTRIB_16,
S_ORG_EXT_X.ATTRIB_27,
S_ORG_EXT.PAR_DIVN_ID,
S_ORG_EXT.PAR_OU_ID,
S_ORG_EXT.CUST_STAT_CD, S_ORG_EXT.DOM_ULT_DUNS_NUM, S_ORG_EXT.DUNS_NUM, S_ORG_EXT.FRGHT_TERMS_CD, S_ORG_EXT.GLBLULT_DUNS_NUM, S_ORG_EXT.HIST_SLS_CURCY_CD, S_ORG_EXT.HIST_SLS_EXCH_DT, S_ORG_EXT.HIST_SLS_VOL,
S_ORG_EXT.MAIN_PH_NUM, S_ORG_EXT.PAR_DUNS_NUM, S_ORG_EXT.PTNTL_SLS_EXCH_DT, S_ORG_EXT.PTNTL_SLS_VOL, S_ORG_EXT.CURR_PRI_LST_ID, S_ORG_EXT.PTNTL_SLS_CURCY_CD, S_ADDR_ORG.ADDR,
S_ADDR_ORG.CITY,
S_ADDR_ORG.COUNTRY,
S_ADDR_ORG.STATE,
S_ADDR_ORG.ZIPCODE,
BU_NAME.NAME BU_NAME,
ORG.NAME ORG_NAME,
ORG.PRTNR_FLG ORG_PRTNR_FLG,
ORG.MAIN_PH_NUM ORG_MAIN_PH_NUM,
ADDRORG.ADDR ORG_ADDR,
ADDRORG.CITY ORG_CITY,
ADDRORG.COUNTRY ORG_COUNTRY,
ADDRORG.STATE ORG_STATE,
ADDRORG.ZIPCODE ORG_ZIPCODE,
S_CONTACT.FST_NAME,
S_CONTACT.LAST_NAME,
S_CONTACT.MID_NAME,
S_BU.CREATED ISORG_CREATED,
S_OU_PRTNR_TYPE.PRTNR_TYPE,
S_OU_PRTNR_TIER.TIER_CD,
S_ASGN_GRP.NAME TERR_NAME,
ORG_MGR.FST_NAME ORG_MGR_FST_NAME,
ORG_MGR.LAST_NAME ORG_MGR_LAST_NAME,
ORG_MGR.MID_NAME ORG_MGR_MID_NAME,
ORG.CHNL_SALES_GROWTH,
ORG.EMP_COUNT,
ORG.EXPERTISE_CD EXPERTISE,
PAR_ORG.NAME PAR_ORG_NAME,
S_INDUST.NAME PR_INDUSTRY,
ORG_COMP.NAME PR_COMPETITOR,
ORG_PTSHP.NAME PTSHP_PRTNR_ACCNT,
S_ORG_PRTNR.PTSHP_END_DT,
S_ORG_PRTNR.PTSHP_RENEWAL_DT,
ORG.PRTNRSHP_START_DT,
S_ORG_PRTNR.PTSHP_FEE_PAID_FLG,
S_ORG_PRTNR.PTSHP_STAGE_CD PTSHP_STAGE,
PRTNR_MKTSEG.NAME PR_PTSHP_MKTSEG,
ORG.PROSPECT_FLG,
S_ORG_EXT_T.REVN ACCNT_REVN,
S_ORG_EXT_T.REVN_DT ACCNT_REVN_DT,
S_ORG_EXT_T.REVN_CURCY_CD ACCNT_REVN_CURCY,
ORG.SALES_EMP_CNT,
ORG.PRTNR_SALES_RANK,
S_ORG_PRTNR.PTSHP_SAT_INDEX,
ORG.SERVICE_EMP_CNT,
TRGT_MKTSEG.NAME PR_ORG_TRGT_MKT,
ORG.CHNL_ANNL_SALES,
S_ORG_EXT.BU_ID,
S_ORG_EXT.PR_POSTN_ID,
S_ORG_EXT.DIVN_TYPE_CD,
S_ORG_EXT.REGION,
S_ORG_EXT.CREATED_BY,
S_ORG_EXT.CREATED,
S_ORG_EXT.LAST_UPD_BY,
S_ORG_EXT.LAST_UPD,
S_ORG_EXT_X.LAST_UPD,
S_BU.LAST_UPD,
S_ADDR_ORG.LAST_UPD,
S_ORG_EXT_T.LAST_UPD,
'0' AS X_CUSTOM
FROM
V_ORG_EXT S_ORG_EXT,
S_ORG_EXT BU_NAME,
S_ORG_EXT ORG,
S_ORG_EXT PAR_ORG,
S_ORG_EXT ORG_COMP,
S_ORG_EXT ORG_PTSHP,
S_ORG_EXT_T,
S_ORG_EXT_X,
S_ADDR_ORG,
S_ADDR_ORG ADDRORG,
S_ASGN_GRP,
S_POSTN,
S_POSTN ORG_POSTN,
S_CONTACT,
S_CONTACT ORG_MGR,
S_OU_PRTNR_TIER,
S_OU_PRTNR_TYPE,
S_BU,
S_PARTY,
S_INDUST,
S_ORG_PRTNR,
S_MKT_SEG PRTNR_MKTSEG,
S_MKT_SEG TRGT_MKTSEG,
S_ADDR_PER
WHERE
V_ORG_EXT S_ORG_EXT
LEFT OUTER JOIN S_ORG_EXT_X ON
S_ORG_EXT.ROW_ID = S_ORG_EXT_X.PAR_ROW_ID
LEFT OUTER JOIN S_ORG_EXT BU_NAME ON
S_ORG_EXT.BU_ID = BU_NAME.ROW_ID
LEFT OUTER JOIN S_BU ON
S_ORG_EXT.ROW_ID = S_BU.ROW_ID
LEFT OUTER JOIN S_ADDR_ORG ON
S_ORG_EXT.PR_ADDR_ID = S_ADDR_ORG.ROW_ID
LEFT OUTER JOIN S_ORG_EXT ORG ON
S_ORG_EXT.PAR_BU_ID = ORG.ROW_ID
LEFT OUTER JOIN S_ADDR_ORG ADDRORG ON
ORG.PR_ADDR_ID = ADDRORG.ROW_ID
LEFT OUTER JOIN S_POSTN ON
S_ORG_EXT.PR_MGR_POSTN_ID = S_POSTN.ROW_ID
LEFT OUTER JOIN S_CONTACT ON
S_POSTN.PR_EMP_ID = S_CONTACT.ROW_ID
LEFT OUTER JOIN S_OU_PRTNR_TIER ON
ORG.PR_PRTNR_TIER_ID = S_OU_PRTNR_TIER.ROW_ID
LEFT OUTER JOIN S_OU_PRTNR_TYPE ON
ORG.PR_PRTNR_TYPE_ID = S_OU_PRTNR_TYPE.ROW_ID
LEFT OUTER JOIN S_ASGN_GRP ON
ORG.PR_TERR_ID = S_ASGN_GRP.ROW_ID
LEFT OUTER JOIN S_POSTN ORG_POSTN ON
ORG.PR_MGR_POSTN_ID = ORG_POSTN.ROW_ID
LEFT OUTER JOIN S_CONTACT ORG_MGR ON
ORG_POSTN.PR_EMP_ID = ORG_MGR.ROW_ID
LEFT OUTER JOIN S_PARTY ON
ORG.PAR_BU_ID = S_PARTY.ROW_ID
LEFT OUTER JOIN S_ORG_EXT PAR_ORG ON
S_PARTY.PAR_PARTY_ID = PAR_ORG.ROW_ID
LEFT OUTER JOIN S_ORG_EXT ORG_COMP ON
ORG.PR_COMPETITOR_ID = ORG_COMP.ROW_ID
LEFT OUTER JOIN S_INDUST ON
ORG.PR_INDUST_ID = S_INDUST.ROW_ID
LEFT OUTER JOIN S_ORG_EXT ORG_PTSHP ON
ORG.PR_PRTNR_OU_ID = ORG_PTSHP.ROW_ID
LEFT OUTER JOIN S_ORG_PRTNR ON
ORG.PAR_ROW_ID = S_ORG_PRTNR.ROW_ID
LEFT OUTER JOIN S_MKT_SEG PRTNR_MKTSEG ON
ORG.PR_PTSHP_MKTSEG_ID = PRTNR_MKTSEG.ROW_ID
LEFT OUTER JOIN S_ORG_EXT_T ON
ORG.PAR_ROW_ID = S_ORG_EXT_T.ROW_ID
LEFT OUTER JOIN S_MKT_SEG TRGT_MKTSEG ON
ORG.PR_ORG_TRGT_MKT_ID = TRGT_MKTSEG.ROW_ID

Appreciate your help.

Thanks
Jay.