请问这条语句是什么功能
金蝶云社区-东邪
东邪
0人赞赏了该文章 870次浏览 未经作者许可,禁止转载编辑于2015年10月29日 16:12:48

跟踪sql时发现有条插入临时表的语句,如下:
INSERT /*+ APPEND */
INTO TMP9C65E8297E0B11E5943B6EAE8B3 (FSTOCKORGID,
FOWNERTYPEID,
FOWNERID,
FENTRYTABLE,
FBILLENTRYID,
FORDERBY,
FSTOCKIO,
FIOPRICE,
FIOAMOUNT,
FMATERIALID,
FCURRID,
FAUXPROPID,
FDATE,
FCREATEDATE,
FLOTNO,
FSTOCKID,
FDEPARTMENTID,
FSTOCKLOCID,
FSTOCKSTATUSID,
FKEEPERTYPEID,
FKEEPERID,
FPRODUCEDATE,
FEXPIRYDATE,
FBOMID,
FFORMID,
FBILLNAME,
FBILLID,
FBILLSEQID,
FBILLNO,
FBILLTYPE,
FMTONO,
FBASEQCQTY,
FBASEQCPRICE,
FSECQCQTY,
FBASEINQTY,
FBASEINPRICE,
FSECINQTY,
FBASEOUTQTY,
FBASEOUTPRICE,
FSECOUTQTY)
SELECT TS.FSTOCKORGID FSTOCKORGID,
TSE.FOWNERTYPEID FOWNERTYPEID,
TSE.FOWNERID FOWNERID,
'T_PRD_FEEDMTRLDATA' FENTRYTABLE,
TSE.FENTRYID FBILLENTRYID,
0 FORDERBY,
'O' FSTOCKIO,
NVL (TSE.FPRICE, 0) FIOPRICE,
NVL (TSE.FAMOUNT, 0) FIOAMOUNT,
TSE.FMATERIALID FMATERIALID,
NVL (TS.FCURRID, 0) FCURRID,
NVL (TSE.FAUXPROPID, 0) FAUXPROPID,
TS.FDATE FDATE,
TS.FCREATEDATE FCREATEDATE,
NVL (TSE.FLOT_TEXT, ' ') FLOTNO,
TSE.FSTOCKID FSTOCKID,
TSE.FWORKSHOPID FDEPARTMENTID,
NVL (TSE.FSTOCKLOCID, 0) FSTOCKLOCID,
TSE.FSTOCKSTATUSID FSTOCKSTATUSID,
TSE.FKEEPERTYPEID,
TSE.FKEEPERID,
TSE.FPRODUCEDATE,
TSE.FEXPIRYDATE,
NVL (TSE.FBOMID, 0),
'PRD_FeedMtrl' FFORMID,
'生产补料单' FBILLNAME,
TS.FID FBILLID,
TSE.FSEQ FBILLSEQID,
TS.FBILLNO FBILLNO,
TS.FBILLTYPE FBILLTYPE,
NVL (TSE.FMTONO, ' ') FMTONO,
0 FBASEQCQTY,
0 FBASEQCPRICE,
0 FSECQCQTY,
0 FBASEINQTY,
0 FBASEINPRICE,
0 FSECINQTY,
TSEQ.FBASESTOCKACTUALQTY FBASEOUTQTY,
0 FBASEOUTPRICE,
TSEQ.FSECACTUALQTY FSECOUTQTY
FROM T_PRD_FEEDMTRL TS
INNER JOIN T_PRD_FEEDMTRLDATA TSE ON TSE.FID = TS.FID
INNER JOIN T_PRD_FEEDMTRLDATA_Q TSEQ
ON (TSE.FID = TSEQ.FID AND TSE.FENTRYID = TSEQ.FENTRYID)
INNER JOIN T_BD_MATERIAL TM ON TSE.FMATERIALID = TM.FMATERIALID
WHERE ( ( (TS.FDATE >=
TO_DATE ('2015-06-10 00:00:00',
'YYYY-MM-DD HH24:MI:SS'))
AND (TS.FDATE <=
TO_DATE ('2015-10-29 23:59:59',
'YYYY-MM-DD HH24:MI:SS')))
AND ( ( ( (TS.FSTOCKORGID IN (1))
AND (TS.FDOCUMENTSTATUS IN ('C')))
AND TM.FFORBIDSTATUS = 'A')
AND TS.FCANCELSTATUS = 'A'))

请问各位,这是什么功能生成的语句。