Oracle Fusion常用表

模块	表名	表描述	字段说明
so	doo_headers_all	销售订单头表
so	doo_lines_all	销售订单行表
so	doo_fulfill_lines_all	销售订单明细行表
po	po_headers_all	采购订单头表
po	po_lines_all	采购订单行表
po	po_line_locations_all	采购订单分配表
po	po_distributions_all	采购订单发运表
inv	EGP_SYSTEM_ITEMS_B	物料表	字段:物料编码(ITEM_NUMBER)
INV	MSC_PARAMETERS	库存组织	SELECT ORGANIZATION_ID ,ORGANIZATION_CODE ,ORGANIZATION_NAME FROM MSC_PARAMETERS
AR	HZ_CUST_ACCOUNTS	客户信息	select hca.account_number,hcas.* from HZ_PARTIES t ,HZ_CUST_ACCOUNTS hca ,HZ_CUST_ACCT_SITES_ALL hcas where hca.party_id = t.party_id and hca.cust_account_id = hcas.cust_account_id and t.party_name = ‘’
AR	HZ_CUST_ACCT_SITES_ALL	客户地址信息
INV	Wsh_Delivery_Details	销售订单发运明细表	SELECT Tax_Invoice_Number FROM Wsh_Delivery_Details t WHERE t.Cust_Po_Number = ‘’

待持续补充…
信息来源：https://docs.oracle.com/en/cloud/saas/supply-chain-and-manufacturing/25b/oedsc/index.html