--组织
SELECT b.organization_id,C.ORGANIZATION_CODE,b.location_id,b.name
,a.org_information1_meaning||a.org_information1
,CC.SECONDARY_INVENTORY_NAME,CC.DESCRIPTION
,a.org_information_context
FROM HR_ORGANIZATION_INFORMATION_V A ,hr_organization_units B,
MTL_PARAMETERS C
, MTL_SECONDARY_INVENTORIES_FK_V CC
WHERE A.ORGANIZATION_ID(+)=B.organization_id
AND C.ORGANIZATION_ID(+)=A.organization_id
and a.org_information1_meaning is not null
AND CC.ORGANIZATION_ID(+)=b.organization_id
and b.name not like '%无效%'
--and b.name like 'R%'
order by C.ORGANIZATION_CODE,org_information1_meaning
SELECT b.organization_id,C.ORGANIZATION_CODE,b.location_id,b.name
,a.org_information1_meaning||a.org_information1
,CC.SECONDARY_INVENTORY_NAME,CC.DESCRIPTION
,a.org_information_context
FROM HR_ORGANIZATION_INFORMATION_V A ,hr_organization_units B,
MTL_PARAMETERS C
, MTL_SECONDARY_INVENTORIES_FK_V CC
WHERE A.ORGANIZATION_ID(+)=B.organization_id
AND C.ORGANIZATION_ID(+)=A.organization_id
and a.org_information1_meaning is not null
AND CC.ORGANIZATION_ID(+)=b.organization_id
and b.name not like '%无效%'
--and b.name like 'R%'
order by C.ORGANIZATION_CODE,org_information1_meaning
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/133041/viewspace-438524/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
