不知道是因为什么原因，请各位老师帮忙看一下
[code]CREATE TABLE TMP3491E157969911E6AA0FE41F136 AS SELECT * FROM (SELECT ROW_NUMBER() OVER( ORDER BY C.FNUMBER ASC) FIDENTITYID, cl.FNAME FASSETNAME, C.FALTERID, C.FNUMBER FASSETID, CASE WHEN fa.FDEPRMETHOD = '4' THEN wle.FPredictWorkLoad ELSE fa.FLifePeriods END FLIFEPERIODS, CASE WHEN fa.FDEPRMETHOD = '4' THEN b.FDeprWorkLoad ELSE b.FDeprPeriods END FDEPRPERIODS, CASE WHEN ((fa.FDEPRMETHOD = '4' AND (NVL(b.FDeprWorkLoad, 0) > 0)) AND (NVL(FWORKLOADUNITID, 0) <> 0)) THEN (SELECT FPrecision FROM T_BD_UNIT WHERE FUNITID = fa.FWORKLOADUNITID) ELSE 0 END FPRECISION, st_l.fname FASSETSTATUS, stg_l.fname FASSETSTATUSGROUP, ty_l.fname FASSETTYPE, tyg_l.fname FASSETTYPEGROUP, at_l.fname FALTERMODE, C.FNUMBER, cy.FAMOUNTDIGITS, CASE WHEN b.FDEPR = 0 THEN 0 ELSE (b.FDEPRRATE * 100) END FDEPRRATE, b.forgvalp, b.FPERIOD, b.faccumdeprp, (b.forgvalp - b.faccumdeprp) FNETVALUEP, b.FDECPREP, ((b.forgvalp - b.faccumdeprp) - b.fdecprep) FKHSNETVALUEP, b.forgvalinc, b.forgvaldec, b.faccumdeprinc, b.faccumdeprdec, b.fdecpreinc, b.fdecpredec, b.fdepr, b.FCurYearDepr FYEARDEPR, ((b.forgvalp + b.forgvalinc) - b.forgvaldec) FORGVALF, (((b.faccumdeprp + b.faccumdeprinc) - b.faccumdeprdec) + b.fdepr) FDEPRF, ((((((b.forgvalp + b.forgvalinc) - b.forgvaldec) - b.faccumdeprp) - b.faccumdeprinc) + b.faccumdeprdec) - b.fdepr) FNETVALUEF, ((b.fdecprep + b.fdecpreinc) - b.fdecpredec) FDECPREF, (((((((((b.forgvalp + b.forgvalinc) - b.forgvaldec) - b.faccumdeprp) - b.faccumdeprinc) + b.faccumdeprdec) - b.fdepr) - b.fdecprep) - b.fdecpreinc) + b.fdecpredec) FRECOVERAMOUNTF FROM t_Fa_card C INNER JOIN t_fa_balance B ON C.Fassetid = b.fassetid LEFT OUTER JOIN T_FA_ACCTPOLICY PY ON py.FACCTPOLICYID = b.FACCTPOLICYID LEFT OUTER JOIN T_BD_CURRENCY CY ON cy.FCURRENCYID = py.FCURRENCYID LEFT OUTER JOIN t_fa_status ST ON C.fassetstatusid = st.fid LEFT OUTER JOIN t_fa_status_l ST_L ON (st.fid = st_l.fid AND st_l.fLocaleId = 2052) LEFT OUTER JOIN t_fa_statusgroup_l STG_L ON (st.fparentid = stg_l.fid AND stg_l.fLocaleId = 2052) LEFT OUTER JOIN t_Fa_Assettype TY ON C.fassettypeid = ty.fid LEFT OUTER JOIN t_fa_assettype_l TY_L ON (ty.fid = ty_l.fid AND ty_l.fLocaleId = 2052) LEFT OUTER JOIN t_fa_assettypegroup_l TYG_L ON (ty.fgroup = tyg_l.fid AND tyg_l.fLocaleId = 2052) LEFT OUTER JOIN t_fa_altermode_l AT_L ON (C.faltermodeid = at_l.fid AND at_l.fLocaleId = 2052) INNER JOIN (SELECT FAssetID, max(F.FAlterID) FALTERID, F.FACCTPOLICYID FROM T_FA_CARD CC INNER JOIN T_FA_FINANCE F ON cc.FAlterID = F.Falterid WHERE (F.FYearPeriod <= ((2016 * 100) + 8)) GROUP BY FAssetID, F.FACCTPOLICYID) "TEMP" ON ((("TEMP".FAssetID = B.FAssetID AND "TEMP".FAlterID = C.FAlterID) AND "TEMP".FACCTPOLICYID = b.FACCTPOLICYID) AND "TEMP".FACCTPOLICYID = py.FACCTPOLICYID) LEFT OUTER JOIN t_fa_finance FA ON ("TEMP".FalterId = fa.Falterid AND fa.facctpolicyid = "TEMP".facctpolicyid) LEFT OUTER JOIN t_fa_card_l CL ON ("TEMP".FAlterID = cl.FAlterID AND cl.FLocaleID = 2052) LEFT OUTER JOIN T_FA_WorkLoad WL ON ((((wl.FYEAR = b.FYEAR AND wl.FPeriod = b.FPERIOD) AND wl.FOWNERORGID = C.FOwnerOrgID) AND wl.FACCTPOLICYID = fa.FACCTPOLICYID) AND wl.FDOCUMENTSTATUS = 'C') LEFT OUTER JOIN T_FA_WorkLoadEntity WLE ON (wl.FID = wle.FID AND wle.FAssetID = C.FAssetID) WHERE ((((C.FDOCUMENTSTATUS = 'C' AND (C.fassetcurstatus < '5')) AND b.FOwnerOrgID = 100007) AND b.FACCTPOLICYID = 1) AND ((b.Fyear = 2016 AND b.FPeriod = 8) OR (((C.fassetcurstatus = '4' AND b.FisNewRec = 2) AND b.FYear = 2016) AND (b.FPeriod <= 8))))) TABLEB WHERE 1 = 1[/code]
推荐阅读