oracleEBS中英词汇对照表

oracleebs术语简称ABM - Activity Based ManagementAD - Applications DBAAHL - Oracle Advanced Service OnlineAHM - Oracle Hosting ManagerAK - Oracle Common Modules-AKALR - Oracle AlertAMF - Oracle Fulfillment ServicesAMS - Oracle MarketingAMV - Oracle MarketViewAN - Oracle Sales AnalysisAP - Oracle PayablesAR - Oracle ReceivablesAS - Oracle SalesASF - Oracle Field SalesASG - Oracle CRM Gateway for Mobile ServicesASL - Oracle Mobile Field Sales LaptopASO - Oracle Order Capture ASP - Oracle Field Sales/PalmTM DevicesAST - TeleSalesAU - Application UtilitiesAX - Global Accounting EngineAZ - Application ImplementationBEN - Oracle Advanced BenefitsBIC - Customer IntelligenceBIL - Sales IntelligenceBIM - Marketing IntelligenceBIS - Oracle Applications BISBIV - Oracle Service IntelligenceBIX - Call Center IntelligenceBNE - Oracle Web ADIBOM - Oracle Bills of MaterialBSC - Balanced ScorecardCCT - Oracle Call Center and TelephonyCE - Oracle Cash ManagementCHV - Oracle Supplier SchedulingCLN - Supply Chain Trading Connector forCN - Oracle Sales CompensationCRP - Oracle CapacityCS - Oracle ServiceCSC - Customer CareCSD - Depot RepairCSE - Oracle Enterprise Install BaseCSF - Field ServiceCSI - Install BaseCSL - Oracle Field Service/LaptopCSM - Oracle Field Service Palm CSP - Oracle Spares ManagementCSR - Oracle SchedulerCSS - SupportCST - Oracle Cost ManagementCUA - CRL Financials AssetsCUE - Oracle Billing ConnectCUF - CRL FinancialsCUG - Oracle Citizen Interaction CenterCUI - Oracle NetworkLogistics InventoryCUN - Oracle Network Logistics NATSCUP - Oracle Network Logistics PurchasingCUS - CRL SupplyChainCZ - Oracle ConfiguratorDDD - Oracle CADView-3DDOM - Oracle Document Managment and CollaborationDT - Oracle DateTrackEAA - Oracle SEM ExchangeEAM - Oracle Enterprise Asset ManagementEC - Oracle e-Commerce GatewayECX - Oracle XML GatewayEDR - Oracle E RecordsEGO - Oracle Engineering OnlineENG - Oracle EngineeringENI - Oracle Engineering Intelligence SystemEVM - Value Based ManagementFEM - Strategic Enterprise ManagementFF - Oracle FastFormula FII - Financials IntelligenceFLM - Oracle Flow ManufacturingFND - Application Object LibraryFPT - Oracle Banking CenterFRM - Oracle Report ManagerFTE - Oracle Transportation HubFV - Oracle Federal FinancialsGHR - Oracle Federal HRGL - Oracle General LedgerGMA - Oracle Process Manufacturing SystemsGMD - Oracle Process Manufacturing Product DevelopmentGME - Oracle Process Manufacturing Process ExecutionGMF - Oracle Process Manufacturing FinancialsGMI - Oracle Process Manufacturing InventoryGML - Oracle Process Manufacturing LogisticsGMP - Oracle Process Manufacturing Process PlanningGMS - Oracle Grants AccountingGR - Oracle Process Regulatory MgmtHRI - Human ResourcesIntelligenceHXC - Oracle Time and LaborHXT - Oracle Time and Labor RulesIBA - iMarketingIBC - Oracle iContentIBE - iStoreIBP - Bill Presentment & PaymentIBU - iSupportIBY - iPaymentICX - Oracle Self-Service Web ApplicationsIEB - Oracle Interaction BlendingIEC - Oracle Campaign PlusIEM - Oracle eMail CenterIEO - Call Center TechnologyIES - ScriptingIEU - Oracle Universal Work QueueIEX - Oracle CollectionsIGC - Commitment AdministrationIGF - Student Systems Fin AidIGI - Oracle International Public Sector FinancialsIGS - Oracle Student SytemsIGW - Oracle Grants ProposalIMC - Oracle Customers OnlineIMT - Oracle iMeetingINV - Oracle InventoryIPA - CRL Financials ProjectsIPD - Oracle Product Development ExchangeISC - Supply Chain IntelligenceITG - Oracle Internet Procurement Enterprise ConnectorJA - Asia/Pacific LocalizationsJE - European LocalizationsJG - Regional LocalizationsJL - Latin America LocalizationsJTF - CRM FoundationJTM - Oracle CRM Mobile FoundationJTS - Oracle CRM Self Service AdministrationME - Maintenance, Repair & OverhaulMFG - Oracle ManufacturingMRP - Oracle Master Scheduling/MRPMSC - Oracle Advanced Supply Chain PlanningMSD - Oracle Demand PlanningMSO - Oracle Constraint Based OptimizationMSR - Oracle Risk OptimizationMWA - Mobile ApplicationsODQ - Oracle Data QueryOE - Oracle Order EntryOFA - Oracle AssetsOKB - Oracle Contracts for SubscriptionsOKC - Oracle Contracts Core OKE - Oracle Project ContractsOKI - Oracle Contracts IntelligenceOKL - Oracle Lease ManagementOKO - Oracle Contracts for SalesOKR - Oracle Contracts for RightsOKS - Oracle Contracts Service ModuleOKX - Oracle Contracts IntegrationONT - Oracle Order ManagementOPI - Operations IntelligenceOTA - Oracle Training AdministrationOZF - Funds & Budgets OZP - Trade PlanningOZS - Oracle iClaimsPA - Oracle ProjectsPAY - Oracle PayrollPER - Oracle Human ResourcesPJI - Oracle Project IntelligencePJM - Oracle Project ManufacturingPMI - Process Mfg IntelligencePN - Oracle Property ManagerPO - Oracle PurchasingPOA - Purchasing IntelligencePOM - Oracle ExchangePON - Oracle SourcingPOS - Internet Supplier PortalPQH - Oracle Public Sector HRPQP - Oracle Public Sector PayrollPRP - Oracle ProposalsPSA - Public Sector ApplicationsPSB - Oracle Public Sector BudgetingPSP - Oracle Labor DistributionPV - Partner Relationship ManagementQA - Oracle QualityQOT - Oracle QuotingQP - Oracle PricingQRM - Oracle Risk ManagementRG - Application Report GeneratorRHX - Oracle Advanced Planning FoundationRLA - Oracle Release Management Integration Kit RLM - Oracle Release ManagementSHT - Applications Shared TechnologySSP - Oracle SSPSYSADMIN - System AdministrationVEA - Oracle AutomotiveVEH - Oracle Automotive Integration KitWIP - Oracle Work in Process WMS - Oracle Warehouse Management SystemWPS - Oracle Manufacturing SchedulingWSH - Oracle ShippingWSM - Shop Floor ManagementXDP - Oracle ProvisioningXLA - Oracle Common Accounting ModulesXNB - Oracle eBusiness Billing XNC - Oracle Sales for CommunicationsXNI - Oracle Install Base IntelligenceXNM - Marketing for CommunicationsXNP - Oracle Number PortabilityXNS - Oracle Service for CommunicationsXTR - Oracle TreasuryZFA - Oracle Financial AnalyzerZSA - Oracle Sales Analyzer。

Oracle EBS开发编码规范天马信息技术管理部（内部使用）文档变更记录目录1、引言 (5)1、编写目的 (5)2、适用范围 (5)3、文档规范 (5)2、数据库命名规范 (7)2.1表空间 (7)系统表空间 (7)用户表空间 (7)表空间数据文件 (7)2.4 表相关 (8)表名 (8)列名 (8)主键名 (8)外键名 (8)CHECK约束 (8)UNIQUE约束 (8)索引名 (9)视图 (9)2.5 PL/SQL对象名 (9)过程 (9)函数 (9)包 (9)2.6其他对象 (10)角色名 (10)序列名 (10)同义词 (10)数据库链 (10)3、SQL规范 (10)3.1 CREA TE (11)3.2 SELECT (11)3.3 INSERT (11)3.4 UPDA TE (11)3.5 DELETE (11)5、PL/SQL开发规范 (11)5.1代码 (11)5.2对象名 (12)5.3参数 (12)5.4变量常量 (12)6、Operation System Files(操作系统档案) (13)7、OAF开发规范 (13)命名空间 (13)8、Applications Objects(系统对象) (13)9、Documentation （文件） (14)10、开发评分标准 (15)1、引言1、编写目的运用统一的数据库平台规范，对数据库及EBS整体命名以及编码风格进行标准化，便于管理开发以及维护人员进行阅读、交流与理解。

2、适用范围本规范适用于所有以ORACLE EBS 为平台客制化开发的项目团队及维护团队。

3、文档规范《MMM》表示命名为在实际情况下MMM所表示的内容为模块缩写。

并非MMM本身。

AA + BB + CC表示名称为AABBCC。

AA + BB + CC/DD表示名称为AABBCC或AABBDD。

英文缩写对于英文单词较长的情况下，使用辅音缩写，缩写参照英文缩写规范，并尽量使用通用的缩写方式。

Oracle ERP 中英对照词汇表Aaccount hierarchy（帐户分层结构）Oracle 财务系统的一种特性，您可以用来执行汇总层资金检查。

采用帐户分层结构，Oracle 采购管理系统和总帐管理系统可以快速确定明细帐户累计成的汇总帐户。

Account segment（帐户段）会计弹性域多达 30 个不同节中的其中一个，这些节一起构成您的总帐帐户代码。

段与段之间通过一个您所选定的符号（如-、/ 或\）分开。

每一个段通常表示业务结构的一个要素，如公司、成本中心或帐户。

Account segment value（帐户段值）定义特定值集唯一值的一系列字符和说明。

account structure（帐户结构）请参阅：会计弹性域结构accounting calendar（会计日历）Oracle 总帐管理系统中定义会计期和会计年度的日历。

您可以使用“会计日历”窗口来定义会计日历。

Oracle 财务分析程序可以使用会计日历自动创建“时间”维。

Accounting Flexfield（会计弹性域）用于标识Oracle 财务应用产品中的总帐帐户的代码。

每个会计弹性域段值与科目表中的一个汇总或累计帐户对应。

Accounting Flexfield structure（会计弹性域结构）为满足组织的特定需要而定义的帐户结构。

您可以在会计弹性域结构中选择段数及每个段的长度、名称和顺序。

Accounting Flexfield value set（会计弹性域值集）一组值以及这一组值的属性。

例如，您为帐户段指定用于标识业务特定要素的值长度和值类型（如公司、分部、区域或产品）。

ad hoc（即席）与特殊用途相关并应用于特殊用途。

例如，即席税码或即席数据库查询。

aggregate balance（汇总余额）天数范围内的日终余额总和。

有三种汇总余额类型：期初至今(PTD)、季初至今(QTD) 和年初至今 (YTD)。

所有这三种类型余额均存储在每个日历日的总帐管理系统数据库中。

oracle-ERP系统-中英文名词对照-gl中文翻译GL (General Entry—总账)中文翻译Analyzer 分析程序Accounting Calendar 会计历Allocation 分摊Analyzer 分析程序Accounts 科目Auto Post 自动过账Aliases 别名Books 账册Batch Name 传票编号Combinations 汇总Categories 种类Carryforward 结转Currency 货币Consolidation 合并Column Set 栏目集Content Set 内容集CENTRA 集中交易核准系统Chart of Account 会计科目架构Consolidation 合并报表Cross Validation Rule 合理的会计科目组合规则Dynamic Insert 动态新增会计科目Define 定义Descriptive Flexfield 描述性弹性字段Dimension 区间Document Number 传票号码Encumbrance 保留帐Financial Date Set 财务数据集Filter 节段范围集Formulas 公式Freeze 冻结Flexfields 弹性字段Flexfield Structure 节段弹性字段Groups 群组GCS 全体合并系统Generate 产生Hierarchy 科目节段架构Input Tax Codes 输入税捐代码Intercompany 公司往来Inquiry 请求Import 汇入Journals 分录Journal Source 节段架构Journal Entries 日记账；分录Key 主要Key Flexfield 必要性弹性字段Mass Budget 整批预算Multiple Company Accounting 集团公司往来帐Output Tax Codes 输出税捐代码Purge 清除Period to Date(PTD) 期间(余额)Project to Date(PJTD) 项目累计至今(余额) Post 过账Profile 配置文件Parent Account 孙科目Recurring 递归Reversal 回转Reports 报表Request 请求Row Set 资料列集Right-Justify and Zero-Fill Numbers 未满位数自动归零Report Set 报表集Revaluation 重估Requests 请求Segments 节段Sub Account 子科目Statistic Account 统计性科目Summary Account 总和科目(汇总性科目) Short Hand 会计简码Security Rule 权限Sets 集合Set of Book 设立账簿Suspense 暂计Sequences 顺序Translation 兑换Tax 税捐Transfer 移转Values 值Validation 确认Upload 上载YTD(Year to Date) 年度累计至今(余额)。

GL (General Entry—总账)中文翻译Analyzer 分析程序Accounting Calendar 会计历Allocation 分摊Analyzer 分析程序Accounts 科目Auto Post 自动过账Aliases 别名Books 账册Batch Name 传票编号Combinations 汇总Categories 种类Carryforward 结转Currency 货币Consolidation 合并Column Set 栏目集Content Set 内容集CENTRA 集中交易核准系统Chart of Account 会计科目架构Consolidation 合并报表Cross Validation Rule 合理的会计科目组合规则Dynamic Insert 动态新增会计科目Define 定义Descriptive Flexfield 描述性弹性字段Dimension 区间Document Number 传票号码Encumbrance 保留帐Financial Date Set 财务数据集Filter 节段范围集Formulas 公式Freeze 冻结Flexfields 弹性字段Flexfield Structure 节段弹性字段Groups 群组GCS 全体合并系统Generate 产生Hierarchy 科目节段架构Input Tax Codes 输入税捐代码Intercompany 公司往来Inquiry 请求Import 汇入Journals 分录Journal Source 节段架构Journal Entries 日记账；分录Key 主要Key Flexfield 必要性弹性字段Mass Budget 整批预算Multiple Company Accounting 集团公司往来帐Output Tax Codes 输出税捐代码Purge 清除Period to Date(PTD) 期间(余额)Project to Date(PJTD) 项目累计至今(余额) Post 过账Profile 配置文件Parent Account 孙科目Recurring 递归Reversal 回转Reports 报表Request 请求Row Set 资料列集Right-Justify and Zero-Fill Numbers 未满位数自动归零Report Set 报表集Revaluation 重估Requests 请求Segments 节段Sub Account 子科目Statistic Account 统计性科目Summary Account 总和科目(汇总性科目) Short Hand 会计简码Security Rule 权限Sets 集合Set of Book 设立账簿Suspense 暂计Sequences 顺序Translation 兑换Tax 税捐Transfer 移转Values 值Validation 确认Upload 上载YTD(Year to Date) 年度累计至今(余额)。

INV(Inventory—存货管理)中文翻译ABC Classes ABC分类ABC Assignment Groups 群组指定ATP (Available to Promise) 允诺量ATO (Assemble to Order)Attribute Controls 属性控制Aisle 走道Account Aliases 会计科目别名Asset Tracked 资产追踪Accounting Calendar Types 会计日历类别Accounting 会计科目By Manufactures 依制造料品编号Books 会计账册Bin 储物箱；排Container Types 容器类别Catalog Groups 目录群组Cost 成本Average Cost Update 平均更新Cost Mass Edits 大量成本数据编辑 Copy Cost Information 拷贝成本信息Purge Cost Information 清除成本信息Cost Types 成本类别Counting 盘点Cycle Counts 循环盘点Cycle Count Entries 循环盘点登入Approve Counts 循环盘点确认Currencies Daily Rates 币别汇率Currencies Period Rates 汇率区间Currency Codes 币别码Change Organization 变更组织Corrections 修订Category 分类Category Sets 分类组别Category Codes 分类编码Classes 类别Conversions 转换Cross References 料号对照表Compile Demand History 历史需求编译Consign-in 调借Default Category Sets 预设分类组别Descriptive Elements 料品品名规格说明Document 文件说明Demand History 历史需求Defaults 默认值Delete Constraints 删除限制Entries 登入View Entries 登入查询Encumbrance 滞纳Purchase Order Encumbrance 采购滞纳金Freight Carriers 运送Flexfields 弹性字段FGI(Finished Goods Inventory) 成品仓Generate Serial Numbers 产生序号Inspect 检验IPV(Invoice Price Variance) 发票价与采购之价差Item 料品Customer Item Commodity Code 客户料品产品码Item Types 料品类别Item Transaction Default 料品异动预设Item Relationships 料品关联Item Costs 料品成本Item Information 料品信息Item Search 料品搜寻Item Supply/Demand 料品供需Customer Items 客户料品对照Assign Items 指定料品Update Item Assignments 更新指定料品Mass Edit Item Accounts 大量料品会计科目编辑 Master Items 主料品Organization Items 组织料品Import Items 转入料品Delete Items 删除料品By Items 依料品编号Inter-Location Transit 内部储位移转Inter-organizational Transfer 调拨Intransit Inventory 路途中之货品Kanban 广告牌Generate Kanban Cards 产生广告牌Print Kanban Cards 打印广告牌Lots 批量Lot Control 批次控制Locator Control 储位控制Locations 仓库地址Manufactures' Part Numbers 制造料品编号Manage Shipments 出货管理Material Distributions 原物料分配Movement Statistics 异动统计Multi Organizations Quantities 组织量Manual Requests 手开需求单On-hand,Availability 手量On-hand Quantities 在手可用量Parameters 参数Pull SequencesPPV(Purchase Price Variance) 采购价差Physical Inventory 固定盘点Pending Status 呆滞状况Purge 清除Purge Cost Update History 除成本更新历史Quantity Tracked 数量追踪Row 排；列Rules 规则；定义Receiving 收货；收料Receiving Site 货品暂放区RFQ 事先报价Rack 架；层Receipts 收货RMA Receipt 退修收件Returns 退货Customer Returns 客户退货RMA Return 退修件确认RIP(Raw in Process) 原料处理Resource Supply for ATP 允诺量资源供应Revision Quantity Control 版本控制Reservations 保留料品Reorder Point Planning 订购点Serial Numbers 序号Serial Control 序号控制Subinventories 子仓库Shelf Life Control 料品生命周期控制Shipping Networks 配送网Shipping Methods 运送方式Safety Stocks 安全库存Safety Stock Update 安全库存更新Standard Cost Update 标准成本更新Scrap 废品Ship-To Location 代收货品之地址Source Types 来源种类Status Codes 状态代码Sub-elements Material 原物料Subinventory Transfer 库房间调拨Transactions 异动Transaction Open Interface 异动开启界面Pending Transactions 呆滞料异动Receiving Transactions 收货异动View Receiving Transactions 收货异动查询Transactions Status Summary 异动状况总览Miscellaneous Transaction 杂收发其他异动 Material Transactions 原物料异动Material Transactions Summaries原物料异动总览Transfer 移转Subinventory Transfer 仓库移转Inter-organizations Transfer 组织间移转Templates 样版Calendar Exception Template 工作历例外日UOM (Units of Measure) 度量单位。

Oracle EBS常用数据表INV库存organization 两个含义:1. 经营单位，A/B/C分公司，A下面有A1，A2等工厂，主题目标是为了独立核算此组织ORG，ORG_ID;2. 库存组织，例如制造商的仓库，例如A1，A2等工厂Organization_id;HR_ORGANIZATION_UNITS －Org_organization_definitionsMtl_subinventory_ 库存组织单位MTL_PARAMETERS -库存组织参数（没有用ID，直接用name）MTL_SYSTEM_ITEMS_b -物料信息（同上，应用了库存组织name）MTL_SECONDARY_INVENTORIES -子库存组织 -MTL_ITEM_LOCATTIONS -货位 - SUBINVENTROY_CODEMtl_Material_Transactions - (库存)物料事物表成本 mtl_transaction_accountstransaction_cost是事物成本；ACTUAL_COST是通过成本算法计算出来的实际成本，主计量单位现有量汇总历史记录（正负合计）Mtl_Material_TransactionsMTL_ONHAND_QUANTITIES现有量表，组织/子库存/货位/物品 summary可能按照挑库先进先出统计，如果设置了"不允许负库存"，这样就不可能出现负数PO请购单头表Po_Requisition_Headers_all行表Po_Requisition_lines_all采购订单PO_HEADER_ALLPO_LINES_ALL采购接收－退货/组织间转移/正常状态都需要使用这个模块RCV_TRANSACTIONS1. 接收100单位货物,放入“待质检”货位2. 接受/拒绝3. 库存/退回有三个不同的状态！例如：接收100个，80个接受入库，20个退回，那么有80个接受事务/20个退回事物select TRANSACTION_TYPE，DESTINATION_TYPE_CODE from RCV_TRANSACTIONS可以看出以下阶段：A1.RECEIVE – RECEIVINGA2.ACCEPT – RECEIVINGA3.DELIERY – INVETORY(影响库存现有量)如果按照正常模式，最后会触发产生MTL_MATERIAL_TRANSACTIONS销售订单OE_ORDER_headers_allSOLD_FROM_ORG_IDSOLD_TO_ORG_ID 就是客户层SHIP_FROM_ORG_IDSHIP_TO_ORG_ID 就是客户收货层INVOICE_TO_ORG_ID 就是客户收单层DELIVER_TO_ORG_ID和客户结构有关客户 RA_customers客户Address Ra_AddressesAddress 货品抵达 site RA_SITE_USES_ALLAddress 发票抵达 siteOE_ORDER_LINEs_allGL凭证gl_je_batches凭证日期: DEFAULT_EFFECTIVE_DATE会计期间: DEFAULT_PERIOD_NAME原币种凭证批借贷方汇总: RUNNING_TOTAL_DR/CR 比如美元本位币凭证批借贷方汇总: RUNNING_TOTAL_ACCOUNTED_DR/CRgl_je_headers日记账头信息批号: JE_BATCH_ID会计期间: PERIOD_NAME币种: CURRENCY_CODE汇率类型: CURRENCY_CONVERSION_TYPE汇率日期: CURRENCY_CONVERSION_DATE帐套: SET_OF_BOOKS_ID 参考 GL_SETS_OF_BOOKS凭证类型: JE_CATEGORY 参考 GL_JE_SOURCES凭证来源: JE_SOURCEgl_je_lines日记账体信息CODE_COMBINATION_ID 科目组合编号GL_BALANCES 总帐余额PERIOD_NET_DR/CR 净值BEGIN_BALANCE_DR/CR 期初额AR应收发票RA_CUSTOMER_TRX_ALLCUSTOMER_TRX_ID 发票编号BILL_TO_SITE_USE_ID 客户收单方编号PRIMARY_SALES_ID销售员REFERENCE是Oracle提供的外部编号输入框，但是由于版本问题和长度(<=30)，不建议用户使用，如果要使用外部编号，请使用说明性弹性域RA_CUSTOMER_TRX_LINES_ALLLINE_ID 行号INVENTORY_ITEM_ID 可以为空，比如非物料的服务，只在DESCRIPTION中出现 /税行DESCRIPTIONQUANTITY_INVOICE 开票数量LINE_TYPE 行类型 (一般/税)EXTEND_PRICE 本行金额注意：税行是隐藏行，所以至少会有两行收款情况AR_CASH_RECEIPTS_ALL（还包含了非收款信息）CASH_RECEIPT_ID 内部codeRECEIPT_NUMBER 收款号RECEIPT_DATE 收款日期AMOUNT 总额RECEIPT_TYPE 现金/杂项 Cash/MiscFUNCTIONAL_AMOUNT 本位币计量金额UI上为RECEIPTS核销关系不是一一对应，也不是一次核销100%,UI上右下方的Application 按钮AR_RECEIVABLE_APPLICATIONS_ALLAPPLIED_CUSTOMER_TRX_ID 发票编号APPLIED_CUSTOMER_TRX_LINE_ID 发票行编号STATUS APP表示核销 /UNAPP表示未核销AMOUNT_APPLIED 匹配金额注意:红冲收款报表时间跨月的问题；必须联查 AR_CASH_RECEIPTS_ALL和AR_CASH_RECEIPT_HISTORY_ALLAP应付帐款(是我方人员按照供应商提供的纸张发票信息录入)UI 上的invoiceAP_INVOICES_ALL实际付款PAYMENTAP_CHECKS_ALL核销关系同AR，右下方的Payment 按钮AP_INVOICE_PAYMENTS_ALL客户余额表，情况比较复杂:比如两个用户合并，应收应付差额，预付款资产信息FA_ADDITIONS名称编号分类数量资产类别FA_CATEGORIES资产帐簿FA_BOOK_CONTROLS 和会计帐簿有什么关系？FA_BOOKSUI中的InquiryMothed是折旧方法(直线法/产量法)FA_DISTRIBUTION_HISTORY分配assignment，给什么部门使用多少LOCATION_ID 部门联查FA_LOCATIONS折旧信息(分摊方法)FA_DEPRN_DETAILperiod_counter 折旧期间编号折旧事务(新增、重建、转移、报废)FA_TRANSACTION_HEADERSselect fnd_profile.VALUE('ORG_ID') FROM DUALselect * from hr_operating_units hou where anization_id=204--fndselect * from fnd_applicationselect * from fnd_application_tl where application_id=101select * from fnd_application_vl where application_id = 101----值集select * from fnd_flex_value_setsselect * from fnd_flex_valuesselect * from fnd_flex_values_vl----弹性域select * from fnd_id_flexsselect * from fnd_id_flex_structures where id_flex_code='GL#'select * from fnd_id_flex_segments where id_flex_code='GL#' and id_flex_num=50671select * from fnd_profile_options_vlselect * from fnd_concurrent_programs 程序表select * from fnd_concurrent_requests 请求表select * from fnd_concurrent_processes 进程表--invselect * 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 = 'MTL_TRANSACTION_ACTION'--poselect * from po_requisition_headers_all 请求头select * from po_requisition_lines_all 请求行select * from po_headers_all 订单头select * from po_lines_all 订单行select * from po_line_locations_allselect * from po_distributions_all 分配select * from po_releases_all 发送select * from rcv_shipment_headers 采购接收头select * from rcv_shipment_lines 采购接收行select * from rcv_transactions 接收事务处理select * from po_agentsselect * from po_vendors 订单select * from po_vendor_sites_all--oeselect * from ra_customers 客户select * from ra_addresses_all 地址select * from ra_site_uses_all 用户select * from oe_order_headers_all 销售头select * from oe_order_lines_all 销售行select * from wsh_new_deliveries 发送select * from wsh_delivery_detailsselect * from wsh_delivery_assignments--glselect * from gl_sets_of_books 总帐select * from gl_code_combinations gcc where gcc.summary_flag='Y' 科目组合select * from gl_balances 科目余额select * from gl_je_batches 凭证批select * from gl_je_headers 凭证头select * from gl_je_lines 凭证行select * from gl_je_categories 凭证分类select * from gl_je_sources 凭证来源select * from gl_summary_templates 科目汇总模板select * from gl_account_hierarchies 科目汇总模板层次--arselect * from ar_batches_all 事务处理批select * from ra_customer_trx_all 发票头select * from ra_customer_trx_lines_all 发票行select * from ra_cust_trx_line_gl_dist_all 发票分配select * from ar_cash_receipts_all 收款select * from ar_receivable_applications_all 核销select * from ar_payment_schedules_all 发票调整select * from ar_adjustments_all 会计分录select * from ar_distributions_all 付款计划--apselect * from ap_invoices_all 发票头select * from ap_invoice_distributions_all 发票行select * from ap_payment_schedules_all 付款计划select * from ap_check_stocks_all 单据select * from ap_checks_all 付款select * from ap_bank_branches 银行select * from ap_bank_accounts_all 银行帐号select * from ap_invoice_payments_all 核销。