组织单元相关查询

--1:无 0:行政组织 1:财务组织 2:销售组织 3:采购组织 4:库存组织 5:


成本中心 6:利润中心 8:合并范围 10:管理单元 16:HR


select 
t1.fid,t1.fnumber,t1.fname_l2
from t_org_costcenter t1
inner join 
T_ORG_UnitRelation t2 on t1.fid=t2.ffromunitid 
where 
t1.FIsBizUnit=1 and t1.FIsOUSealUp=0
and t2.ftyperelationid=
(select fid from T_ORG_TypeRelation where ffromtype=5 and 
ftotype=1)

and t2.ftounitid='Kx0AAAAEaInM567U'

//财务组织下面的成本中心
select 
t1.fid,t1.fnumber,t1.fname_l2
from t_org_costcenter t1
inner join 
T_ORG_UnitRelation t2 on t1.fid=t2.ffromunitid 
where 
t1.FIsBizUnit=1 and t1.FIsOUSealUp=0
and t2.ftyperelationid=
(select fid from T_ORG_TypeRelation where ffromtype=5 and 
ftotype=1)
and t2.ftounitid='TVUAAAAAELLM567U'






//财务组织下面的库存组织
select 
t1.fid,t1.fnumber,t1.fname_l2
from T_ORG_STORAGE  t1
inner join 
T_ORG_UnitRelation t2 on t1.fid=t2.ffromunitid 
where 
t1.FIsBizUnit=1 and t1.FIsOUSealUp=0
and t2.ftyperelationid=
(select fid from T_ORG_TypeRelation where ffromtype=4 and 
ftotype=1)
and t2.ftounitid='TVUAAAAAELLM567U'




//财务组织下面的行政组织
select 
t1.fid,t1.fnumber,t1.fname_l2
from T_ORG_ADMIN  t1
inner join 
T_ORG_UnitRelation t2 on t1.fid=t2.ffromunitid 
where 
-- t1.FIsOUSealUp=0
--and
 t2.ftyperelationid=
(select fid from T_ORG_TypeRelation where ffromtype=0 and 
ftotype=1)
and t2.ftounitid='TVUAAAAAELLM567U'