R12 Supplier Emails

最新推荐文章于 2021-04-04 02:46:13 发布

davidjiangqian

最新推荐文章于 2021-04-04 02:46:13 发布

阅读量348

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle EBS

本文链接：https://blog.youkuaiyun.com/davidjq2009/article/details/46121445

Oracle EBS 专栏收录该内容

14 篇文章

订阅专栏

本博客展示了如何使用SQL查询从多个表中获取R12供应商的详细电子邮件信息，包括供应商名称、ID、段标识、活动结束日期、站点代码、站点停用日期和通信电子邮件等关键字段。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

//R12 Supplier Emails:

SELECT pv.vendor_name
, pv.vendor_id
, pv.segment1
, pv.end_date_active “Vendor Inactive Date”
, vs.vendor_site_code
, vs.inactive_date “Site Inactive Date”
, vs.email_address “Communication Email”
–, epa.default_payment_method_code
, ipm.Payment_Method_Name “Site Payment Method”
–, epa.remit_advice_delivery_method
, epa.remit_advice_email “Remittance Advice Email”
, epa.ext_payee_id, epa.payee_party_id, epa.party_site_id, epa.supplier_site_id, epa.org_id, epa.org_type
FROM IBY_EXTERNAL_PAYEES_ALL epa, PO_VENDORS pv, PO_VENDOR_SITES_all vs, IBY_EXT_PARTY_PMT_MTHDS eppm, IBY_PAYMENT_METHODS_VL ipm
WHERE epa.ORG_ID=132
AND epa.payee_party_id = pv.party_id(+)
AND vs.vendor_id=pv.vendor_id
AND epa.party_site_id=vs.party_site_id(+)
AND epa.org_id = vs.org_id
AND ipm.payment_method_code = eppm.payment_method_code
AND eppm.Payment_flow LIKE ‘DISBURSEMENT%’
AND eppm.EXT_PMT_PARTY_ID = epa.EXT_PAYEE_ID
AND eppm.primary_flag = ‘Y’
AND pv.end_date_active IS NULL
AND pv.vendor_type_lookup_code <> ‘INTERCOMPANY’
AND pv.vendor_type_lookup_code <> ‘EMPLOYEE’
AND vs.inactive_date IS NULL
AND epa.supplier_site_id IS NOT NULL
–AND epa.payee_party_id=81369
ORDER BY pv.vendor_name, vs.vendor_site_code;–85640;