--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

最新文章

  1. echarts 用marlkline画线 同时配置中含有datazoom，怎么设置markline
  2. linux文件基本属性
  3. Maven安装与使用
  4. 【重磅推荐】腾讯Bugly2015年移动应用质量大数据报告
  5. ZigBee无线网络技术在小区路灯照明系统的应用
  6. Eclipse SVN插件冲突导致不能使用解决办法
  7. 关于Weblogic连接池的TestConnectionOnReserve
  8. 【POJ1733】【带标记并查集】Parity game
  9. Ubuntu亮度无法调节或调节无法保存的问题
  10. Fix Elementary Boot Screen (plymouth) After Installing Nvidia Drivers
  11. 快速的CDN加速服务
  12. 10个SQL注入工具(转载)
  13. .NET十年回顾
  14. vue笔记未整理
  15. C# 语言 - 一个优雅的分页实现
  16. 解决MySQL忘记root密码
  17. 机器学习-数据可视化神器matplotlib学习之路（一）
  18. learning docker steps(5) ----- docker stack 初次体验
  19. 【ecshop】使用sql 清除测试数据
  20. 常用php操作redis命令整理（四）SET类型

热门文章

  1. 添加到SQLAgentReaderRole角色后报拒绝SELECT权限
  2. 1.初识Linux
  3. WINDOWS遠程常規化後再次切換回到全屏
  4. jQuery 跨域访问的三种方式 No 'Access-Control-Allow-Origin' header is present on the reque
  5. 替换jenkins上打包完成的安装包的方法
  6. SpringMVC参数自动绑定
  7. c语言的一个简单的链表
  8. WdatePicker 没有权限 不能执行已释放 Script 的代码
  9. Server.MapPath和Request.PhysicalApplicationPath的异同
  10. python之信用卡ATM（第五天）