SELECT /*+ ALL_ROWS */ 
T65.CONFLICT_ID,
T65.LAST_UPD,
T65.CREATED,
T65.LAST_UPD_BY,
T65.CREATED_BY,
T65.MODIFICATION_NUM,
T65.ROW_ID,
T65.ROW_ID,
T65.CREATED_BY,
T65.CREATED,
T55.NUM_DAY_DUR,
T4.TRDIN_EXPIRE_DAYS,
T18.NAME,
T65.PR_DEPT_OU_ID,
T18.INTEGRATION_ID,
T33.VAL,
T18.LOC,
T18.MAIN_EMAIL_ADDR,
T18.OU_NUM,
T41.NAME,
T18.CURR_PRI_LST_ID,
T18.PR_BL_ADDR_ID,
T18.PR_BL_PER_ID,
T18.PR_SHIP_ADDR_ID,
T18.PR_SHIP_PER_ID,
T65.CONSUMER_OPTY_FLG,
T12.DECISION_DT,
T65.PR_BU_DNRM_FLG,
T65.PR_BU_MANL_FLG,
T65.PR_BU_SYS_FLG,
T55.BL_ACCNT_ID,
T55.BL_CON_ID,
T65.CHANNEL_TYPE_CD,
T55.COMMENTS,
T47.FST_NAME,
T47.LAST_NAME,
T47.MID_NAME,
T47.WORK_PH_NUM,
T65.X_CURR_RO_FLG,
T65.CURCY_CD,
T65.CUST_ACCNT_ID,
T12.PROJ_STAT_CD,
T65.CLOSED_FLG,
T65.DESC_TEXT,
T55.EVT_TEMPLATE_ID,
T65.PGROUP_PUBLIC_FLG,
T55.GROUP_TYPE_CD,
T55.DEPARTURE_DT,
T55.ARRIVAL_DT,
T65.TEMPLATE_FLG,
T32.STATUS_INBND_CD,
T17.X_ABBO_CONNECTION_COMM,
T17.X_ABBO_MONTH_COMM,
T23.ROW_ID,
T17.X_ABBO_PACK_SET,
T11.X_CLIENT_TYPE,
T18.X_FATCA_GIIN,
T27.X_BIK,
T65.X_BALANCE,
T65.X_CATEGORY,
T17.X_CHANGE_EOKB_STAGE_DT,
T13.VAL,
T20.VAL,
T65.X_SMS_SEND_FLG,
T5.X_CLIENT_TYPE,
T17.X_EXT_COMMENT,
T17.ATTRIB_06,
T17.ATTRIB_06,
T17.X_CARD_CONT_NUM,
T17.X_DB_EMPL_CMNT,
T17.X_DB_RESOLUTION_FLG,
T17.X_DB_RESOLTN_NEED_FLG,
T65.X_DEPOSIT_AGR_NUM_BPM,
T17.X_DEPOSIT_ASSET,
T17.X_DEPOSIT_TYPE,
T17.X_DEPOSIT_PER_PAYMENT_ASSET,
T60.X_BIK,
T17.X_DEPOSIT_PER_PAY_BANK_ID,
T17.X_DEPOSIT_REFUND_BANK_ID,
T17.X_DEPOSIT_TRANS_PER_SAME_FLG,
T17.X_TRANS_DEP_PER_OTHER_BANK_FLG,
T17.X_TRANS_DEP_TO_OTHER_BANK_FLG,
T17.ATTRIB_06,
T17.X_ACCNT_SPECIFCTN,
T17.X_EOKB_ACCNT_TYPE,
T17.X_EOKB_AGREE_NUM,
T17.X_EOKB_CREATED_ORG_ID,
T17.X_EOKB_DBS_AGREE_NUM,
T17.X_EOKB_INFO_WINDOW,
T65.X_LAST_SLAES_STAGE,
T17.ATTRIB_03,
T29.ORDER_BY,
T17.X_EOKB_RENEWAL_TYPE,
T17.X_EOKB_PR_SIGNER,
T17.X_EOKB_SPECIAL_CONDS,
T17.X_EOKB_STAGE,
T21.ORDER_BY,
T17.X_EOKB_TASK_CREATED_FLG,
T17.X_EQUATION_ID,
T11.ATTRIB_47,
T5.ATTRIB_47,
T65.X_HEAD_CONTACT_FLG,
T65.X_INDIVIDUAL_CONDITIONS,
T11.X_KPP,
T17.X_MAIL_NOTIF,
T17.X_MODERATOR_CMNT,
T17.X_MODER_NEED_FLG,
T17.X_CONDITION_TYPE,
T17.X_END_NFO_DATE,
T17.ATTRIB_02,
T17.X_START_NFO_DATE,
T54.INTEGRATION_ID,
T43.FST_NAME,
T17.X_OBDB_EMPL_ID,
T43.LAST_NAME,
T43.MID_NAME,
T17.X_OCOS_EMPL_CMNT,
T19.FST_NAME,
T19.LAST_NAME,
T19.MID_NAME,
T17.ATTRIB_26,
T17.ATTRIB_12,
T11.X_OGRN_NUM,
T10.FST_NAME,
T10.LAST_NAME,
T10.MID_NAME,
T65.X_OP_ID,
T17.X_OPERATOR_CMNT,
T17.PKBO_ACCNT_FLG,
T17.PKBO_FLG,
T18.X_PAR_ROW_ID,
T30.X_CLIENT_TYPE,
T17.PARTNER_ID,
T65.X_PAYMENT_ACCOUNT,
T17.JET_PERIOD_CODE,
T65.X_PROD_PERIOD_PROC_PAYMENT,
T65.X_POSSIBLE_EARLY_EXENPTION,
T65.X_POSSIBLE_EXEMPTION,
T65.X_POSSIBLE_REPLENISH,
T8.INTEGRATION_ID,
T62.X_CUR_WRK_SHFT_ID,
T44.NAME,
T65.X_PROCENT_RATE,
T65.X_PROD_AMOUNT,
T65.X_PROD_DATE_COMPLETION,
T65.X_PROD_DATE_POST,
T65.X_PROD_ID,
T34.X_ATTRIB_61_ID,
T7.NAME,
T65.X_PROD_PROLONGATION,
T65.X_PROD_TERM,
T17.X_PROLONGATION,
T65.X_RRS_CONTACT_EMAIL,
T65.X_RRS_CONTACT_FST_NAME,
T65.X_RRS_CONTACT_LAST_NAME,
T65.X_RRS_CONTACT_MID_NAME,
T65.X_RRS_CONTACT_PHONE,
T17.X_READONLY_FLG,
T11.ATTRIB_10,
T17.ATTRIB_47,
T17.ATTRIB_40,
T17.X_SMS_NOTIF,
T17.X_SELLER_EMPL_ID,
T1.LOGIN,
T17.X_TRN_ACC_NUM,
T17.X_ATTRIB_48,
T17.X_UP_EMPL_CMNT,
T38.FST_NAME,
T17.X_UP_EMPL_ID,
T38.LAST_NAME,
T38.MID_NAME,
T17.X_UP_RESOLUTION_FLG,
T17.X_UP_RESOLTN_NEED_FLG,
T65.X_URGENT_FLG,
T17.X_VERIFY_EMPL_CMNT,
T17.X_VERIFY_EMPL_ID,
T18.ROW_ID,
T65.PR_CON_ID,
T65.NAME,
T65.NEW_LOAN_FLG,
T55.OPTY_MARKET_CD,
T28.STAGE_STATUS_CD,
T55.OPTY_SEGMENT_CD,
T32.STATUS_CD,
T65.APPL_OWNER_TYPE_CD,
T65.PAR_OPTY_ID,
T26.NAME,
T2.ATTRIB_03,
T26.X_SITE_ID,
T24.PAR_POSTN_ID,
T26.PROJ_PRPTY_ID,
T65.ALIAS_NAME,
T65.PR_OU_INDUST_ID,
T65.PR_OU_ADDR_ID,
T65.PR_REP_DNRM_FLG,
T65.PR_REP_MANL_FLG,
T65.PR_REP_SYS_FLG,
T65.PR_CMPT_OU_ID,
T22.COUNTRY,
T24.PR_EMP_ID,
T65.PR_OPTYORG_ID,
T65.PR_OPTYPRD_ID,
T65.BU_ID,
T65.PR_PRTNR_ID,
T65.PR_POSTN_ID,
T65.SUM_REVN_AMT,
T65.SUM_CLASS_CD,
T65.SUM_EFFECTIVE_DT,
T65.SUM_COMMIT_FLG,
T65.SUM_COST_AMT,
T65.SUM_DOWNSIDE_AMT,
T65.SUM_REVN_ITEM_ID,
T65.SUM_MARGIN_AMT,
T65.SUM_TYPE_CD,
T65.SUM_UPSIDE_AMT,
T65.SUM_WIN_PROB,
T45.LOGIN,
T65.PR_SRC_ID,
T22.STATE,
T65.PR_TERR_ID,
T65.PROG_NAME,
T65.PROJ_PRPTY_ID,
T65.REASON_WON_LOST_CD,
T55.REL_TYPE_CD,
T42.OWN_INST_ID,
T42.INTEGRATION_ID,
T28.PHASE_CD,
T57.NAME,
T65.SALES_METHOD_ID,
T28.NAME,
T65.STG_START_DT,
T65.CURR_STG_ID,
T28.STG_ORDER,
T55.STATUS_UPD_DT,
T65.SECURE_FLG,
T65.STATUS_CD,
T12.SUBMITTED_DT,
T18.TAX_IDEN_NUM,
T65.OPTY_CD,
T12.USAGE,
T17.X_SCORING_ID,
T52.RESULT,
T31.NAME,
T49.PR_HELD_POSTN_ID,
T65.X_DEP_MATRIX_ID,
T16.PROD_ID,
T3.NAME,
T50.VAL,
T56.VAL,
T17.X_OPTY_SB_CHECK_SMS_SEND_FLG,
T17.X_RO_FLG,
T17.X_OPEN_RS_FLG,
T17.X_RS_NUM,
T17.X_MARKET_PLACE,
T17.X_CC_PAR_ORS_OPTY_ID,
T17.X_OPEN_ACC_METHOD,
T17.X_REFUSAL_XML_FLG,
T17.X_PR_MARKET_STOCK,
T17.X_PACKAGE_CATEGORY,
T17.X_PACKAGE_NAME,
T17.X_PACKAGE_ID,
T17.X_IN_PACKAGE_FLG,
T17.X_PACKAGE_STATUS,
T17.X_FINAL_PERCENT_RATE,
T17.X_FREE_SERV_FLG,
T17.X_PRDCT_PACKAGE_NAME,
T65.BU_ID,
T53.PR_EMP_ID,
T58.FCST_CLS_DT,
T58.FCST_REVN_CURCY_CD,
T9.POSTN_TYPE_CD,
T58.ROW_STATUS,
T46.LOGIN,
T35.ROW_ID,
T25.EFFECTIVE_DT,
T25.COMMIT_FLG,
T25.COST_AMT,
T25.DOWNSIDE_AMT,
T25.MARGIN_AMT,
T25.WIN_PROB,
T25.REVN_AMT,
T25.ACCNT_ID,
T25.CLASS_CD,
T25.REVN_AMT_CURCY_CD,
T25.QTY,
T25.CRDT_POSTN_ID,
T25.TYPE_CD,
T25.UPSIDE_AMT,
T37.ROW_ID,
T40.NAME,
T40.NAME,
T63.PROD_ID,
T40.NAME,
T40.NAME,
T40.TYPE,
T40.X_SALES_CONFIRM_FLG,
T48.NAME,
T61.ROW_ID,
T51.FST_NAME,
T51.LAST_NAME,
T51.MID_NAME,
T51.WORK_PH_NUM,
T39.SRC_CD,
T6.NAME,
T6.LOC,
T17.ROW_ID,
T17.PAR_ROW_ID,
T17.MODIFICATION_NUM,
T17.CREATED_BY,
T17.LAST_UPD_BY,
T17.CREATED,
T17.LAST_UPD,
T17.CONFLICT_ID,
T17.PAR_ROW_ID,
T55.ROW_ID,
T55.PAR_ROW_ID,
T55.MODIFICATION_NUM,
T55.CREATED_BY,
T55.LAST_UPD_BY,
T55.CREATED,
T55.LAST_UPD,
T55.CONFLICT_ID,
T55.PAR_ROW_ID,
T42.ROW_ID,
T42.PAR_ROW_ID,
T42.MODIFICATION_NUM,
T42.CREATED_BY,
T42.LAST_UPD_BY,
T42.CREATED,
T42.LAST_UPD,
T42.CONFLICT_ID,
T42.PAR_ROW_ID,
T12.ROW_ID,
T12.PAR_ROW_ID,
T12.MODIFICATION_NUM,
T12.CREATED_BY,
T12.LAST_UPD_BY,
T12.CREATED,
T12.LAST_UPD,
T12.CONFLICT_ID,
T12.PAR_ROW_ID,
T58.ROW_ID,
T59.ROW_ID,
T25.ROW_ID,
T15.ROW_ID,
T37.ROW_ID,
T63.ROW_ID,
T48.ROW_ID,
T14.ROW_ID,
T61.ROW_ID,
T39.ROW_ID,
T64.ROW_ID,
T36.ROW_ID
FROM 
S_USER T1,
S_OPTY_X T2,
S_PROD_INT T3,
S_ORG_EXT_ATX T4,
S_ORG_EXT_X T5,
S_ORG_EXT T6,
S_PROD_INT T7,
S_PROD_INT T8,
S_POSTN T9,
S_CONTACT T10,
S_ORG_EXT_X T11,
S_OPTY_DSGN_REG T12,
CX_LIST_OF_VAL T13,
S_OPTY_CON T14,
S_OPTY_ORG T15,
CX_DEP_MATRIX T16,
S_OPTY_X T17,
S_ORG_EXT T18,
S_CONTACT T19,
CX_LIST_OF_VAL T20,
CX_LIST_OF_VAL T21,
S_ADDR_PER T22,
CX_ABBO_PACK T23,
S_POSTN T24,
S_REVN T25,
S_OPTY T26,
S_ORG_EXT_X T27,
S_STG T28,
S_LST_OF_VAL T29,
S_ORG_EXT_X T30,
S_POSTN T31,
S_SYS_KEYMAP T32,
CX_LIST_OF_VAL T33,
S_PROD_INT_X T34,
S_CONTACT T35,
S_PARTY T36,
S_PARTY T37,
S_CONTACT T38,
S_SRC T39,
S_PROD_INT T40,
S_PRI_LST T41,
S_OPTY_SS T42,
S_CONTACT T43,
S_SCHED_CAL T44,
S_USER T45,
S_USER T46,
S_CONTACT T47,
CX_MARKET_STOCK T48,
S_CONTACT T49,
S_LST_OF_VAL T50,
S_CONTACT T51,
CX_SCORING T52,
S_POSTN T53,
S_PROD_INT T54,
S_OPTY_TNTX T55,
S_LST_OF_VAL T56,
S_SALES_METHOD T57,
S_OPTY_POSTN T58,
S_PARTY T59,
S_ORG_EXT_X T60,
S_PARTY T61,
S_ORG_EXT T62,
S_REVN T63,
S_OPTY_BU T64,
S_OPTY T65 
WHERE 
T18.LEGAL_FORM_CD = T33.NAME (+)
AND T33.TYPE (+) = 'JET_LEGAL_FORM'
AND T17.X_ACC_PROD_ID = T8.ROW_ID (+)
AND T17.X_ABBO_PACK_SET = T23.NAME (+)
AND T17.X_EOKB_STAGE = T21.VAL (+)
AND T21.TYPE (+) = 'JET_EOKB_OPTY_STAGE'
AND T17.ATTRIB_03 = T29.VAL (+)
AND T29.TYPE (+) = 'JET_EOKB_OPTY_TYPE'
AND T5.X_CLIENT_SEGMENT = T20.NAME (+)
AND T20.TYPE (+) = 'JET_CLIENT_SEGMENT'
AND T5.X_CLIENT_SEGMENT_209 = T13.NAME (+)
AND T13.TYPE (+) = 'JET_CLIENT_SEGMENT'
AND T17.X_DEPOSIT_PER_PAY_BANK_ID = T60.PAR_ROW_ID (+)
AND T17.X_DEPOSIT_REFUND_BANK_ID = T27.PAR_ROW_ID (+)
AND T17.X_NORESIDENT_ACC_PROD_ID = T54.ROW_ID (+)
AND T17.X_OBDB_EMPL_ID = T43.PAR_ROW_ID (+)
AND T17.X_OCOS_EMPL_ID = T19.PAR_ROW_ID (+)
AND T65.X_OP_ID = T10.PAR_ROW_ID (+)
AND T65.BU_ID = T62.ROW_ID (+)
AND T18.X_PAR_ROW_ID = T30.ROW_ID (+)
AND T65.PR_DEPT_OU_ID = T11.PAR_ROW_ID (+)
AND T65.X_PROD_ID = T7.ROW_ID (+)
AND T17.X_SELLER_EMPL_ID = T49.PAR_ROW_ID (+)
AND T17.X_SELLER_EMPL_ID = T1.PAR_ROW_ID (+)
AND T62.X_CUR_WRK_SHFT_ID = T44.ROW_ID (+)
AND T17.X_UP_EMPL_ID = T38.PAR_ROW_ID (+)
AND T65.CREATED_BY = T47.PAR_ROW_ID (+)
AND T65.ROW_ID = T32.SIEBEL_SYS_KEY (+)
AND T65.PAR_OPTY_ID = T26.ROW_ID (+)
AND T65.PAR_OPTY_ID = T2.ROW_ID (+)
AND T65.PR_OU_ADDR_ID = T22.ROW_ID (+)
AND T65.PR_DEPT_OU_ID = T18.PAR_ROW_ID (+)
AND T65.BU_ID = T4.PAR_ROW_ID (+)
AND T65.PR_DEPT_OU_ID = T5.ROW_ID (+)
AND T65.PR_POSTN_ID = T24.PAR_ROW_ID (+)
AND T18.CURR_PRI_LST_ID = T41.ROW_ID (+)
AND T65.PR_PROD_ID = T34.ROW_ID (+)
AND T24.PR_EMP_ID = T45.PAR_ROW_ID (+)
AND T65.SALES_METHOD_ID = T57.ROW_ID (+)
AND T65.CURR_STG_ID = T28.ROW_ID (+)
AND T17.X_SCORING_ID = T52.ROW_ID (+)
AND T49.PR_HELD_POSTN_ID = T31.ROW_ID (+)
AND T65.X_DEP_MATRIX_ID = T16.ROW_ID (+)
AND T16.PROD_ID = T3.ROW_ID (+)
AND T65.X_PROD_PERIOD_PROC_PAYMENT = T56.NAME (+)
AND T56.TYPE (+) = 'JET_DEPOSIT_PER_PAY_PERIOD'
AND T17.X_DEPOSIT_TYPE = T50.NAME (+)
AND T50.TYPE (+) = 'JET_EOKB_DEPOSIT_OPTY_TYPE'
AND T65.ROW_ID = T17.PAR_ROW_ID
AND T65.ROW_ID = T55.PAR_ROW_ID (+)
AND T65.ROW_ID = T42.PAR_ROW_ID (+)
AND T65.ROW_ID = T12.PAR_ROW_ID (+)
AND T58.POSITION_ID = '1-7CR8'
AND T65.ROW_ID = T58.OPTY_ID
AND T59.ROW_ID = T58.POSITION_ID
AND T58.POSITION_ID = T9.PAR_ROW_ID (+)
AND T9.PR_EMP_ID = T35.PAR_ROW_ID (+)
AND T59.PAR_PARTY_ID = T53.PAR_ROW_ID (+)
AND T9.PR_EMP_ID = T46.PAR_ROW_ID (+)
AND T65.SUM_REVN_ITEM_ID = T25.ROW_ID (+)
AND T65.PR_PRTNR_ID = T15.OU_ID (+)
AND T65.ROW_ID = T15.OPTY_ID (+)
AND T65.PR_PRTNR_ID = T37.ROW_ID (+)
AND T65.PR_OPTYPRD_ID = T63.ROW_ID (+)
AND T63.PROD_ID = T40.ROW_ID (+)
AND T17.X_PR_MARKET_STOCK = T48.ROW_ID (+)
AND T65.PR_CON_ID = T14.PER_ID (+)
AND T65.ROW_ID = T14.OPTY_ID (+)
AND T65.PR_CON_ID = T61.ROW_ID (+)
AND T65.PR_CON_ID = T51.PAR_ROW_ID (+)
AND T65.PR_SRC_ID = T39.ROW_ID (+)
AND T65.BU_ID = T64.BU_ID (+)
AND T65.ROW_ID = T64.OPTY_ID (+)
AND T64.BU_ID = T36.ROW_ID (+)
AND T64.BU_ID = T6.PAR_ROW_ID (+)
AND ((T17.ATTRIB_03 IS NOT NULL)
AND (T65.X_CATEGORY = 'Account')
AND (T65.CREATED >= TO_DATE('12/31/1979 21:00:00','MM/DD/YYYY HH24:MI:SS')))
AND (T65.TEMPLATE_FLG = 'N') 
ORDER BY T65.CREATED DESC