oracle ebs常用表及查询语句(最终整理版)

《oracle ebs常用表及查询语句(最终整理版)》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、ORACLEEBS常用表及查询语句(最终整理版)ORACLEEBS常用表及查询语句（最终整理版）CSDN建议去看参考二参考一：callfnd_global.APPS_INITIALIZE(1318,50583,401)selectfnd_profile.VALUE('ORG_ID')FROMDUALselect*fromhr_operating_unitshouwherehou.organization_id=204--fndselect*fromfnd_applicationselect*fromfnd_application_tlwh

2、ereapplication_id=101select*fromfnd_application_vlwhereapplication_id=101----值集select*fromfnd_flex_value_setsselect*fromfnd_flex_valuesselect*fromfnd_flex_values_vl----弹性域select*fromfnd_id_flexsselect*fromfnd_id_flex_structureswhereid_flex_code='GL#'——————————————————————

3、———————————————————————————————select*fromfnd_id_flex_segmentswhereid_flex_code='GL#'andid_flex_num=50671select*fromfnd_profile_options_vlselect*fromfnd_concurrent_programs程序表select*fromfnd_concurrent_requests请求表select*fromfnd_concurrent_processes进程表--inv(库存)select*fromor

4、g_organization_definitions库存组织select*frommtl_parameters组织参数select*frommtl_system_items_bwhereinventory_item_id=171andorganization_id=204物料表select*frommtl_secondary_inventories子库存select*frommtl_item_locations货位select*frommtl_lot_numbers批次select*frommtl_onhand_quantities现有量表select*

5、frommtl_serial_numbers序列select*frommtl_material_transactions物料事务记录select*frommtl_transaction_accounts会计分录select*frommtl_transaction_types事务类型select*frommtl_txn_source_types事务来源类型select*frommfg_lookupsmlwhereml.LOOKUP_TYPE='MTL_TRANSACTION_ACTION'——————————————————————————

6、———————————————————————————--po（采购订单）select*frompo_requisition_headers_all请求头select*frompo_requisition_lines_all请求行select*frompo_headers_all订单头select*frompo_lines_all订单行select*frompo_line_locations_allselect*frompo_distributions_all分配select*frompo_releases_all发送select*fromrcv_shi

7、pment_headers采购接收头select*fromrcv_shipment_lines采购接收行select*fromrcv_transactions接收事务处理select*frompo_agentsselect*frompo_vendors订单select*frompo_vendor_sites_all--oe（销售）select*fromra_customers客户select*fromra_addresses_all地址select*fromra_site_uses_all用户select*fromoe_order_headers_all

8、销售头select*fromoe_order_lines_all销售行selec