Temat: joiny ze starej wersji oracle

Nawiazujac to starego tematu z (+). Mam problem z przepisaniem warunki z WHERE do from. FROM wyglada nastepujaco:

FROM

 VT_DM_PS_DUMP.DIM_CAPTURE_STATUS,

  VT_DM_PS_DUMP.DIM_CANCELLED_ORDER_REASON,

  VT_DM_PS_DUMP.DIM_TP_REGION,

  VT_DM_PS_DUMP.DIM_TP_REGION  ORDER_TP_REGION,

  VT_DM_PS_DUMP.DIM_PROCESS_TYPE,

  VT_DM_PS_DUMP.DIM_PARTNER  ORDER_PARTNER,

  VT_DM_PS_DUMP.DIM_PARTNER_SUBCATEGORY  ORDER_PARTNER_SUBCAT,

  VT_DM_PS_DUMP.DIM_ORDER_BREAKDOWN,

  VT_DM_PS_DUMP.DIM_ORDER_SUBTYPE,

  VT_DM_PS_DUMP.DIM_ORDER_TYPE,

  

  VT_DM_PS_DUMP.FAC_ORDER  oRDER_REL_ORDER

  right outer join

  VT_DM_PS_DUMP.FAC_ORDER_EXT

  on

 ORDER_REL_ORDER.CAPTURE_ID=VT_DM_PS_DUMP.FAC_ORDER_EXT.CORE_JOINED_REL_CAP_ID,

 

 VT_DM_PS_DUMP.DIM_CUSTOMER_SEGMENTATION

 right outer join

 VT_DM_PS_DUMP.DIM_CUSTOMER

 on

  VT_DM_PS_DUMP.DIM_CUSTOMER_SEGMENTATION.CORE_CUST_SEGMENT_KEY=VT_DM_PS_DUMP.DIM_CUSTOMER.CORE_CUST_SEGMENT_KEY,

  

  VT_DM_PS_DUMP.FAC_PROMO_ORDERED  PROMO_ORDERED_ORDER_LINE

 join

  VT_DM_PS_DUMP.DIM_LINE_ACTION  PROMO_LINE_ACTION

  on

   PROMO_ORDERED_ORDER_LINE.CORE_LINE_ACTION_KEY=PROMO_LINE_ACTION.CORE_LINE_ACTION_KEY,

   

   VT_DM_PS_DUMP.DIM_WORKER  ORDER_SALES_WRK

   right outer join

   VT_DM_PS_DUMP.FAC_ORDER

   on

   ORDER_SALES_WRK.PERSON_ID=VT_DM_PS_DUMP.FAC_ORDER.TP_SALES_DTL

   right outer join

   VT_DM_PS_DUMP.FAC_ORDER_LINE

   on

     VT_DM_PS_DUMP.FAC_ORDER.CAPTURE_ID=VT_DM_PS_DUMP.FAC_ORDER_LINE.CAPTURE_ID

      AND   VT_DM_PS_DUMP.FAC_ORDER.CAPTURE_ID=VT_DM_PS_DUMP.FAC_ORDER_LINE.CAPTURE_ID

      

join

   VT_DM_PS_DUMP.DIM_LINE_ACTION

on

VT_DM_PS_DUMP.FAC_ORDER_LINE.CORE_LINE_ACTION_KEY=VT_DM_PS_DUMP.DIM_LINE_ACTION.CORE_LINE_ACTION_KEY,



VT_DM_PS_DUMP.REL_PROMO_ORDERED_PROD 

right outer join



VT_DM_PS_DUMP.FAC_PROMO_ORDERED

on 

    VT_DM_PS_DUMP.REL_PROMO_ORDERED_PROD.TP_PROMO_LN_NBR=VT_DM_PS_DUMP.FAC_PROMO_ORDERED.TP_PROMO_LN_NBR

-- fak promo 3 ostatnie

 join

VT_DM_PS_DUMP.DIM_PROMOTION  DIM_PROMOTION_ORDERED

on

VT_DM_PS_DUMP.FAC_PROMO_ORDERED.RA_OFFER_ID=DIM_PROMOTION_ORDERED.RA_OFFER_ID

jak dodac te 3 joiny. Tabele sa juz wykorzystane, pisze mi ze sa duble albo ze blad skladni. Ktos wie? Trzeba do froma dodac jeszcze te 3 joiny:
left outer join
VT_DM_PS_DUMP.REL_PROMO_ORDERED_PROD.CAPTURE_ID=VT_DM_PS_DUMP.FAC_PROMO_ORDERED.CAPTURE_ID

right outer join
VT_DM_PS_DUMP.REL_PROMO_ORDERED_PROD.CAPTURE_ID=VT_DM_PS_DUMP.FAC_ORDER_LINE.CAPTURE_ID


right outer join
VT_DM_PS_DUMP.REL_PROMO_ORDERED_PROD.LINE_NBR=VT_DM_PS_DUMP.FAC_ORDER_LINE.LINE_NBR