全部博文
-
编辑 删除
oracle erp菜单查询
select a.menu_id , --uda.type,--类别b.sub_menu_id , --子菜单a.user_menu_name , --菜单名字a.menu_name, --菜单系统名字b.prompt --显示菜单from apps.FND_MENUS_VL a, APPS.FND_MENU_ENTRIES...
-
编辑 删除
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@]
