SELECT
T390.FuserId AS FuserId --??ID
,T390.FINVtraceId390 AS FINVtraceId390 --????ID
,T390.FtraceTypeId390 AS FtraceTypeId390 --????
,T391.FASNId391 AS FASNId391 --?????ID
,T391.FcompanyId391 AS FcompanyId391 --??ID
,T046G.Fnumber046 AS FcompanyId391Number --????
,T046G.Fname046 AS FcompanyId391Name --????
,T390.FrelatedINVtraceId390 AS FrelatedINVtraceId390
,T390.FrelatedBillId390 AS FrelatedBillId390 --??????ID
,T390.FrelatedGoodsSerialId390 AS FrelatedGoodsSerialId390 --???????
,T390.FrelatedLPNSerialId390 AS FrelatedLPNSerialId390 --??LPN???
,T784.Flpnflag784 AS Flpnflag784 --lpn????
,T784.FinterfaceNumberA784 AS FinterfaceNumberA784 --????A
,T784.FinterfaceNumberB784 AS FinterfaceNumberB784 --????B
,T784.FinterfaceNumberC784 AS FinterfaceNumberC784 --????C
,T390.FwarehouseId390 AS FwarehouseId390 --??ID
,T046A.Fnumber046 AS FwarehouseId390Number --????
,T046A.Fname046 AS FwarehouseId390Name --????
,T046A.FbarcodeId046 AS FwarehouseId390Barcode --????
,T390.FownId390 AS FownId390 --??ID
,T046B.Fnumber046 AS FownId390Number --????
,T046B.Fname046 AS FownId390Name --????
,T391.FcustomerId391 AS FcustomerId391 --??ID
,T046E.Fnumber046 AS FcustomerId391Number --????
,T046E.Fname046 AS FcustomerId391Name --????
,T391.FASNnumber391 AS FASNnumber391 --???????
,T391.FinterfaceNumberA391 AS FinterfaceNumberA391 --????A
,T391.FinterfaceNumberB391 AS FinterfaceNumberB391 --????B
,T391.FinterfaceNumberC391 AS FinterfaceNumberC391 --????C
,T391.FsysTypeId391 AS FsysTypeId391 --????ID
,T391.FbillTypeId391 AS FbillTypeId391 --?????
,T391.FdeliveryTime391 AS FdeliveryTime391 --????
,T391.FbillTime391 AS FbillTime391 --????
,T391.FbillEmpId391 AS FbillEmpId391 --???ID
,T391.Fenabledflag391 AS fenabledflag391 --????
,T046F.Fnumber046 AS FbillEmpId391Number --?????
,T046F.Fname046 AS FbillEmpId391Name --?????
,T390.FgoodsId390 AS FgoodsId390 --??ID
,T046C.Fnumber046 AS FgoodsId390Number --????
,T046C.Fname046 AS FgoodsId390Name --????
,T046C.FbarcodeId046 AS FgoodsId390Barcode --????
,T046C.FparentId046 AS FgoodsId390ParentId --??ID
,T046D.Fnumber046 AS FgoodsId390ParentIdNumber --????
,T046D.Fname046 AS FgoodsId390ParentIdName --????
,T004.FunitPrice004 AS FunitPrice004 --FunitPrice004
,T004.FQCFlag004 AS FQCFlag004 --????
,T390.FLPN390 AS FLPN390 --???
,T390.FmaxPackNumber390 AS FmaxPackNumber390 -- ????
,T390.FpaletteNumber390 AS FpaletteNumber390 -- ???
,T390.FcaseNumber390 AS FcaseNumber390 -- ??
,T390.FipNumber390 AS FipNumber390 -- ???
,T390.FspNumber390 AS FspNumber390 -- ???
,T390.FminPackNumber390 AS FminPackNumber390 -- ????
,T390.FlocationId390 AS FlocationId390 --??ID
,T046I.Fnumber046 AS FlocationId390Number --????
,T046I.FbarcodeId046 AS FlocationId390Barcode --????
,T046I.Fname046 AS FlocationId390Name --????
,T814.Fhandling814 AS Fhandling814 --????
,T814.fusage814 AS fusage814
,T046I.FparentId046 AS FputSectionId814 --???ID
,T046J.Fnumber046 AS FputSectionId814Number --?????
,T046J.FbarcodeId046 AS FputSectionId814Barcode --?????
,T046J.Fname046 AS FputSectionId814Name --?????
,T390.FoperateQuantity390 AS FoperateQuantity390 --????
,(NVL(T004.FunitPrice004,0) * T390.FoperateQuantity390) AS Famount390 -- ????
,T390.Fcubic390 AS Fcubic390 --??
,T390.FgrossWeight390 AS FgrossWeight390 --??
,T390.FnetWeight390 AS FnetWeight390 --??
,T390.Fstate390 AS Fstate390 --??
,substr(FaddTime390,1,8) AS FaddDate390 --????
,T390.FaddTime390 AS FaddTime390 --????
,T390.FaddEmpId390 AS FaddEmpId390 --???ID
,T390.FaddEmpName390 AS FaddEmpName390 --???
,T390.FeditTime390 AS FeditTime390 --????
,T390.FeditEmpId390 AS FeditEmpId390 --???ID
,T390.FeditEmpName390 AS FeditEmpName390 --???
,T390.Fmemo390 AS Fmemo390 --??
,T390.FSNFrom390 AS FSNFrom390 --SN?
,T390.FSNTO390 AS FSNTO390 --SN?
,T390.LotAttStr390 AS LotAttStr390 --????
,T390.LotAttBillId390 AS LotAttBillId390 --????
,T390.LotAttGoodsSerialId390 AS LotAttGoodsSerialId390 --????
,T390.LotAttBeginData390 AS LotAttBeginData390 --????
,T390.LotAttEndData390 AS LotAttEndData390 --????
,T390.LotAttCustomer390 AS LotAttCustomer390 --????
,T390.LotAttInData390 AS LotAttInData390 --????
,T390.FcancelQuantity390 AS FcancelQuantity390 --????
,T390.FReasonId390 AS FReasonId390 --????
,T390.FReason390 AS FReason390 --????
,T390.FholdFlag390 AS FholdFlag390 --????
FROM WM_INVtrace390 T390
LEFT JOIN BS_basicData046 T046A --??
ON T390.FuserId = T046A.FuserId
AND T390.FwarehouseId390 = T046A.FbasicDataId046
LEFT JOIN BS_basicData046 T046B --??
ON T390.FuserId = T046B.FuserId
AND T390.FownId390 = T046B.FbasicDataId046
LEFT JOIN BS_basicData046 T046C --??
ON T390.FuserId = T046C.FuserId
AND T390.FgoodsId390 = T046C.FbasicDataId046
LEFT JOIN BS_basicData046 T046D --??
ON T046C.FuserId = T046D.FuserId
AND T046C.FparentId046 = T046D.FbasicDataId046
LEFT JOIN BS_location814 T814 --v_locationList
ON T390.FuserId = T814.FuserId
AND T390.FlocationId390 = T814.FlocationId814
LEFT JOIN BS_basicData046 T046I --????
ON T046I.FuserId = T814.FuserId
AND T046I.FbasicDataId046 = T814.FlocationId814
LEFT JOIN BS_basicData046 T046J --????
ON T046I.FuserId = T046J.FuserId
AND T046I.FparentId046 = T046J.FbasicDataId046
LEFT JOIN WM_ASN391 T391
ON T390.FuserId = T391.FuserId
AND T390.FrelatedBillId390 = T391.FASNId391
LEFT JOIN BS_basicData046 T046E --??
ON T391.FuserId = T046E.FuserId
AND T391.FcustomerId391 = T046E.FbasicDataId046
LEFT JOIN BS_basicData046 T046F --???
ON T391.FuserId = T046F.FuserId
AND T391.FbillEmpId391 = T046F.FbasicDataId046
LEFT JOIN BS_BASICDATA046 T046G --??
ON T046G.FuserId = T391.FuserId
AND T046G.FbasicdataId046 = T391.FcompanyId391
LEFT JOIN WM_ASNgoods784 T784 --WM_ASNgoods784
ON T390.FuserId = T784.FuserId
AND T390.FrelatedGoodsSerialId390 = T784.FgoodsSerialId784
LEFT JOIN BS_goods004 T004 --BS_goods004
ON T390.FgoodsId390 = T004.FgoodsId004
这是一个 上架列表视图 解析字段含义 以及每个表的作用 ,字段的作用 ,说明业务逻辑 (前面已经给你几个表了 ,结合说明)