R12 sla tables
来源:互联网 发布:2017台湾媒体评论淘宝 编辑:程序博客网 时间:2024/06/12 21:21
If you are looking for R12 sla tables information details as follow.
1) All accounting performed before transfer to the GL. Accounting data
generated and stored in "Accounting Events" tables prior to transfer to GL
2) Run "Create Accounting" to populate accounting events (SLA) tables. User
can "View Accounting" only after "Create Accounting" is run. Create
Accounting process
- Applies accounting rules
- Loads SLA tables, GL tables
- Creates detailed data per accounting rules, stores in SLA "distribution
links" table
3) Below are the key tables for SLA in R12
XLA_AE_HEADERS xah
XLA_AE_LINES xal
XLA_TRANSACTION_ENTITIES xte
XLA_DISTRIBUTION_LINKS xdl
GL_IMPORT_REFERENCES gir
Below are the possible joins between these XLA Tables
xah.ae_header_id = xal.ae_header_id
xah.application_id = xal.application_id
xal.application_id = xte.application_id
xte.application_id = xdl.application_id
xah.entity_id = xte.entity_id
xah.ae_header_id = xdl.ae_header_id
xah.ae_line_num = xdl.ae_line_num
xah.event_id = xdl.event_id
xal.gl_sl_link_id = gir.gl_sl_link_id
xal.gl_sl_link_table = gir.gl_sl_link_table
xah.application_id = (Different value based on Module)
xte.entity_code =
'TRANSACTIONS' or
'RECEIPTS' or
'ADJUSTMENTS' or
'PURCHASE_ORDER' or
'AP_INVOICES' or
'AP_PAYMENTS' or
'MTL_ACCOUNTING_EVENTS' or
'WIP_ACCOUNTING_EVENTS'
xte.source_id_int_1 =
'INVOICE_ID' or
'CHECK_ID' or
'TRX_NUMBER'
XLA_DISTRIBUTION_LINKS table join based on Source Distribution Types
xdl.source_distribution_type = 'AP_PMT_DIST '
and xdl.source_distribution_id_num_1 =
AP_PAYMENT_HIST_DISTS.payment_hist_dist_id
---------------
xdl.source_distribution_type = 'AP_INV_DIST'
and xdl.source_distribution_id_num_1 =
AP_INVOICE_DISTRIBUTIONS_ALL.invoice_distribution_id
---------------
xdl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
and xdl.source_distribution_id_num_1 = AR_DISTRIBUTIONS_ALL.line_id
and AR_DISTRIBUTIONS_ALL.source_id =
AR_RECEIVABLE_APPLICATIONS_ALL.receivable_application_id
---------------
xdl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
and xdl.source_distribution_id_num_1 =
RA_CUST_TRX_LINE_GL_DIST_ALL.cust_trx_line_gl_dist_id
---------------
xdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'
and xdl.source_distribution_id_num_1 =
MTL_TRANSACTION_ACCOUNTS.inv_sub_ledger_id
---------------
xdl.source_distribution_type = 'WIP_TRANSACTION_ACCOUNTS'
and xdl.source_distribution_id_num_1 =
WIP_TRANSACTION_ACCOUNTS.wip_sub_ledger_id
---------------
xdl.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'
and xdl.source_distribution_id_num_1 =
RCV_RECEIVING_SUB_LEDGER.rcv_sub_ledger_id
- R12 sla tables
- R12 Mapping Between Subledger Tables, SLA and GL Tables
- R12 Mapping Between Subledger Tables, SLA and GL Tables
- R12 SLA 经典查询
- R12 SLA: Accounting Methods Builder
- EBS R12 SLA: Analyzing Subledger Accounting
- oracle ebs R12 SLA 后台技术
- EBS R12 SLA: Analyzing Subledger Accounting
- Oracle ebs R12 SLA 后台技术
- R12 SLA: From Product Accounting to Subledger Accounting
- R12 SLA 子分类帐和GL总帐关联查询
- Oracle Ebs R12 SLA与GL关系变化
- SLA
- SLA
- EBS R12中SLA子分类帐与子模块的关联关系
- EBS R12中SLA子分类帐与子模块的关联关系
- EBS R12中SLA子分类帐与子模块的关联关系
- EBS R12中SLA子分类帐与子模块的关联关系
- 云计算360度:微软专家纵论产业变革
- Java启动IE并打开指定页面
- 2012年,软件开发者薪资大调查
- 值得推荐的iPhone开发资源汇总
- jQuery 入门教程(3): Events
- R12 sla tables
- 如何成为优秀的JAVA EE架构师
- asp.net使用treeview控件,使用reeNodePopulate事件加载节点
- [转]MySQL 中文显示乱码
- win7系统下 无线wifi热点的搭建
- 网站系统 群发“站内信”的实现
- 通用RFID读写器操作类
- JDBC连接Oracle
- 六大BaaS产品推荐:移动开发必备的后端云服务