代码语言
.
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
】
收款 借贷
作者:
专注Oracle EBS
/ 发布于
2012/11/29
/
746
SELECT (SELECT NAME FROM hr_operating_units WHERE organization_id = rc.org_id) OU_NAME, rc.trx_number invoice_number, cr.receipt_number, cr.receipt_date, (SELECT NAME FROM apps.RA_CUST_TRX_TYPES_ALL WHERE CUST_TRX_TYPE_ID = rc.CUST_TRX_TYPE_ID AND rc.org_id = org_id) TRX_TYPE, ACCOUNT_CLASS, line_type, (SELECT vat.tax_code FROM apps.RA_CUSTOMER_TRX_LINES_all CTL_INV_LINE, apps.RA_CUSTOMER_TRX_LINES_all CTL_INV_TAX, apps.AR_VAT_TAX_all INV_VAT, apps.RA_CUSTOMER_TRX_LINES_all CTL_LINE, apps.RA_CUSTOMER_TRX_LINES_all CTL_TAX, apps.AR_VAT_TAX_all VAT WHERE CTL_TAX.LINK_TO_CUST_TRX_LINE_ID = CTL_LINE.CUSTOMER_TRX_LINE_ID AND CTL_TAX.LINE_TYPE = 'TAX' AND CTL_TAX.VAT_TAX_ID = VAT.VAT_TAX_ID(+) AND CTL_TAX.PREVIOUS_CUSTOMER_TRX_LINE_ID = CTL_INV_TAX.CUSTOMER_TRX_LINE_ID(+) AND CTL_INV_TAX.LINK_TO_CUST_TRX_LINE_ID = CTL_INV_LINE.CUSTOMER_TRX_LINE_ID(+) AND CTL_INV_TAX.VAT_TAX_ID = INV_VAT.VAT_TAX_ID(+) --and ctl_tax.link_to_cust_trx_line_id AND ctl_tax.customer_trx_line_id = ctl.customer_trx_line_id AND ctl_tax.link_to_cust_trx_line_id = ctl.link_to_cust_trx_line_id --2011804 ) tax_code, TO_NUMBER(DECODE(ctlgd.account_class, 'REC', DECODE(SIGN(NVL(ctlgd.amount, 0)), -1, NULL, NVL(ctlgd.acctd_amount, 0)), DECODE(SIGN(NVL(ctlgd.amount, 0)), -1, -NVL(ctlgd.acctd_amount, 0), NULL))) INV_ACCOUNTED_DR, TO_NUMBER(DECODE(ctlgd.account_class, 'REC', DECODE(SIGN(NVL(ctlgd.amount, 0)), -1, -NVL(ctlgd.acctd_amount, 0), NULL), DECODE(SIGN(NVL(ctlgd.amount, 0)), -1, NULL, NVL(ctlgd.acctd_amount, 0)))) INV_ACCOUNTED_CR, (SELECT segment1 || '-' || segment2 || '-' || segment3 || '-' || segment4 || '-' || segment5 || '-' || segment6 || '-' || segment7 || '-' || segment8 FROM gl_code_combinations WHERE code_combination_id = ctlgd.code_combination_id) inv_account --,APP.RECEIVABLE_APPLICATION_ID , (SELECT segment1 || '-' || segment2 || '-' || segment3 || '-' || segment4 || '-' || segment5 || '-' || segment6 || '-' || segment7 || '-' || segment8 FROM gl_code_combinations WHERE code_combination_id = aev.code_combination_id) Receipt_account, aev.acct_line_type_name, aev.ENTERED_DR, aev.ENTERED_CR, aev.ACCOUNTED_DR, aev.ACCOUNTED_CR --,aev.applied_date FROM apps.ra_customer_trx_all rc, apps.AR_PAYMENT_SCHEDULES_all ps, apps.AR_CASH_RECEIPTS_all CR, apps.ra_cust_trx_line_gl_dist_all CTLGD, apps.ra_customer_trx_lines_all CTL, apps.AR_AEL_SL_REC_V AEV, (SELECT * FROM apps.AR_RECEIVABLE_APPLICATIONS_all APP --WHERE app.display = 'Y' ) APP WHERE 1 = 1 AND Rc.customer_trx_id = CTLGD.customer_trx_id AND NVL(Rc.org_id, -99) = NVL(CTLGD.org_id, -99) AND CTLGD.account_set_flag = 'N' AND CTLGD.customer_trx_line_id = CTL.customer_trx_line_id(+) AND NVL(CTLGD.org_id, -99) = NVL(CTL.org_id(+), -99) AND APP.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID(+) AND APP.APPLIED_CUSTOMER_TRX_ID = rc.CUSTOMER_TRX_ID(+) AND APP.PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID --AND trunc(cr.creation_date) >= to_date(NVL(:p_date,'07-SEP-2009'),'DD-MON-YYYY') AND trunc(cr.creation_date) >= to_date('07-SEP-2009', 'DD-MON-YYYY') AND APP.RECEIVABLE_APPLICATION_ID = AEV.source_id --and receipt_number = 'IBS-38166' --order by 1,2 UNION SELECT (SELECT NAME FROM hr_operating_units WHERE organization_id = cr.org_id) OU_NAME, NULL invoice_number, cr.receipt_number, cr.receipt_date, NULL TRX_TYPE, NULL ACCOUNT_CLASS, NULL line_type, NULL tax_code, NULL INV_ACCOUNTED_DR, NULL INV_ACCOUNTED_CR, NULL inv_account --,APP.RECEIVABLE_APPLICATION_ID , (SELECT segment1 || '-' || segment2 || '-' || segment3 || '-' || segment4 || '-' || segment5 || '-' || segment6 || '-' || segment7 || '-' || segment8 FROM gl_code_combinations WHERE code_combination_id = aev.code_combination_id) Receipt_account, aev.acct_line_type_name, aev.ENTERED_DR, aev.ENTERED_CR, aev.ACCOUNTED_DR, aev.ACCOUNTED_CR --,aev.applied_date FROM apps.AR_CASH_RECEIPTS_all CR, apps.AR_AEL_SL_REC_V AEV --, (SELECT * FROM apps.AR_RECEIVABLE_APPLICATIONS_all APP --WHERE app.display = 'Y' --) APP WHERE 1 = 1 AND trunc(cr.creation_date) >= to_date('07-SEP-2009', 'DD-MON-YYYY') --AND APP.RECEIVABLE_APPLICATION_ID = AEV.source_id --AND app.status <> 'APP' AND cr.receipt_number = AEV.trx_number_c --and receipt_number = 'IBS-38166' ORDER BY 1,
试试其它关键字
收款
借贷
同语言下
.
设置窗体的位置
.
初始化操作
.
在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