代码语言
.
CSharp
.
JS
Java
Asp.Net
C
MSSQL
PHP
Css
PLSQL
Python
Shell
EBS
ASP
Perl
ObjC
VB.Net
VBS
MYSQL
GO
Delphi
AS
DB2
Domino
Rails
ActionScript
Scala
代码分类
文件
系统
字符串
数据库
网络相关
图形/GUI
多媒体
算法
游戏
Jquery
Extjs
Android
HTML5
菜单
网页交互
WinForm
控件
企业应用
安全与加密
脚本/批处理
开放平台
其它
【
OracleEBS
】
AR应收帐款凭证
作者:
专注Oracle EBS
/ 发布于
2012/11/29
/
541
select user_name, currency_code, exchange_rate, account_number, descrption, code_accounts, sourcedescription, sum(entered_dr) as entered_dr, sum(entered_cr) as entered_cr, sum(accounted_dr) as accounted_dr, sum(accounted_cr) as accounted_cr, to_char(:startdate, 'yyyy-mm-dd') as startdate, to_char(:enddate, 'yyyy-mm-dd') as enddate from (select rac_bill_party.party_name as user_name, ct.invoice_currency_code as currency_code, ct.exchange_rate, rac_bill.account_number, ct.comments as descrption, substr(gcc_ori.concatenated_segments, instr(gcc_ori.concatenated_segments, '-', 1, 2) + 1, instr(gcc_ori.concatenated_segments, '-', 1, 2)) as code_accounts, substr(fa_rx_flex_pkg.get_description(101, 'GL#', gcc_ori.chart_of_accounts_id, 'ALL', gcc_ori.concatenated_segments), instr(fa_rx_flex_pkg.get_description(101, 'GL#', gcc_ori.chart_of_accounts_id, 'ALL', gcc_ori.concatenated_segments), '-', , ) + 1, instr(fa_rx_flex_pkg.get_description(101, 'GL#', gcc_ori.chart_of_accounts_id, 'ALL', gcc_ori.concatenated_segments), '-', , ) - 1) sourcedescription, -sum(xal.entered_dr) as entered_dr, -sum(xal.entered_cr) as entered_cr, -sum(xal.accounted_dr) as accounted_dr, -sum(xal.accounted_cr) as accounted_cr, to_char(:startdate, 'yyyy-mm-dd') as startdate, to_char(:enddate, 'yyyy-mm-dd') as enddate from xla_ae_lines xal, xla_ae_headers xah, xla.xla_transaction_entities xte, gl_code_combinations_kfv gcc_ori, ra_cust_trx_line_gl_dist_all gd, hz_cust_accounts rac_bill, hz_parties rac_bill_party, ra_customer_trx ct, fnd_user fu where xal.application_id = xah.application_id and xal.ae_header_id = xah.ae_header_id and xte.entity_id = xah.entity_id and xal.code_combination_id = gcc_ori.code_combination_id and xah.application_id = 222 and xte.source_id_int_1 = ct.customer_trx_id and ct.customer_trx_id = gd.customer_trx_id and ct.bill_to_customer_id = rac_bill.cust_account_id and rac_bill.party_id = rac_bill_party.party_id and xte.entity_code = 'TRANSACTIONS' and 'REC' = gd.account_class and 'Y' = gd.latest_rec_flag and ct.created_by = fu.user_id and xah.event_type_code = 'CM_CREATE' and xah.description not like '%SH-保证金退回 %' and nvl(ct.doc_sequence_value, 1) = nvl(:sequence_value, nvl(ct.doc_sequence_value, 1)) &p1 and to_char(gd.gl_date, 'yyyy-mm-dd') between to_char(:startdate, 'yyyy-mm-dd') and to_char(:enddate, 'yyyy-mm-dd') group by rac_bill_party.party_name, ct.invoice_currency_code, ct.exchange_rate, rac_bill.account_number, ct.comments, substr(gcc_ori.concatenated_segments, instr(gcc_ori.concatenated_segments, '-', 1, 2) + 1, instr(gcc_ori.concatenated_segments, '-', 1, 2)), substr(fa_rx_flex_pkg.get_description(101, 'GL#', gcc_ori.chart_of_accounts_id, 'ALL', gcc_ori.concatenated_segments), instr(fa_rx_flex_pkg.get_description(101, 'GL#', gcc_ori.chart_of_accounts_id, 'ALL', gcc_ori.concatenated_segments), '-', , ) + 1, instr(fa_rx_flex_pkg.get_description(101, 'GL#', gcc_ori.chart_of_accounts_id, 'ALL', gcc_ori.concatenated_segments), '-', , ) - 1) union all select rac_bill_party.party_name as user_name, ct.invoice_currency_code as currency_code, ct.exchange_rate, rac_bill.account_number, ct.comments as descrption, substr(gcc_ori.concatenated_segments, instr(gcc_ori.concatenated_segments, '-', 1, 2) + 1, instr(gcc_ori.concatenated_segments, '-', 1, 2)) as code_accounts, substr(fa_rx_flex_pkg.get_description(101, 'GL#', gcc_ori.chart_of_accounts_id, 'ALL', gcc_ori.concatenated_segments), instr(fa_rx_flex_pkg.get_description(101, 'GL#', gcc_ori.chart_of_accounts_id, 'ALL', gcc_ori.concatenated_segments), '-', , ) + 1, instr(fa_rx_flex_pkg.get_description(101, 'GL#', gcc_ori.chart_of_accounts_id, 'ALL', gcc_ori.concatenated_segments), '-', , ) - 1) sourcedescription, sum(xal.entered_dr) as entered_dr, sum(xal.entered_cr) as entered_cr, sum(xal.accounted_dr) as accounted_dr, sum(xal.accounted_cr) as accounted_cr, to_char(:startdate, 'yyyy-mm-dd') as startdate, to_char(:enddate, 'yyyy-mm-dd') as enddate from xla_ae_lines xal, xla_ae_headers xah, xla.xla_transaction_entities xte, gl_code_combinations_kfv gcc_ori, ra_cust_trx_line_gl_dist_all gd, hz_cust_accounts rac_bill, hz_parties rac_bill_party, ra_customer_trx ct, fnd_user fu where xal.application_id = xah.application_id and xal.ae_header_id = xah.ae_header_id and xte.entity_id = xah.entity_id and xal.code_combination_id = gcc_ori.code_combination_id and xah.application_id = 222 and xte.source_id_int_1 = ct.customer_trx_id and ct.customer_trx_id = gd.customer_trx_id and ct.bill_to_customer_id = rac_bill.cust_account_id and rac_bill.party_id = rac_bill_party.party_id and xte.entity_code = 'TRANSACTIONS' and 'REC' = gd.account_class and 'Y' = gd.latest_rec_flag and ct.created_by = fu.user_id and xah.event_type_code = 'INV_CREATE' and xah.description not like '%SH-保证金退回 %' and nvl(ct.doc_sequence_value, 1) = nvl(:sequence_value, nvl(ct.doc_sequence_value, 1)) &p1 and to_char(gd.gl_date, 'yyyy-mm-dd') between to_char(:startdate, 'yyyy-mm-dd') and to_char(:enddate, 'yyyy-mm-dd') group by rac_bill_party.party_name, ct.invoice_currency_code, ct.exchange_rate, rac_bill.account_number, ct.comments, substr(gcc_ori.concatenated_segments, instr(gcc_ori.concatenated_segments, '-', 1, 2) + 1, instr(gcc_ori.concatenated_segments, '-', 1, 2)), substr(fa_rx_flex_pkg.get_description(101, 'GL#', gcc_ori.chart_of_accounts_id, 'ALL', gcc_ori.concatenated_segments), instr(fa_rx_flex_pkg.get_description(101, 'GL#', gcc_ori.chart_of_accounts_id, 'ALL', gcc_ori.concatenated_segments), '-', , ) + 1, instr(fa_rx_flex_pkg.get_description(101, 'GL#', gcc_ori.chart_of_accounts_id, 'ALL', gcc_ori.concatenated_segments), '-', , ) - 1)) group by user_name, currency_code, exchange_rate, account_number, descrption, code_accounts, sourcedescription --application_id 的值 .从ap来的数据为200, 从ar来的数据就是222 select * from fnd_application --EVENT_TYPE_CODE
试试其它关键字
AR应收帐款凭证
同语言下
.
设置窗体的位置
.
初始化操作
.
在FORMS调用WEB页面
.
判断数据块的项是否为空
.
EBS 循环处理块记录
.
Oracle Form中调用并发请求生成报表并输出为PDF的方法
.
添加并发程序到指定职责API
.
EBS请求查询输出
.
删除 AP 发票相关脚本
.
ebs安全性
可能有用的
.
C#实现的html内容截取
.
List 切割成几份 工具类
.
SQL查询 多列合并成一行用逗号隔开
.
一行一行读取txt的内容
.
C#动态修改文件夹名称(FSO实现,不移动文件)
.
c# 移动文件或文件夹
.
c#图片添加水印
.
Java PDF转换成图片并输出给前台展示
.
网站后台修改图片尺寸代码
.
处理大图片在缩略图时的展示
专注Oracle EBS
贡献的其它代码
(
66
)
.
ERP系统里的BOM展开函数
.
EBS查找报表或菜单所属职责
.
查询用户客户化的文件配置
.
SQL写出带扩展数量的BOM多级清单
.
oracle开发常用LOV
.
Oracle Patch 版本的查询
.
科目余额SQL
.
根据报表文件名称关键字查找报表的执行文件名称等信息
.
查找在标准请求组里提交的报表所在的职责
.
查找在菜单里提交的报表所在职责
Copyright © 2004 - 2024 dezai.cn. All Rights Reserved
站长博客
粤ICP备13059550号-3