R12供应商地点层付款方法SQL
来源:互联网 发布:淘宝哪里查消费总额 编辑:程序博客网 时间:2024/04/30 15:41
--R12供应商地点层付款方法SQL:
select ipmv.payment_method_name,
ipmv.payment_method_code,
'N' primary_flag,
'Y' global
from iby_applicable_pmt_mthds aipmv,
iby_payment_methods_vl ipmv
where aipmv.payment_method_code = ipmv.payment_method_code
and aipmv.payment_flow = 'DISBURSEMENTS'
and nvl(ipmv.inactive_date, trunc(sysdate + 1)) > trunc(sysdate)
and aipmv.application_id = 200
and aipmv.applicable_type_code = 'PAYEE'
and aipmv.applicable_value_to is null
and not exists
(select 1
from iby_ext_party_pmt_mthds iepp,
iby_external_payees_all iepa
where aipmv.payment_method_code = iepp.payment_method_code
and aipmv.payment_flow = iepp.payment_flow
and iepp.payment_function = 'PAYABLES_DISB'
and iepp.ext_pmt_party_id = iepa.ext_payee_id
/*and iepa.org_id = &p_org_id
and iepa.supplier_site_id = &p_vendor_site_id*/)
union
select ipmv.payment_method_name,
iepp.payment_method_code,
iepp.primary_flag,
'N' global
from iby_payment_methods_vl ipmv,
iby_ext_party_pmt_mthds iepp,
iby_external_payees_all iepa
where ipmv.payment_method_code = iepp.payment_method_code(+)
and iepp.payment_flow = 'DISBURSEMENTS'
and nvl(ipmv.inactive_date, trunc(sysdate + 1)) > trunc(sysdate)
and iepp.payment_function = 'PAYABLES_DISB'
and iepp.ext_pmt_party_id = iepa.ext_payee_id
/*and iepa.org_id = &p_org_id
and iepa.supplier_site_id = &p_vendor_site_id;*/
- R12供应商地点层付款方法SQL
- 供应商层和地点层的付款方法
- 应商地点的默认的付款方法SQL
- R12供应商银行账户SQL
- 详解EBS接口开发之更新供应商付款方法
- R12供应商和银行
- 供应商导入R12
- 供应商地点信息更新
- R12:AP付款相关设置
- SAP给供应商付款记帐设置
- 供应商地点导入(API)Demo
- EPIC付款时供应商公司级别的冻结付款后付款消息为【找不到付款文件】调查
- 新建供应商时付款条件取值来源
- 供应商,地址,业务实体,地点关联银行账户
- 供应商信息全SQL
- 供应商 银行 SQL
- SAP通过OOALV操作生成供应商发票以及供应商付款凭证
- 详解EBS接口开发之供应商导入补充-供应商地点增加实例
- 安全使用公共WiFi
- 最小二乘法多项式曲线拟合原理与实现
- 商业化,本质上是通过与用户的感情联系来实现的。
- 黑马程序员——Java/网络编程
- 高性能的内核 Socket 实现 Fastsocket
- R12供应商地点层付款方法SQL
- 《Java并发编程实践》
- tomcat在短时间不能启动项目
- ErWin简单使用说明
- R12供应商银行账户SQL
- 解决 'utf-8' codec can't decode byte 0x8b in position 1: invalid start byte
- 实现java RPC框架
- 黑马程序员——Java/反射
- trunc、round、ceil、floor函数