oracle语句
-
编辑 删除
erp 组织查询
select msi.secondary_inventory_name,msi.description, ood.ORGANIZATION_ID,ood.ORGANIZATION_NAME,ood.OPERATING_UNIT, hou.name ouname ,ood.SET_OF_BOOKS_ID,sob.name sobname from apps.mtl_secondary_inventories msi, org_organization_definitions ood, hr_operating_units hou,gl_sets_of_books sob where msi.organization_id=ood.ORGANIZATION_ID and ood.OPERATING_UNIT=hou.organization_id and ood.SET_OF_BOOKS_ID=sob.set_of_books_id[@more@]
