ebs 常用表及sql查询语句 po,ap,inv,oe,ar 模块

《ebs 常用表及sql查询语句 po,ap,inv,oe,ar 模块》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、EBS常用表及SQL查询语句PO,AP,INV,OE,AR模块callfnd_global.APPS_INITIALIZE(1318,50583,401)selectfnd_profile.VALUE('ORG_ID')FROMDUALselect*fromhr_operating_unitshouwherehou.organization_id=204--fndselect*fromfnd_applicationselect*fromfnd_application_tlwhereapplication_id=101select*fromfnd_applica

2、tion_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#'select*fromfnd_id_flex_segmentswhereid_flex_code='GL#'andid_flex_num=50671se

3、lect*fromfnd_profile_options_vlselect*fromfnd_concurrent_programs程序表select*fromfnd_concurrent_requests请求表select*fromfnd_concurrent_processes进程表--invselect*fromorg_organization_definitions库存组织select*frommtl_parameters组织参数select*frommtl_system_items_bwhereinventory_item_id=171andorgan

4、ization_id=204物料表select*frommtl_secondary_inventories子库存select*frommtl_item_locations货位select*frommtl_lot_numbers批次select*frommtl_onhand_quantities现有量表select*frommtl_serial_numbers序列select*frommtl_material_transactions物料事务记录select*frommtl_transaction_accounts会计分录select*frommtl_trans

5、action_types事务类型select*frommtl_txn_source_types事务来源类型select*frommfg_lookupsmlwhereml.LOOKUP_TYPE='MTL_TRANSACTION_ACTION'--poselect*frompo_requisition_headers_all请求头select*frompo_requisition_lines_all请求行select*frompo_headers_all订单头select*frompo_lines_all订单行select*frompo_line_locatio

6、ns_allselect*frompo_distributions_all分配select*frompo_releases_all发送select*fromrcv_shipment_headers采购接收头select*fromrcv_shipment_lines采购接收行select*fromrcv_transactions接收事务处理select*frompo_agentsselect*frompo_vendors订单select*frompo_vendor_sites_all--oeselect*fromra_customers客户select*from

7、ra_addresses_all地址select*fromra_site_uses_all用户select*fromoe_order_headers_all销售头select*fromoe_order_lines_all销售行select*fromwsh_new_deliveries发送select*fromwsh_delivery_detailsselect*fromwsh_delivery_assignments--glselect*fromgl_sets_of_books总帐select*fromgl_code_combinationsgccwhereg

8、cc.summary_flag='Y'