ORACLE EBS常用表及查询语句(最终整理版).docVIP

————————————————————————————————————————————————————— ORACLE EBS常用表及查询语句(最终整理版) ORACLE EBS常用表及查询语句（最终整理版） CSDN 建议去看参考二 参考一： call fnd_global.APPS_INITIALIZE(1318,50583,401) select fnd_profile.VALUE(#39;ORG_ID#39;) FROM DUAL select * from hr_operating_units hou where hou.organization_id=204 --fnd select * from fnd_application select * from fnd_application_tl where application_id=101 select * from fnd_application_vl where application_id = 101 ----值集 select * from fnd_flex_value_sets select * from fnd_flex_values select * from fnd_flex_values_vl ----弹性域 select * from fnd_id_flexs select * from fnd_id_flex_structures where id_flex_code=#39;GL##39; select * from fnd_id_flex_segments where id_flex_code=#39;GL##39; and id_flex_num=50671 select * from fnd_profile_options_vl select * from fnd_concurrent_programs 程序表 select * from fnd_concurrent_requests 请求表 select * from fnd_concurrent_processes 进程表 --inv(库存) select * from org_organization_definitions 库存组织 select * from mtl_parameters 组织参数 select * from mtl_system_items_b where inventory_item_id = 171 and organization_id=204 物料表 select * from mtl_secondary_inventories 子库存 select * from mtl_item_locations 货位 select * from mtl_lot_numbers 批次 select * from mtl_onhand_quantities 现有量表 select * from mtl_serial_numbers 序列 select * from mtl_material_transactions 物料事务记录 select * from mtl_transaction_accounts 会计分录 select * from mtl_transaction_types 事务类型 select * from mtl_txn_source_types 事务来源类型 select * from mfg_lookups ml where ml.LOOKUP_TYPE = #39;MTL_TRANSACTION_ACTION#39; --po（采购订单） select * from po_requisition_headers_all 请求头 select * from po_requisition_lines_all 请求行 select * from po_headers_all 订单头 select * from po_lines_all 订单行 selec