口行软开二期指标定义与查询SQL语句汇总.pdfVIP

--指标定义

select*frombpa_itemdefwhereitemcodeTR13ANDpk_corp1001;

--嵌套指标

selecta.pk_itemdef,a.formula,a.itemcode,a.itemname

frombpa_itemdefastartwitha.pk_itemdef00015A1000000010II82

connectbypriora.formulaLIKE%||pk_itemdef||%AND

a.pk_corp1001;

--指标说明

select

a.pk_itemdef,a.itemcode,a.itemname,to_char(a.formula),to_char(a.formu

la_C)

FROMbpa_itemdefaWHEREa.pk_corp1001ANDa.pk_itemdefIN

(00015A100000000Z39P1);

selectd.itemcode,d.itemname,to_char(d.formula)as

formula,to_char(s.exesql)asexesql

frombpa_itemdefd

innerjoinbpa_itemdef_SQLs

ond.pk_itemdef=s.pk_itemdef

whered.itemcode=DK0202or(d.pk_itemdef=andpk_corp=1001);

--TR13

--complexItem(bq,00015A100000000XET2CTR0201)+/+complexItem(bq

,00015A100000000XET2DTR0101)

--TR11

--baseItem(bq,00015A100000000Z39OYXZ01)+/+baseItem(bq,00015A

100000000Z39P1XZ02)

--ZJ1801

--complexItem(bq,00015A1000000010II8HZJ12--ZJ0201)+/+complexIte

m(bq,00015A1000000010II8LZJ16--)

ZJ16-complexItem(bq,00015A1000000010II8JZJ14)+complexItem(bq,

00015A1000000010II8KZJ15)

--YD2003

--complexItem(bq,00015A1000000010II83YD2001--XZ01)+/+complexIte

m(bq,00015A1000000010II84YD2002--XZ02)

--YD1901

--complexItem(bq,00015A1000000010II7PYD1402--)+/+complexItem(b

q,00015A1000000010II6NYD15)

YD1402-complexItem(bq,00015A1000000010II7GYD1201-GJ0101)+comple

xItem(bq,00015A1000000010II7HYD1202-GJ0102)+

complexItem(bq,00015A1000000010II7IYD1203-GJ0103)+complexItem(b

q,00015A1000000010II7JYD1204-GJ0104)+

complexItem(bq,00015A1000000010II7OYD1401-DK0215)143763.95

zb-147787.414640.73

YD15-complexItem(bq,00015A1000000010II71YD1105-YD0105)+complexI

tem(bq,00015A1000000010II72YD1106-YD0106)+

complexItem(bq,00015A1000000010II7PYD1402)

3803887.51zb6761050850.341051491.07

--YD1802

--complexItem(bq,00015A1000000010II6XYD1102--YD0102)+/+complexI

t