| SQL Id | SQL Text |
|---|
| 091rmkuc80y8u | UPDATE TCVSTHBODY SET TAG=:"SYS_B_0" WHERE TAG<>:"SYS_B_1" AND DATASTATE=:"SYS_B_2" AND ORGCODE=:"SYS_B_3"
|
| 0fv9wbfyra9q0 | Select * from tWebComField where
FaceCode=:"SYS_B_0"
|
| 0x1wtq9khtnja | select * from (select null TABLE_CATALOG, ac.owner TABLE_SCHEMA, ac.table_name TABLE_NAME, acc.column_name COLUMN_NAME, null COLUMN_GUID, null COLUMN_PROPID, acc.position ORDINAL from all_constraints ac, all_cons_columns acc where ac.owner = acc.owner and ac.table_name = acc.table_name and ac.constraint_type = :"SYS_B_0" and ac.constraint_name = acc.constraint_name) DBSCHEMA_PRIMARY_KEYS WHERE TABLE_SCHEMA = :"SYS_B_1" AND TABLE_NAME = :"SYS_B_2" order by :"SYS_B_3", :"SYS_B_4" |
| 12890jjuskc6x |
SELECT BillNo , LrDate , UserId , UserCode , UserName , GenType , OrgCode , (SELECT a.OrgName FROM tOrgManage a WHERE a.OrgCode=tDstRtnHead.OrgCode) AS OrgCode$ , OrgName , InOrgCode , DepID , DepCode , DepName , Orgtype , ThOrgCode , ThOrgName , InThOrgCode , CntID , HtCode , HtName , ThCount , ThTotal , JyMode , JsCode , JzDate , JzrID , JzrCode , JzrName , TjDate , TjrID , TjrCode , TjrName , RptDate , PrnTimes , PrnDate , TimeMark , RefBillNo , YwType , (SELECT a.YwTypeName FROM tSysYwType a WHERE a.YwType=tDstRtnHead.YwType) AS YwType$ , YwIOType , IsZt , Remark , JzType , IsNeedTjWl , DataStatus , CkCode , CkName , RefBillType , (SELECT a.YwTypeName FROM tSysYwType a WHERE a.YwType=tDstRtnHead.RefBillType) AS RefBillType$ , ThReason , (SELECT a.LxName FROM tBasFlContent a WHERE a.LxCode=tDstRtnHead.ThReason AND FLCODE IN (:"SYS_B_00", :"SYS_B_01")) AS ThReason$ , (SELECT a.Address FROM vEtpCustomer a WHERE a.EtpCode=tDstRtnHead.ThOrgCode AND ORGCODE=:"SYS_B_02" ) AS Address , (SELECT a.Linkman FROM vEtpCustomer a WHERE a.EtpCode=tDstRtnHead.ThOrgCode AND ORGCODE=:"SYS_B_03" ) AS Linkman , (SELECT a.LkmTel FROM vEtpCustomer a WHERE a.EtpCode=tDstRtnHead.ThOrgCode AND ORGCODE=:"SYS_B_04" ) AS LinkTel , (SELECT a.EmpName FROM vEtpCustomer a WHERE a.EtpCode=tDstRtnHead.ThOrgCode AND ORGCODE=:"SYS_B_05" ) AS EmpName , WThTotal , XTaxTotal , YwStatus , Pln
ThDate , WlAreaCode , WlAreaName , STotal , ShType , CurrCode , (SELECT a.CurrName FROM tBasCurrency a WHERE a.CurrCode=tDstRtnHead.CurrCode) AS CurrCode$ , ExchangeRate , StlCurrThTotal , IsStdCurr , FhBillNo , PreYsYeTotal , IsRcpXd , OriThCount , ApplyBillNo FROM tDstRtnHead Where LrDate between :"SYS_B_06" and :"SYS_B_07" and ( UserCode Like :"SYS_B_08" ) and OrgCode = :"SYS_B_09" and ((( tDstRtnHead.OrgCode in ( select OrgCode from ( select OrgCode from tOrgManage start with OrgCode = :"SYS_B_10" connect by Prior OrgCode = PreOrgCode ) ) or tDstRtnHead.OrgCode = :"SYS_B_11" ) ))
|
| 13b4q2qjm1k2z | SELECT count(*) FROM tSalPayHead WHERE :"SYS_B_0" = :"SYS_B_1" And OrgCode = :"SYS_B_2" And to_char ( JkDate, :"SYS_B_3" ) Between :"SYS_B_4" And :"SYS_B_5" and ((( tSalPayHead.OrgCode in ( select OrgCode from ( select OrgCode from tOrgManage start with OrgCode = :"SYS_B_6" connect by Prior OrgCode = PreOrgCode ) ) or tSalPayHead.OrgCode = :"SYS_B_7" ) ))
|
| 13x01bd986fqn | SELECT BGNDATE , BGNTIME , BILLNO , ENDDATE , ENDTIME , GENTYPE , GROUPNO , ORGCODE , PLUCODE , PLUID , PLUTYPE , POSCOMUPTYPE , PRI , PRICE , REMARK , UPD1 , UPD2 , UPD3 , UPD4 , UPD5 , UPTDATE , TPROCXZHZXORGGROUP."ROWID" FROM TPROCXZHZXORGGROUP WHERE ORGCODE=:"SYS_B_0" AND UPTDATE >=TO_DATE(:"SYS_B_1", :"SYS_B_2")
|
| 14nxsybunua07 | Select * from tWebComTable where FaceCode=:"SYS_B_0" and ComItemCode=:"SYS_B_1" Order by IsMaster Desc, SerialNo
|
| 18kt46ah9ff8t |
select m.*
from
(select k.orgcode, substrb(k.orgname, :"SYS_B_00", :"SYS_B_01") as orgname, k.billno, k.jkdate, k.sstotal, k.ChkTotal, k.xjtotal as xjtotal, k.hyktotal, k.yhktotal, k.zptotal
, k.gwjtotal, k.ictotal, k.xytotal, k.ydtotal
, k.bhystotal, k.aptotal, k.ygyktotal, k.gjktotal, k.hxttotal
, k.ystotal, (k.chktotal-k.ystotal) as cytotal
from
(select z.orgcode as orgcode, substrb(z.orgname, :"SYS_B_02", :"SYS_B_03") as orgname, z.billno as billno, z.jkdate as jkdate, z.sstotal as sstotal
, z.ChkTotal as ChkTotal, z.ystotal as ystotal
, sum(z.xjtotal) as xjtotal, sum(z.hyktotal) as hyktotal, sum(z.yhktotal) as yhktotal, sum(z.zptotal) as zptotal
, sum(z.gwjtotal) as gwjtotal, sum(z.ictotal) as ictotal, sum(z.xytotal) as xytotal, sum(z.ydtotal) as ydtotal
, sum(z.bhystotal) as bhystotal , sum(z.aptotal) as aptotal, sum(z.ygyktotal) as ygyktotal, sum(z.gjktotal) as gjktotal, sum(z.hxttotal) as hxttotal
from
(select b.orgcode, substrb(h.orgname, :"SYS_B_04", :"SYS_B_05") as orgname, h.billno, h.jkdate, h.sstotal, h.ChkTotal, h.ystotal,
case b.paycode when :"SYS_B_06" then sum(nvl(b.sstotal, :"SYS_B_07")) else :"SYS_B_08" end as xjtotal,
case b.paycode when :"SYS_B_09" then sum(nvl(b.sstotal, :"SYS_B_10")) else :"SYS_B_11" end as hyktotal,
case when b.paycode in (:"SYS_B_12", :"SYS_B_13") then sum(nvl(b.sstotal, :"SYS_B_1
4")) else :"SYS_B_15" end as yhktotal,
case b.paycode when :"SYS_B_16" then sum(nvl(b.sstotal, :"SYS_B_17")) else :"SYS_B_18" end as zptotal,
case b.paycode when :"SYS_B_19" then sum(nvl(b.sstotal, :"SYS_B_20")) else :"SYS_B_21" end as gwjtotal,
case b.paycode when :"SYS_B_22" then sum(nvl(b.sstotal, :"SYS_B_23")) else :"SYS_B_24" end as ictotal,
case b.paycode when :"SYS_B_25" then sum(nvl(b.sstotal, :"SYS_B_26")) else :"SYS_B_27" end as xytotal,
case b.paycode when :"SYS_B_28" then sum(nvl(b.sstotal, :"SYS_B_29")) else :"SYS_B_30" end as ydtotal,
case b.paycode when :"SYS_B_31" then sum(nvl(b.sstotal, :"SYS_B_32")) else :"SYS_B_33" end as bhystotal,
case b.paycode when :"SYS_B_34" then sum(nvl(b.sstotal, :"SYS_B_35")) else :"SYS_B_36" end as ygyktotal,
case b.paycode when :"SYS_B_37" then sum(nvl(b.sstotal, :"SYS_B_38")) else :"SYS_B_39" end as gjktotal,
case b.paycode when :"SYS_B_40" then sum(nvl(b.sstotal, :"SYS_B_41")) else :"SYS_B_42" end as hxttotal,
case b.paycode when :"SYS_B_43" then sum(nvl(b.sstotal, :"SYS_B_44")) else :"SYS_B_45" end as aptotal
from tsalpayhead h, tsalpaybody b
where h.billno=b.billno
and h.orgcode = b.orgcode
and b.orgcode
like :"SYS_B_46"
and to_char(h.jkdate, :"SYS_B_47") between :"SYS_B_48" and :"SYS_B_49"
group by b.orgcode, substrb(h.orgname, :"SYS_B_50", :"SYS_B_51"), h.jkdate, h.sstotal, b.paycode, h.billno, h.ChkTotal, h.ystotal) z
group by z.orgcode, substrb(z.orgname, :"SYS_B_52", :"SYS_B_53"), z.jkdate, z.sstotal, z.billno, z.ChkTotal, z.ystotal) k union all select distinct o.orgcode as orgcode, substrb(o.orgname, :"SYS_B_54", :"SYS_B_55") as orgname, :"SYS_B_56" as billno,
to_date(:"SYS_B_57", :"SYS_B_58") as jkdate
, :"SYS_B_59" as sstotal
, :"SYS_B_60" as ChkTotal
, :"SYS_B_61" as xjtotal
, :"SYS_B_62" as hyktotal
, :"SYS_B_63" as yhktotal
, :"SYS_B_64" as zptotal
, :"SYS_B_65" as gwjtotal
, :"SYS_B_66" as ictotal
, :"SYS_B_67" as xytotal
, :"SYS_B_68" as ydtotal
, :"SYS_B_69" as bhystotal
, :"SYS_B_70" as aptotal
, :"SYS_B_71" as ygyktotal
, :"SYS_B_72" as gjktotal
, :"SYS_B_73" as hxttotal
, :"SYS_B_74" as ystotal
, :"SYS_B_75" as cytotal
from torgmanage o, tsalpayhead h, tsalpaybody b
where h.billno=b.billno
and o.orgcode not in (select distinct b.orgcode from tsalpaybody b, tsalpayhead h where h.billno = b.billno and h.orgcode = b.orgc
ode and h.jkdate = :"SYS_B_76" )
and o.orgtype=:"SYS_B_77" and o.isenable = :"SYS_B_78"
and to_date(:"SYS_B_79", :"SYS_B_80") not in (select h.jkdate from tsalpayhead)) m where m.orgcode like :"SYS_B_81" and m.orgcode not like :"SYS_B_82" and length(m.orgcode)= :"SYS_B_83" and m.orgcode not in (:"SYS_B_84") order by orgcode, billno, jkdate |
| 1ms7q0c0jgbrs | SELECT tEtpCustomer.*, tEtpCustomer."ROWID" FROM tEtpCustomer WHERE EtpCode=:"SYS_B_0" AND (OrgCode = :"SYS_B_1" and EtpAttribute = :"SYS_B_2" and IsActive = :"SYS_B_3" and YwStatus = :"SYS_B_4")
|
| 1ujjr5f7n32g1 | select *
from sys.all_tables
where owner = :object_owner
and table_name = :object_name
|
| 1ymbcdwxfh127 | select /*+rule*/ constraint_name from sys.all_constraints
where owner = :object_owner
and table_name = :object_name
and constraint_type = :"SYS_B_0"
and constraint_name not like :"SYS_B_1"
|
| 24c6vrzw1ug5g | select B.*
from tWebComItem B
|
| 25af3drxuaqgb | SELECT BGNTIME , BILLNO , CARDLXCODE , ENDTIME , ISENABLED , LMTCOUNT , LMTTYPE , ORGCODE , PLUCODE , PLUID , POSCOMUPTYPE , PRI , UPTDATE , YHPRICE , YHRATE , YHTYPE , VPROCXHYPLU."ROWID" FROM VPROCXHYPLU WHERE UPTDATE >= TO_DATE(:"SYS_B_0", :"SYS_B_1") AND ORGCODE=:"SYS_B_2"
|
| 26twhcjg0m4rd | Select ComType from twebcomlogin where OrgCode=:"SYS_B_0"
|
| 2fcm9wnan24zb | select distinct BillNo, OrgCode from tCvsAltPluYwStatus where BillNo=:"SYS_B_0" |
| 2gw4dt8v4gyjn | SELECT BGNDATE, BGNTIME, BILLNO, CXTYPE, DATATYPE, ENDDATE, ENDTIME, ISENABLED, ISHYZSZ, LMTCOUNT, ORGCODE, PLUCODE, PLUID, POSCOMUPTYPE, PRI, UPTDATE, YHPRICE, YHRATE, YHTYPE FROM VPROCXPTPLU WHERE UPTDATE >= TO_DATE(:"SYS_B_0", :"SYS_B_1") AND ORGCODE=:"SYS_B_2"
|
| 2q9d3yh417u9h | UPDATE TCVSZDPSBODY SET TAG=:"SYS_B_0" WHERE TAG<>:"SYS_B_1" AND DATASTATE=:"SYS_B_2" AND ORGCODE=:"SYS_B_3"
|
| 2uwmmnqdwxw57 | Select tWebComTable.*, tWebComTable."ROWID" from tWebComTable where FaceCode=:"SYS_B_0" and ComItemCode=:"SYS_B_1" Order by IsMaster Desc, SerialNo
|
| 31c0jyutrrpt3 | select /*+rule*/ col.*, com.Comments
from sys.all_tab_columns col,
sys.all_col_comments com
where col.owner = :"SYS_B_0"
and col.table_name = :"SYS_B_1"
and com.Owner (+) = :"SYS_B_2"
and com.Table_Name (+) = :"SYS_B_3"
and com.Column_Name (+) = col.Column_Name
order by col.column_id
|
| 333b3ds7py72s | select /*+rule*/ * from sys.all_ind_columns
where index_owner = :index_owner
and index_name = :index_name
order by column_position
|
| 33xx311rurxus |
SELECT A.LBBM, A.MC, A.BM, A.XFL, A.XSSL, A.HSXSJE, A.WSXSJE, A.HSML, A.WSML, NVL(PSK.KCSL, 0) AS PS_KCSL, NVL(PSK.HSKCJE, 0) AS PS_HSKCSJE, NVL(PSK.WSKCJE, 0) AS PS_WSKCSJE, NVL(THC.KCSL, 0) AS THC_KCSL, NVL(THC.HSKCJE, 0) AS THC_HSKCJE, NVL(THC.WSKCJE, 0) THC_WSKCJE, NVL(FDK.KCSL, 0) AS FD_KCSL, NVL(FDK.HSKCJE, 0) AS FD_HSKCJE, NVL(FDK.WSKCJE, 0) AS FD_WSKCJE, NVL(WLDCL.KCSL, 0) AS WLDCL_KCSL, NVL(WLDCL.HSKCJE, 0) AS WLDCL_HSKCJE, NVL(WLDCL.WSKCJE, 0) AS WLDCL_WSKCJE, NVL(PSK.HSKCJE, 0) + NVL(FDK.HSKCJE, 0) + NVL(WLDCL.HSKCJE, 0) AS ALL_HSKCJE FROM (SELECT T.PLUCODE AS LBBM, S.PLUNAME AS MC, T.DEPCODE, '[' || TO_CHAR(T.DEPCODE) || ']' || T.DEPNAME AS BM, '[' || TO_CHAR(D.CLSCODE) || ']' || D.CLSNAME AS XFL, S.PLUID, SUM(T.XSCOUNT) AS XSSL, SUM(T.SSTOTAL) AS HSXSJE, 0 AS WSXSJE, 0 AS HSML, 0 AS WSML FROM (SELECT * FROM TSALSALEPLU WHERE NOT SALENO LIKE '%XSYW%' AND TRANTYPE <> '5') T, TCATCATEGORY D, TSKUPLU S WHERE S.CLSID = D.CLSID AND T.PLUID = S.PLUID AND NOT T.ORGCODE IN ('WDF', 'WDF00', 'WDFWL') AND TO_CHAR(T.XSDATE, 'yyyy-mm-dd') = TO_CHAR(SYSDATE, 'yyyy-mm-dd') GROUP BY T.PLUCODE, S.PLUNAME, T.DEPCODE, T.DEPNAME, D.CLSCODE, D.CLSNAME, S.PLUID) A, (SELECT K.PLUID, SUM(K.KCCOUNT) - NVL((SELECT SUM(LOCKCOUNT) AS LOCKCOUNT FROM TSTKLSKCLOCK WHERE CKCODE = '01' AND K.PLUID = PLUID AND ORGCODE = 'WDF00' GROUP BY PLUID), 0) AS KCSL, SUM(K.HCOST) AS HSKCJE, SUM(K.WCOST) AS WSKCJE FROM TSTKLSKC K WHERE K.ORG
CODE = 'WDF00' AND K.CKCODE = '01' GROUP BY K.PLUID) PSK, (SELECT K.PLUID, SUM(K.KCCOUNT) - NVL((SELECT SUM(LOCKCOUNT) AS LOCKCOUNT FROM TSTKLSKCLOCK WHERE CKCODE = '02' AND K.PLUID = PLUID AND ORGCODE = 'WDF00' GROUP BY PLUID), 0) AS KCSL, SUM(K.HCOST) AS HSKCJE, SUM(K.WCOST) AS WSKCJE FROM TSTKLSKC K WHERE K.ORGCODE = 'WDF00' AND K.CKCODE = '02' GROUP BY K.PLUID) THC, (SELECT K.PLUID, SUM(K.KCCOUNT) - NVL((SELECT SUM(LOCKCOUNT) AS LOCKCOUNT FROM TSTKLSKCLOCK WHERE CKCODE = '02' AND K.PLUID = PLUID AND ORGCODE = 'WDF00' GROUP BY PLUID), 0) AS KCSL, SUM(K.HCOST) AS HSKCJE, SUM(K.WCOST) AS WSKCJE FROM TSTKLSKC K WHERE K.ORGCODE = 'WDF00' AND K.CKCODE = '03' GROUP BY K.PLUID) WLDCL, (SELECT A.PLUID, SUM(A.KCCOUNT) - NVL((SELECT SUM(LOCKCOUNT) AS LOCKCOUNT FROM TSTKLSKCLOCK WHERE CKCODE = '02' AND A.PLUID = PLUID GROUP BY PLUID), 0) AS KCSL, SUM(A.HCOST) AS HSKCJE, SUM(A.WCOST) AS WSKCJE FROM TSTKLSKC A WHERE LENGTH(A.ORGCODE) = 4 GROUP BY A.PLUID) FDK WHERE A.PLUID = PSK.PLUID(+) AND A.PLUID = THC.PLUID(+) AND A.PLUID = FDK.PLUID(+) AND A.PLUID = WLDCL.PLUID(+) AND EXISTS (SELECT 1 FROM TUSRRIGHTORG WHERE USERID=:B1 AND A.DEPCODE LIKE DEPCODE||'%') |
| 36jr6h7n934ns | select /*+rule*/ column_name from sys.all_cons_columns
where owner = :owner
and table_name = :table_name
and constraint_name = :constraint_name
order by position
|
| 37wtqxny634kw |
select * from (select null table_catalog, decode (o1.owner, :"SYS_B_00", NULL, o1.owner) table_schema, o1.object_name table_name, decode(o1.owner, :"SYS_B_01", decode(o1.object_type, :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", o1.object_type), :"SYS_B_06", decode(o1.object_type, :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", o1.object_type), o1.object_type) table_type, null table_guid, null description, null table_propid, null date_created, null date_modified from all_objects o1 where ((o1.object_type = :"SYS_B_11" and o1.generated != :"SYS_B_12") or o1.object_type = :"SYS_B_13") union select null table_catalog, decode (o2.owner, :"SYS_B_14", NULL, o2.owner) table_schema, o2.object_name table_name, o2.object_type table_type, null table_guid, null description, null table_propid, null date_created, null date_modified from all_objects o2, all_objects o3, all_synonyms s where o2.object_type = :"SYS_B_15" and ((o3.object_type = :"SYS_B_16" and o3.generated != :"SYS_B_17") or o3.object_type = :"SYS_B_18") and o2.owner = s.owner and o2.object_name = s.synonym_name and s.table_owner = o3.owner and s.table_name = o3.object_name) tables where table_schema = :"SYS_B_19" and table_name = :"SYS_B_20" order by :"SYS_B_21", :"SYS_B_2
2", :"SYS_B_23" |
| 3grgq85sbbn5q | select /*+rule*/ tablespace_name, to_char(pct_free) pct_free, to_char(pct_used) pct_used,
to_char(ini_trans) ini_trans, to_char(max_trans) max_trans,
to_char(initial_extent) initial_extent, to_char(next_extent) next_extent,
to_char(pct_increase) pct_increase,
to_char(min_extents) min_extents, to_char(max_extents) max_extents,
cluster_name
from sys.all_tables
where owner = :object_owner
and table_name = :object_name
|
| 3scwabj9qsmkj | select B.*, B."ROWID" from tWebComItem B where B.FaceCode=:"SYS_B_0" and B.ComItemCode=:"SYS_B_1"
|
| 41mn654sa4h53 |
SELECT tSkuPlu.*, tSkuPlu."ROWID" FROM tSkuPlu WHERE (PluCode=:"SYS_B_00" Or CargoNo=:"SYS_B_01" Or BarCode=:"SYS_B_02" or MaterialCode=:"SYS_B_03") and IsActive=:"SYS_B_04" AND (IsActive = :"SYS_B_05" and Exists ( Select PluID from tSkuPluEx Where OrgCode = :"SYS_B_06" and IsTh = :"SYS_B_07" and PluID = tSkuPlu.PluID and ((( :"SYS_B_08" = :"SYS_B_09" and CgMode = :"SYS_B_10" ) or ( :"SYS_B_11" = :"SYS_B_12" and CgMode = :"SYS_B_13" and :"SYS_B_14" = nvl (( select optionvalue from tSysOption where orgcode = :"SYS_B_15" and section = :"SYS_B_16" and sysoption = :"SYS_B_17" ) , :"SYS_B_18" )) ) or ( :"SYS_B_19" = :"SYS_B_20" and CgMode in ( :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" ) ) or ( :"SYS_B_25" = :"SYS_B_26" and CgMode in ( :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" ) ) or :"SYS_B_30" = :"SYS_B_31" ) ) and Exists ( Select Kc.OrgCode From tStkLsKc Kc, tStkPc Pc Where Kc.OrgCode = :"SYS_B_32" and Kc.CkCode = :"SYS_B_33" and Kc.PluID = tSkuPlu.PluID and Kc.PcNo = Pc.PcNo and (( :"SYS_B_34" <> :"SYS_B_35" and Pc.CntID = :"SYS_B_36" ) or ( :"SYS_B_37" = :"SYS_B_3
8" and Nvl ( Pc.CntID, :"SYS_B_39" ) = :"SYS_B_40" ))) and ( Exists ( select PluId from tCntPlu where PluID = tSkuPlu.PluID and Cntid = :"SYS_B_41" and :"SYS_B_42" <> :"SYS_B_43" and IsTh = :"SYS_B_44" ) or not Exists ( select PluId from tCntPlu where PluID = tSkuPlu.PluID and Cntid = :"SYS_B_45" and :"SYS_B_46" <> :"SYS_B_47" )))
|
| 42n46ckrhbpb2 | SELECT Billno , Serialno , PluID , PluCode , PluName , BarCode , ExPluCode , ExPluName , Spec , Unit , PriceType , JdRate , PsPrice , PsTotal , PackUnit , PackQty , PackCount , SglCount , PsCount , PluType , DepID , DepCode , (SELECT a.DepName FROM tOrgDept a WHERE a.DepID=tDstPsBody.DepID ) AS DepName , (SELECT a.DotDecimal FROM tSkuPlu a WHERE a.PluID=tDstPsBody.PluID ) AS R_DotDecimal , Remark , DataSource , Tag , WPsPrice , WPsTotal , XTaxRate , XTaxTotal , PlnCount , SdCount , KwCode , Price , STotal , CargoNo , MaterialCode , CxYhTotal , CxMsg , YhBillNo , YhSerialno , RefSerialno , StlCurrPsPrice , StlCurrPsTotal , ChgType , (SELECT a.LxName FROM tBasFlContent a WHERE a.LxCode=tDstPsBody.ChgType AND FLCODE=:"SYS_B_0" AND LXCODE<:"SYS_B_1") AS ChgType$ , LsPrice , ZkRate , PsPlnBillNo , PsPlnSerialNo , ClsID , ClsCode , ClsName , ScDate , PzCode FROM tDstPsBody Where BillNo = :"SYS_B_2" ORDER BY KwCode, ClsCode, Pluname, Unit, PluCode
|
| 43yqd5khtcuth | Select * from tWebComField where
FaceCode=:"SYS_B_0"
And ComItemCode=:"SYS_B_1"
And upper(SendTable)=:"SYS_B_2"
|
| 44hgw9cwssu0r | INSERT INTO TPLUINCREASE_TMP (ORGCODE, DEPID, PLUID) SELECT ORGCODE, DEPID, PLUID FROM TSKUPLUEX A WHERE NOT EXISTS (SELECT * FROM TSKUGTPLU B WHERE A.ORGCODE = B.ORGCODE AND A.DEPID = B.DEPID AND A.PLUID = B.PLUID ) |
| 458dta71shpu4 |
SELECT Billno , OrgCode , OrgName , InOrgCode , DepID , DepCode , (SELECT RTRIM(LTRIM(a.DepName)) FROM tOrgDept a WHERE a.DepID=tDstPsHead.DepID ) AS DepCode$ , (SELECT a.DepName FROM tOrgDept a WHERE a.DepID=tDstPsHead.DepID ) AS DepName , CkCode , CkName , Orgtype , ShOrgCode , ShOrgName , InShOrgCode , LinkTel , QrType , PsType , CntID , HtCode , HtName , JyMode , JsCode , LrDate , UserId , UserCode , UserName , JzDate , JzrID , JzrCode , JzrName , TjDate , TjrID , TjrCode , TjrName , HzDate , RptDate , PrnTimes , PrnDate , TimeMark , YwType , (SELECT a.YwTypeName FROM tSysYwType a WHERE a.YwType=tDstPsHead.YwType) AS YwType$ , YwIOType , GenType , Remark , JzType , RefBillNo , IsNeedTjWl , DataStatus , YwStatus , CKMode , PsCount , PsTotal , RefBillType , (SELECT a.YwTypeName FROM tSysYwType a WHERE a.YwType=tDstPsHead.RefBillType) AS RefBillType$ , (SELECT a.PsArea FROM vEtpCustomer a WHERE a.EtpCode=tDstPsHead.ShOrgCode AND ORGCODE=:"SYS_B_00" ) AS PsArea , DataSource , (SELECT a.Address FROM vEtpCustomer a WHERE a.EtpCode=tDstPsHead.ShOrgCode AND ORGCODE=:"SYS_B_01" ) AS Address , (SELECT a.Linkman FROM vEtpCustomer a WHERE a.EtpCode=tDstPsHead.ShOrgCode AND ORGCODE=:"SYS_B_02" ) AS LinkMan , (SELECT a.HCost FROM tStkKcJzHead a WHERE a.YwBillNo=tDstPsHead.Billno AND YWTYPE=:"SYS_B_03" ) AS HCost , (SELECT a.WCost FROM tStkKcJzHead a WHERE a.YwBillNo=tDstPsHead.Billno AN
D YWTYPE=:"SYS_B_04" ) AS WCost , (SELECT a.EmpName FROM vEtpCustomer a WHERE a.EtpCode=tDstPsHead.ShOrgCode AND ORGCODE=:"SYS_B_05" ) AS EmpName , WPsTotal , XTaxTotal , PlnCount , SdCount , WlAreaCode , IsUrgent , PlnShDate , WlAreaName , STotal , ShType , PsPath , PathSerialNo , FhBillNo , ShEtpCode , ShEtpName , CxYhTotal , CurrCode , (SELECT a.CurrName FROM tBasCurrency a WHERE a.CurrCode=tDstPsHead.CurrCode) AS CurrCode$ , ExchangeRate , StlCurrPsTotal , IsStdCurr , PreYsYeTotal , PieceCount , IsRcpXd FROM tDstPsHead Where LrDate between :"SYS_B_06" and :"SYS_B_07" and ( ShOrgCode Like :"SYS_B_08" ) and ( YwType <> :"SYS_B_09" or PsType <> :"SYS_B_10" ) and ((( tDstPsHead.OrgCode in ( select OrgCode from ( select OrgCode from tOrgManage start with OrgCode = :"SYS_B_11" connect by Prior OrgCode = PreOrgCode ) ) or tDstPsHead.OrgCode = :"SYS_B_12" ) or tDstPsHead.ShOrgCode in ( select OrgCode from ( select OrgCode from tOrgManage start with OrgCode = :"SYS_B_13" connect by Prior OrgCode = PreOrgCode ))))
|
| 4fnsr6wg9h81y | SELECT BARCODE , BILLNO , CARGONO , DATASTATE , DBCOUNT , DBORGCODE , DBORGNAME , DEPCODE , DEPID , DEPNAME , JZDATE , LRDATE , ORGCODE , PLUCODE , PLUID , PLUNAME , REMARK , SERIALNO , SPEC , UNIT , USERCODE , USERID , YWTYPE , TCVSDBBODY."ROWID" FROM TCVSDBBODY WHERE TAG<>:"SYS_B_0" AND YWTYPE=:"SYS_B_1" AND DATASTATE=:"SYS_B_2" AND ORGCODE=:"SYS_B_3"
|
| 4wzc12hz2tx0m | select B.*
from tWebComItem B
where B.FaceCode=:"SYS_B_0" and B.ComItemCode=:"SYS_B_1"
|
| 59ybxu7r1g03f | UPDATE TCVSZDPSBODY SET TAG=:"SYS_B_0" WHERE TAG=:"SYS_B_1" AND TAG<>:"SYS_B_2" AND DATASTATE=:"SYS_B_3" AND ORGCODE=:"SYS_B_4"
|
| 5pk50wtr6uqvw |
INSERT INTO TORDCGJYKCDATA(INORGCODE, PLUID, DEPID, KCCOUNT, LOCKCOUNT, FRZCOUNT, KYCOUNT, ZTCOUNT, AVG1STCOUNT, MINCOUNT, MAXCOUNT, GENDATE, CKCODE) SELECT A.ORGCODE AS INORGCODE, A.PLUID, A.DEPID, NVL(C.KCCOUNT, 0) AS KCCOUNT, NVL(C.LOCKCOUNT, 0) AS LOCKCOUNT, NVL(C.FRZCOUNT, 0) AS FRZCOUNT, NVL(C.KCCOUNT, 0)-NVL(C.LOCKCOUNT, 0)-NVL(C.FRZCOUNT, 0) AS KYCOUNT, NVL((SELECT SUM(ZTCOUNT) FROM TORDTMPPLUZTKC_TMP WHERE HORGCODE=:B2 AND PLUID=A.PLUID AND CKCODE=:B1 ), 0) AS ZTCOUNT, NVL((SELECT SUM(AVGPSCOUNT) FROM TDSTCKDAYAVGPSCOUNT WHERE PLUID=A.PLUID AND CKCODE=:B1 AND ORGCODE=:B4 ), 0) AS AVG1STCOUNT, A.MINCOUNT, A.MAXCOUNT, :B3 AS GENDATE, :B1 FROM TSKUPLUEX A, (SELECT PLUID, SUM(KCCOUNT) AS KCCOUNT, (SELECT NVL(SUM(LOCKCOUNT), 0) FROM TSTKLSKCLOCK WHERE ORGCODE=:B2 AND PLUID=KC.PLUID AND CKCODE=:B1 AND EXISTS(SELECT * FROM TSTKSTORE WHERE ORGCODE=:B2 AND CKCODE=TSTKLSKCLOCK.CKCODE AND KCTYPE<='2') ) AS LOCKCOUNT, 0.00 AS FRZCOUNT FROM TSTKLSKC KC WHERE ORGCODE=:B2 AND CKCODE=:B1 AND EXISTS (SELECT * FROM TSTKSTORE WHERE ORGCODE=:B2 AND CKCODE=KC.CKCODE AND KCTYPE<='2') GROUP BY PLUID ) C, TSKUPLU D WHERE A.ORGCODE=:B2 AND A.PLUID=C.PLUID AND A.PLUID=D.PLUID AND A.ISJH='1' AND D.ISACTIVE='1' AND D.ISKC='1' AND EXISTS(SELECT 1 FROM TSKUETPPARAS WHERE ORGCODE=:B2 AND PLUID=A.PLUID)
|
| 5t2jkzcphbn4g | UPDATE TCVSJHBODY SET TAG=:"SYS_B_0" WHERE TAG=:"SYS_B_1" AND TAG<>:"SYS_B_2" AND YWTYPE=:"SYS_B_3" AND ORGCODE=:"SYS_B_4"
|
| 5v8yc3ju2mxj8 | select /*+rule*/ comments from sys.all_tab_comments
where owner = :object_owner
and table_name = :object_name
|
| 5y1uy63a8867r |
SELECT PluCode , BarCode , CargoNo , MaterialCode , tSkuPlu."ROWID" FROM tSkuPlu WHERE (PluCode=:"SYS_B_00" Or CargoNo=:"SYS_B_01" Or BarCode=:"SYS_B_02" or MaterialCode=:"SYS_B_03") and IsActive=:"SYS_B_04" AND (IsActive = :"SYS_B_05" and Exists ( Select PluID from tSkuPluEx Where OrgCode = :"SYS_B_06" and IsTh = :"SYS_B_07" and PluID = tSkuPlu.PluID and ((( :"SYS_B_08" = :"SYS_B_09" and CgMode = :"SYS_B_10" ) or ( :"SYS_B_11" = :"SYS_B_12" and CgMode = :"SYS_B_13" and :"SYS_B_14" = nvl (( select optionvalue from tSysOption where orgcode = :"SYS_B_15" and section = :"SYS_B_16" and sysoption = :"SYS_B_17" ) , :"SYS_B_18" )) ) or ( :"SYS_B_19" = :"SYS_B_20" and CgMode in ( :"SYS_B_21" , :"SYS_B_22" , :"SYS_B_23" , :"SYS_B_24" ) ) or ( :"SYS_B_25" = :"SYS_B_26" and CgMode in ( :"SYS_B_27" , :"SYS_B_28" , :"SYS_B_29" ) ) or :"SYS_B_30" = :"SYS_B_31" ) ) and Exists ( Select Kc.OrgCode From tStkLsKc Kc, tStkPc Pc Where Kc.OrgCode = :"SYS_B_32" and Kc.CkCode = :"SYS_B_33" and Kc.PluID = tSkuPlu.PluID and Kc.PcNo = Pc.PcNo and (( :"SYS_B_34" <> :"SYS_B_35" and Pc.CntID = :"SYS_B_36" ) or ( :
"SYS_B_37" = :"SYS_B_38" and Nvl ( Pc.CntID, :"SYS_B_39" ) = :"SYS_B_40" ))) and ( Exists ( select PluId from tCntPlu where PluID = tSkuPlu.PluID and Cntid = :"SYS_B_41" and :"SYS_B_42" <> :"SYS_B_43" and IsTh = :"SYS_B_44" ) or not Exists ( select PluId from tCntPlu where PluID = tSkuPlu.PluID and Cntid = :"SYS_B_45" and :"SYS_B_46" <> :"SYS_B_47" )))
|
| 5zhu4psa6zx33 | Select IsSelect, OrgCode, EtpCode, R_EtpName, PluID, R_PluCode, R_PluName, R_BarCode, R_Unit, R_Spec, R_CargoNo, R_Produce, R_ClsID, R_ClsCode, R_ClsName, ExPluCode, DepID, R_DepCode, R_DepName, PackUnit, PackQty, PackCount, SglCount, CgCount, YOrdCount, R_KyCount, R_QhStatus, YCgCount, GenDate, R_KcCount, R_LockCount, R_FrzCount, R_ZtCount, R_Avg1stCount, R_KxDays, R_RefXsCount, RgCount, ZnCount, QhclCount, HeCount, R_MinCount, R_MaxCount, R_DotDecimal, R_NewJhDate, R_NewHJPrice, R_NewWJPrice, R_CxBgnDate, R_CxEndDate, CxBhEnd_CxBgnDate, CxBhEnd_CxEndDate, CxBhBgn_CxBgnDate, CxBhBgn_CxEndDate, CxBh_CxBgnDate, CxBh_CxEndDate, Remark, DataSrc, R_DpCount, R_QhCount, R_JhCycle, R_PsCycle, R_AqDays, R_BzDays, R_IsTh, R_zzDays, R_FdKcCount, R_QszXsCount From vOrdCgJyHzSupFpAll A Where OrgCode=:"SYS_B_0" and CkCode=:"SYS_B_1" and R_ClsCode like :"SYS_B_2" and EtpCode=:"SYS_B_3" and Rownum<=:"SYS_B_4"
|
| 6fzqkjh00c8q0 | BEGIN sStk_FollowMeRece(:1, :2, :3, :4, :5, :6); END; |
| 6nbg85zr5d4mk | SELECT HYPRICE , ORGCODE , PLUCODE , PLUID , POSCOMUPTYPE , PRICE , TZDATE , UPTDATE , TPRCPLANADJPLU."ROWID" FROM TPRCPLANADJPLU WHERE UPTDATE >=TO_DATE(:"SYS_B_0", :"SYS_B_1") AND ORGCODE=:"SYS_B_2"
|
| 6xdfuhg84tq0n | SELECT ISTH , ORGCODE , PLUID , POSCOMUPTYPE , UDP1 , UDP2 , UDP3 , UDP4 , UDP5 , UPTDATE , TCVSGTPLUUDP."ROWID" FROM TCVSGTPLUUDP WHERE ORGCODE=:"SYS_B_0" AND UPTDATE >=TO_DATE(:"SYS_B_1", :"SYS_B_2")
|
| 795tq5r6g30kx | BEGIN SORD_CGJYGETKCDATA( :1, :2, :3, :4, :5, :6 ); END; |
| 7r1buqnupp1sm | SELECT IsSelect , BillNo , LrDate , UserID , UserCode , UserName , JzrID , JzrCode , JzrName , RptDate , PrnTimes , PrnDate , TimeMark , YwType , (SELECT a.YwTypeName FROM tSysYwType a WHERE a.YwType=tSalPayHead.YwType) AS YwType$ , OrgCode , OrgName , JkDate , JkType , DataStatus , JzDate , YsTotal , SsTotal , ChkTotal , ChkCount , ChkUserId , ChkUserCode , ChkUserName , ChkDate , IsZf , OriBillNo , ChKZTotal , MdCyTotal , ChKCYTotal FROM tSalPayHead Where :"SYS_B_0" = :"SYS_B_1" And OrgCode = :"SYS_B_2" And to_char ( JkDate, :"SYS_B_3" ) Between :"SYS_B_4" And :"SYS_B_5" and ((( tSalPayHead.OrgCode in ( select OrgCode from ( select OrgCode from tOrgManage start with OrgCode = :"SYS_B_6" connect by Prior OrgCode = PreOrgCode ) ) or tSalPayHead.OrgCode = :"SYS_B_7" ) ))
|
| 7rcsysu9557sv | Select ComType , twebcomlogin."ROWID" from twebcomlogin where OrgCode=:"SYS_B_0"
|
| 7yjqkxv8cstf7 | select distinct BillNo, OrgCode from tCvsThBody where DataState=:"SYS_B_0" and BillNo=:"SYS_B_1" |
| 849gk14t5hav7 | SELECT CARDCODE , CARDID , CARDPWD , CKRCODE , CKRID , CKRNAME , DATASTATUS , ENDDATE , FIELD1 , FIELD2 , FIELD3 , INITDATE , INVALIDDATE , ISALLCLEAR , ISPRESENT , ISRECEDE , ISREPRINT , ISVIEWREPORT , ISVOID , LRDATE , MAXRATE , MAXTOTAL , ORGCODE , ORGNAME , REMARK , USERCODE , USERID , USERNAME , YWSTATUS , TSALRIGHTCARD."ROWID" FROM TSALRIGHTCARD WHERE ORGCODE=:"SYS_B_0"
|
| 8avmdpqt0tapw | select /*+rule*/ * from sys.all_indexes
where table_name = :object_name
and table_owner = :object_owner
order by index_name
|
| 8dsuf8bb6hk60 | BEGIN PSSY_DB.SSTK_LETSGO_ORA( :1, :2, :3, :4, :5, :6, :7, :8 ); END; |
| 9as33rwqkzsxp | SELECT BARCODE , BILLNO , CARGONO , CGBILLNO , CKCODE , DATASTATE , DEPCODE , DEPID , DEPNAME , DHDATE , EXPLUCODE , EXPLUNAME , JHCOUNT , LRDATE , ORGCODE , PLUCODE , PLUID , PLUNAME , REALCOUNT , REMARK , SCDATE , SERIALNO , SPEC , SUPCODE , UNIT , USERCODE , USERID , YWTYPE , TCVSJHBODY."ROWID" FROM TCVSJHBODY WHERE TAG<>:"SYS_B_0" AND YWTYPE=:"SYS_B_1" AND ORGCODE=:"SYS_B_2"
|
| 9j7tuj8mt5pmf | SELECT BARCODE , BILLNO , DATASTATE , EXPLUCODE , EXPLUNAME , FHBGNDATE , FHENDDATE , FHTYPE , FHTYPE , FHTYPENAME , FHTYPENAME , JZDATE , LRDATE , MODIFYTYPE , MODIFYTYPENAME , ORGCODE , PLUCODE , PLUID , PLUNAME , PSCOUNT , REMARK , SERIALNO , SPEC , TAG , UDP1 , UDP2 , UDP3 , UDP4 , UDP5 , UNIT , USERCODE , USERID , USERNAME , TCVSZDPSBODY."ROWID" FROM TCVSZDPSBODY WHERE TAG<>:"SYS_B_0" AND DATASTATE=:"SYS_B_1" AND ORGCODE=:"SYS_B_2"
|
| 9kv6nhp2bbjnt | select /*+rule*/ * from sys.all_constraints
where table_name = :object_name
and owner = :object_owner
and constraint_type in (:"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03")
order by decode(constraint_type, :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10"), constraint_name
|
| 9y4jnhcws3jgc | SELECT IsSelect , BillNo , LrDate , UserID , UserCode , UserName , JzrID , JzrCode , JzrName , RptDate , PrnTimes , PrnDate , TimeMark , YwType , (SELECT a.YwTypeName FROM tSysYwType a WHERE a.YwType=tSalPayHead.YwType) AS YwType$ , OrgCode , OrgName , JkDate , JkType , DataStatus , JzDate , YsTotal , SsTotal , ChkTotal , ChkCount , ChkUserId , ChkUserCode , ChkUserName , ChkDate , IsZf , OriBillNo , ChKZTotal , MdCyTotal , ChKCYTotal FROM tSalPayHead Where (:"SYS_B_0" = :"SYS_B_1" And OrgCode = :"SYS_B_2" And to_char ( JkDate, :"SYS_B_3" ) Between :"SYS_B_4" And :"SYS_B_5" and ((( tSalPayHead.OrgCode in ( select OrgCode from ( select OrgCode from tOrgManage start with OrgCode = :"SYS_B_6" connect by Prior OrgCode = PreOrgCode ) ) or tSalPayHead.OrgCode = :"SYS_B_7" ) ))) and rownum <= :"SYS_B_8"
|
| a1hmw4xxaddsa | UPDATE TCVSDBBODY SET TAG=:"SYS_B_0" WHERE TAG<>:"SYS_B_1" AND YWTYPE=:"SYS_B_2" AND DATASTATE=:"SYS_B_3" AND ORGCODE=:"SYS_B_4"
|
| a4cgmpdmvs5sv | select /*+rule*/ debuginfo
from sys.all_probe_objects po
where po.owner = :"SYS_B_0"
and po.object_name = :"SYS_B_1"
and po.object_type = :"SYS_B_2"
|
| absdr89pb19cy | UPDATE TCVSJHBODY SET TAG=:"SYS_B_0" WHERE TAG<>:"SYS_B_1" AND YWTYPE=:"SYS_B_2" AND ORGCODE=:"SYS_B_3"
|
| aj42bn2u07xxc | UPDATE TCVSDBBODY SET TAG=:"SYS_B_0" WHERE TAG=:"SYS_B_1" AND TAG<>:"SYS_B_2" AND YWTYPE=:"SYS_B_3" AND DATASTATE=:"SYS_B_4" AND ORGCODE=:"SYS_B_5"
|
| ax8tdc572zcny | SELECT count(*) FROM tDstPsBody WHERE BillNo = :"SYS_B_0"
|
| b8cwyu7bufh5b | select /*+rule*/ * from sys.all_tab_partitions
where table_name = :object_name
and table_owner = :object_owner
and trim(composite) in (:"SYS_B_0", :"SYS_B_1")
order by partition_position
|
| bbqp1ywqmvhv2 |
SELECT '['||TO_CHAR(D1.CLSCODE)||']'||D1.CLSNAME AS BM , '['||TO_CHAR(D2.CLSCODE)||']'||D2.CLSNAME AS DL , '['||TO_CHAR(D3.CLSCODE)||']'||D3.CLSNAME AS ZL , '['||TO_CHAR(D.CLSCODE)||']'||D.CLSNAME AS XFL, S.PLUCODE, S.PLUNAME, S.BARCODE, S.SPEC, S.UNIT, CASE UDP10 WHEN '1' THEN 'Õý³£' WHEN '2' THEN '²»Òª¿É·¢' WHEN '3' THEN '²»Òª²»·¢' WHEN '4' THEN 'Ô¤ÌÔÌ' WHEN '5' THEN 'Í£ÊÛÇåÍË' WHEN '6' THEN 'ÌÔÌ' ELSE '䶨Òå' END AS YWSTATUS , NVL(H.HJPRICE, S.HJPRICE) AS HJPRICE, NVL(HX.MINHJPRICE, H.HJPRICE) AS MINHJPRICE , NVL(H.WJPRICE, S.WJPRICE) AS WJPRICE, NVL(F.PRICE, S.PRICE) AS PRICE, NVL(F.HYPRICE, S.HYPRICE) AS HYPRICE, CASE S.UDP1 WHEN '1' THEN '²»ÄÜÍË' WHEN '2'THEN '¹ýÆÚÍË' WHEN '3' THEN 'ÁÙ½ü±£ÖÊÆÚ1/6ÍË' WHEN '4' THEN '³§¼Ò»»»õ' ELSE '䶨Òå' END AS UDP1 , S.UDP2, S.UDP3, S.UDP4, HT.HTNAME AS ETPNAME, S.UDP5, S.UDP6, S.UDP7, S.UDP8, H.JTAXRATE, H.JTAXCALTYPE, S.LRDATE, S.LRUSERCODE, S.LRUSERNAME, F.ISJH, F.ISTH, F.ISPS, F.ISJS, F.ISSALE, F.ISSALETH, F.ISCANPRESENT, H.ISTH, S.PLUMN, S.PLUWEIGHT, S.PLUWIDTH, S.PLUHEIGHT, S.PLUHEIGHT, S.PLULONG, S.CGYNAME, S.PRODUCE, S.PLUID, NVL(SPCZ.PACKQTY, 0) AS ZJXS , NVL(SPFD.PACKQTY, 0) AS ZXFHL , CASE HT.JYMODE WHEN '0' THEN '¾Ïú' WHEN '1' THEN '´úÏú' WHEN '2' THEN 'ÁªÏú' WHEN '3' THEN '×âÁÞ' ELSE 'ÎÞ' END AS JYMODE , CASE HT.JSCODE WHEN '0' THEN '¾Ïú½áËã' WHEN '1' THEN '´úÏú½áËã' WHEN '2' THEN 'ÁªÏú½áËã' WHEN '3' THEN '×â½ð½áËã' ELSE 'ÎÞ' END JSCODE, HT.YQDAYS, HT.ZQDAYS, NVL(FXDS.FXJS, 0) AS FXJS, NVL(YHDS.YHJ
S, 0) AS YHJS, NVL(S.BRANDCODE, 'ÎÞ') AS BRANDCODE, NVL(P.BRANDNAME,
'ÎÞ') AS BRANDNAME, F.AQDAYS FROM (SELECT PLUID, PLUCODE, PLUNAME, PLUENAME, PLUABBRNAME, PLUMN, BARCODE, UNIT, SPEC, PLUWEIGHT, PLUHEIGHT, PLULONG, PLUWIDTH, ISMULPACKET, ORGCODE, ORGNAME, CGYID, CGYCODE, CGYNAME, CARGONO, PRODUCE, GRADE, QUALITY, ISSEASON, SALESEASON, BZDAYS, CASE LENGTH(CLSID) WHEN 11 THEN '8'||SUBSTR(PLUCODE, 0, 4)||'01' +0 ELSE CLSID END CLSID, BRANDCODE, JTAXCALTYPE, WJPRICE, HJPRICE, JTAXRATE, PRICE, XTAXRATE, PROMDECIMAL, PROMFORMULA, DOTDECIMAL, ISWEIGHT, ISCOUTQTY, ISSELFBRAND, ISKC, ISFRESH, ISEXPLUCODE, ISCURRDAY, JHBFBZDAYS, PSBFBZDAYS, ISNEWPLU, ISACTIVE, CXINFO, YWSTATUS, LRDATE, LRUSERID, LRUSERCODE, LRUSERNAME, ZXDATE, ZXUSERID, ZXUSERCODE, ZXUSERNAME, UDP1, UDP2, UDP3, UDP4, UDP5, UDP6, UDP7, UDP8, UDP9, DATASTATUS, HYPRICE, PLUCLS, PLUMODEL, UDP10, UDP11, UDP12, UDP13, UDP14, MATERIALCODE, LRORGCODE, LRORGNAME, DATASRC FROM TSKUPLU ) S, TBASBRAND P, (SELECT * FROM TSKUPLUEX WHERE ORGCODE='WDF00')F, (SELECT X.HTCODE, H.* FROM TCNTCONTRACT X, TCNTPLU H WHERE X.CNTID=H.CNTID ) H, ( SELECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D) D, ( SELECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D ) D1, ( SELECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D) D2, ( SE
L
ECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D ) D3 , (SELECT * FROM TSKUPLUPACKET WHERE ISPUR='1' )SPCZ, ( SELECT * FROM TSKUPLUPACKET WHERE ISDIST='1') SPFD , (SELECT M.PLUID, MIN(M.HJPRICE) AS MINHJPRICE FROM TORDJHHEAD P, TORDJHBODY M WHERE P.BILLNO=M.BILLNO AND P.YWTYPE='0904' GROUP BY M.PLUID) HX, TCNTCONTRACT HT , ( SELECT F.PLUID, COUNT(F.ORGCODE) AS FXJS FROM TSKUPLUEX F WHERE LENGTH(F.ORGCODE)=4 AND F.ISJH='1' GROUP BY F.PLUID ) FXDS, (SELECT PLUID, COUNT(ORGCODE) AS YHJS FROM ( SELECT A.ORGCODE , A.PLUID, SUM(A.KCCOUNT) AS KCSL FROM TSTKLSKC A WHERE LENGTH(A.ORGCODE)= 4 GROUP BY A.ORGCODE , A.PLUID HAVING SUM(A.KCCOUNT)>0 ) N1 GROUP BY PLUID ) YHDS WHERE SUBSTR(S.CLSID, 2, 2)=D1.CLSCODE(+) AND SUBSTR(S.CLSID, 2, 3)=D2.CLSCODE(+) AND SUBSTR(S.CLSID, 2, 4)=D3.CLSCODE(+) AND S.CLSID=D.CLSID(+) AND S.UDP4=HT.HTCODE(+) AND S.PLUID=H.PLUID(+) AND S.UDP4=H.HTCODE(+) AND S.PLUID= F.PLUID(+) AND S.PLUID=HX.PLUID(+) AND S.PLUID=SPCZ.PLUID(+) AND S.PLUID= SPFD.PLUID(+) AND S.PLUID=FXDS.PLUID(+) AND S.PLUID=YHDS.PLUID(+) AND S.BRANDCODE=P.BRANDCODE(+) AND EXISTS (SELECT 1 FROM TUSRRIGHTORG A, ( SELECT CASE LENGTH(D.CLSID) WHEN 11 THEN '8'||D.CLSCODE+0 ELSE D.CLSID END CLSID , D.CLSCODE, D.CLSNAME FROM TCATCATEGORY D) C WHERE A.USERID=:B1 AND C.CLSID = S.CLSID AND C.CLSCODE LIKE A.DEPCODE||'%')
|
| c7s87nurt7yqz | Select IsSelect, OrgCode, EtpCode, R_EtpName, PluID, R_PluCode, R_PluName, R_BarCode, R_Unit, R_Spec, R_CargoNo, R_Produce, R_ClsID, R_ClsCode, R_ClsName, ExPluCode, DepID, R_DepCode, R_DepName, PackUnit, PackQty, PackCount, SglCount, CgCount, YOrdCount, R_KyCount, R_QhStatus, YCgCount, GenDate, R_KcCount, R_LockCount, R_FrzCount, R_ZtCount, R_Avg1stCount, R_KxDays, R_RefXsCount, RgCount, ZnCount, QhclCount, HeCount, R_MinCount, R_MaxCount, R_DotDecimal, R_NewJhDate, R_NewHJPrice, R_NewWJPrice, R_CxBgnDate, R_CxEndDate, CxBhEnd_CxBgnDate, CxBhEnd_CxEndDate, CxBhBgn_CxBgnDate, CxBhBgn_CxEndDate, CxBh_CxBgnDate, CxBh_CxEndDate, Remark, DataSrc, R_DpCount, R_QhCount, R_JhCycle, R_PsCycle, R_AqDays, R_BzDays, R_IsTh, R_zzDays, R_FdKcCount, R_QszXsCount From vOrdCgJyHzSupFpAll A Where OrgCode=:"SYS_B_0" and CkCode=:"SYS_B_1" and EtpCode=:"SYS_B_2" and Rownum<=:"SYS_B_3"
|
| cjq91hg7qh6xd | SELECT ORGCODE , DEPID , ISHYDSC , ISPLDSC , ISXLDSC , ISPTDSC , ISPACKDSC , SPEC , UNIT , BARCODE , PLUMN , UPTDATE , POSCOMUPTYPE , POSCOMCURNO , BRANDCODE , CLSCODE , CLSID , UPTFLAG , ISMINPRICE , ISPRESENT , ISCANPRESENT , ISCANSALETH , ISCANSALE , MAXPRICE , MINPRICE , ISCOUTQTY , ISWEIGHT , PLUTYPE , PROMFORMULA , PROMDECIMAL , XTAXRATE , DOTDECIMAL , PRICE , HYPRICE , ISZEROSALE , ISKCNOW , ISKC , ISCERTIDSC , PLUENAME , DEPCODE , PLUID , PLUCODE , PLUNAME , DEPNAME , PLUABBRNAME , VSKUGTPLU."ROWID" FROM VSKUGTPLU WHERE ORGCODE=:"SYS_B_0" AND UPTDATE >=TO_DATE(:"SYS_B_1", :"SYS_B_2")
|
| cpa7wp2th7tx2 | SELECT BARCODE , BILLNO , CARGONO , CKCODE , DATASTATE , DEPCODE , DEPID , DEPNAME , EXPLUCODE , EXPLUNAME , JZDATE , LRDATE , ORGCODE , PLUCODE , PLUID , PLUNAME , REASON , REMARK , SERIALNO , SPEC , SUPCODE , THCOUNT , TJDATE , UNIT , USERCODE , USERID , YWTYPE , TCVSTHBODY."ROWID" FROM TCVSTHBODY WHERE TAG<>:"SYS_B_0" AND DATASTATE=:"SYS_B_1" AND ORGCODE=:"SYS_B_2"
|
| db78fxqxwxt7r | select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket |
| dtj01urbaanhz | SELECT BARCODE, DEPCODE, DEPID, KCCOUNT, ORGCODE, PLUCODE, PLUID, PLUNAME, PRICE FROM VCVSKCCOUNT WHERE ORGCODE=:"SYS_B_0"
|
| dv5ndc7cf0j3b | select PluId from tOrdThBody where BillNo=:"SYS_B_0" group by PluId |
| dv7t3p1w4pn0f | Select * from tWebComField where
FaceCode=:"SYS_B_0"
And ComItemCode=:"SYS_B_1"
|
| dvsancgv352xs | select /*+rule*/ * from sys.all_tab_privs
where table_schema = :object_owner
and table_name = :object_name
order by grantee
|
| dz3m6y0660j5n | select distinct BillNo, OrgCode from tCvsDbBody where BillNo=:"SYS_B_0" and DataState=:"SYS_B_1" |
| f3s2n2j49nnjp | select /*+rule*/ * from sys.all_queue_tables
where queue_table = :object_name
and owner = :object_owner
|
| fbajdpr0kavrf | BEGIN SCOM_FOLLOWMERECE( :1, :2, :3, :4, :5, :6, :7 ); END; |
| fcgwk3qgp2zsr | UPDATE TCVSTHBODY SET TAG=:"SYS_B_0" WHERE TAG=:"SYS_B_1" AND TAG<>:"SYS_B_2" AND DATASTATE=:"SYS_B_3" AND ORGCODE=:"SYS_B_4"
|
| fcsw30vk481ab | Select tWebComField.*, tWebComField."ROWID" from tWebComField where
FaceCode=:"SYS_B_0"
And ComItemCode=:"SYS_B_1"
And upper(SendTable)=:"SYS_B_2"
|
| fr4uqtgmvgwa0 | INSERT INTO TTMPSKUGTPLU (ORGCODE, DEPID, PLUID, ISKC, ISKCNOW, ISPACKDSC, ISPTDSC, ISXLDSC, ISPLDSC, ISHYDSC, ISCERTIDSC, UPTFLAG, POSCOMUPTYPE, DEPFLAG) SELECT X.ORGCODE, X.DEPID, X.PLUID , '1', '1', '0', '0', '0', '0', '0', '0', '1', '0' , '0' FROM (SELECT A.ORGCODE, A.DEPID, A.PLUID FROM TSKUPLUEX A, TORGMANAGE B, TSTKSTORE E, TPLUINCREASE_TMP C WHERE EXISTS(SELECT D.ORGCODE FROM TSTKLSKC D WHERE A.ORGCODE=D.ORGCODE AND A.DEPID=D.DEPID AND E.CKCODE=D.CKCODE AND A.PLUID=D.PLUID) AND A.ORGCODE=C.ORGCODE AND A.PLUID=C.PLUID AND A.DEPID=C.DEPID AND A.DEPID<>0 AND A.ORGCODE=B.ORGCODE AND B.ISENABLE='1' AND A.ORGCODE=E.ORGCODE AND E.CKTYPE='0' ) X, TSKUPLU Z WHERE X.PLUID=Z.PLUID AND Z.ISACTIVE='1' AND Z.ISKC='1' AND NOT EXISTS(SELECT 1 FROM TTMPSKUGTPLU B WHERE X.PLUID = B.PLUID AND X.DEPID = B.DEPID AND X.ORGCODE = B.ORGCODE) |
| ftkpvbpb4yjny | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN sSys_HsCmp_GtPluForJob; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| gjbjrmkrw4424 | select sysdate , dual."ROWID" from dual |
| gjranjqz0ctha | Select tWebComField.*, tWebComField."ROWID" from tWebComField where
FaceCode=:"SYS_B_0"
And ComItemCode=:"SYS_B_1"
And upper(RcvTable)=:"SYS_B_2"
|
| gwck0qa3zvft8 | SELECT BGNDATE , BGNTIME , BILLNO , ENDDATE , ENDTIME , ORGCODE , PLUCODE , PLUCOUNT , PLUID , POSCOMUPTYPE , PRI , UPTDATE , YHPRICE , VPROCXZHZXPLU."ROWID" FROM VPROCXZHZXPLU WHERE UPTDATE >= TO_DATE(:"SYS_B_0", :"SYS_B_1") AND ORGCODE=:"SYS_B_2"
|