Oracle Database Discussions

Hi,

i am running left outer join query but getting error mesage

ORA-01417: a table may be outer joined to at most one other table ...

SELECT

  S_ORG_EXT.NAME,

  S_ORG_EXT.LOC,

  S_PROD_INT.PROD_TYPE_CD,

  S_PROD_INT.ROW_ID,

  S_PROD_INT.CREATED,

  S_PROD_INT.NAME NAME1,

S_PROD_INT.EFF_END_DT,

S_PROD_INT.EFF_START_DT,

  S_PROD_INT.FRU_FLG,

  S_PROD_INT.ITEM_SIZE,

  S_PROD_INT.LEAD_TM,

  S_PROD_INT.MTBF,

  S_PROD_INT.MTTR,

  S_PROD_INT.PART_NUM,

  S_PROD_INT.PAR_PROD_INT_ID,

  S_PROD_INT.RTRN_DEFECTIVE_FLG,

  S_PROD_INT.SERIALIZED_FLG,

  S_PROD_INT.UOM_CD,

  S_PROD_INT.VENDR_PART_NUM,

  PR_EQUIV.NAME NAME2,

  S_PROD_LN.NAME NAME3,

  S_PROD_INT.SALES_PROD_FLG,

  S_PROD_INT.SALES_SRVC_FLG,

      S_PROD_CFGVER.CURR_VER_FLG,

  S_PROD_INT.CREATED_BY,

  S_PROD_INT.LAST_UPD_BY,

  S_PROD_INT.LAST_UPD,

S_PROD_INT.ORDERABLE_FLG,

S_PROD_INT.CASE_PACK,

S_PROD_INT.EXCH_DT,

S_PROD_INT.GROSS_MGN,

S_PROD_INT.INVENTORY_FLG,

S_PROD_INT.MODEL_YR,

S_PROD_INT.MSRP,

S_PROD_INT.REQ_APPL_FLG,

S_PROD_INT.REQ_REFERRAL_FLG,

S_PROD_INT.RXAVPR_EXCH_DT,

S_PROD_INT.RX_AVG_PRICE,

S_PROD_INT.UNIT_CONV_FACTOR,

S_PROD_INT.BODY_STYLE_CD,

S_PROD_INT.CG_PR_CTLG_CAT_ID,

S_PROD_INT.CURCY_CD,

S_PROD_INT.DETAIL_TYPE_CD,

S_PROD_INT.DOORS_TYPE_CD,

S_PROD_INT.DRIVE_TRAIN_CD,

S_PROD_INT.ENGINE_TYPE_CD,

S_PROD_INT.FUEL_TYPE_CD,

S_PROD_INT.MAKE_CD,

S_PROD_INT.MODEL_CD,

S_PROD_INT.PRICE_TYPE_CD,

S_PROD_INT.PROD_CATG_CD,

S_PROD_INT.PROD_CD,

S_PROD_INT.PROFIT_RANK_CD,

S_PROD_INT.REF_NUMBER_4,

S_PROD_INT.RXAVPR_CURCY_CD,

S_PROD_INT.STATUS_CD,

S_PROD_INT.SUB_TYPE_CD,

S_PROD_INT.TGT_CUST_TYPE_CD,

S_PROD_INT.TRANSMISSION_CD,

S_PROD_INT.TRIM_CD,

S_PROD_INT.TYPE,

S_PROD_INT_ATX.DEALER_INV_PRICE,

'0' AS X_CUSTOM,

S_PROD_INT.COMPENSATABLE_FLG AS X_COMMISSIONABLE_FLG,

CASE WHEN S_PROD_INT.TYPE = 'Promotion' THEN S_PROD_INT.NAME END  AS  X_PROMOTION_NAME,

S_PROD_INT.PROMO_TYPE_CD AS  X_PROMOTION_TYPE,

S_PROD_INT.X_COMMISSIONABLE_CATEGORY,

S_PROD_INT.INVENTORY_FLG  as "X_TANGIBLE_FLG",

S_PROD_INT.X_RENEWABLE as "X_RENEWABLE_FLG",

S_PROD_INT.UNITS_INVENT as "X_UNITS_INVENT"

FROM

  S_PROD_LN,

  V_PROD_INT S_PROD_INT,

  S_PROD_INT PR_EQUIV,

  S_ORG_EXT,

S_PROD_INT_ATX,

S_PROD_CFGVER

WHERE

  --V_PROD_INT S_PROD_INT

  S_PROD_INT.PR_EQUIV_PROD_ID(+)= PR_EQUIV.ROW_ID

AND

S_PROD_INT.VENDR_OU_ID= S_ORG_EXT.ROW_ID

AND

  S_PROD_INT.PR_PROD_LN_ID= S_PROD_LN.ROW_ID

AND

S_PROD_INT.ROW_ID = S_PROD_INT_ATX.PAR_ROW_ID

AND

S_PROD_INT.ROW_ID(+) = S_PROD_CFGVER.PRODUCT_ID AND S_PROD_CFGVER.CURR_VER_FLG = 'Y'

thanks