R12 Supplier simple data
来源:互联网 发布:net和java哪个比较好 编辑:程序博客网 时间:2024/06/05 23:41
//R12 Supplier simple data
select hou.name, pv.vendor_id, pv.segment1, pv.vendor_name, vs.vendor_site_code,vs.PURCHASING_SITE_FLAG, vs.ATTRIBUTE1, pv.creation_date, vs.creation_date
from apps.ap_suppliers pv, ap_supplier_sites_all vs, hr_all_organization_units hou
where –vs.last_updated_by = ‘11704’
pv.vendor_id = vs.vendor_id
AND hou.name =’PG OU’ –in (‘AU OU’,’NZ OU’,’PG OU’,’FJ OU’)
AND vs.org_id = hou.organization_id
AND vs.PURCHASING_SITE_FLAG = ‘N’
AND pv.vendor_type_lookup_code = ‘INTERCOMPANY’
AND vs.INACTIVE_DATE IS NULL
–AND vs.ATTRIBUTE1 IS NOT NULL
–and vs.org_id =143
order by 1,3,4;
0 0
- R12 Supplier simple data
- R12 Supplier Emails
- R12 Disabled Supplier
- R12 BankAccounts--Supplier and Customer
- Supplier Data Model Stuff
- Oracle ebs R12 新功能讨论帖之交易社区(TCA)—Customer Supplier Bank
- R12.1.3 ATP Data Collection requests failed
- Sharing Simple Data
- [AngularJS] Simple Data Binding
- android-share simple data
- Sharing Simple Data笔记
- Anorm, simple SQL data access
- simple.data数据查询方法
- simple.data强类型转换
- simple.data 数据库修改数据
- Java8 Supplier
- R12 - GL / XLA / FAH - How to link GL data to the subledger data or vice versa
- Simple DataField Validation & Get Data Info
- jQuery事件冒泡阻止
- 第十二周项目3--日期时间类
- R12 Supplier Emails
- 关于使用Java实现的简单网络爬虫Demo
- 9.3 GestureRecognizer
- R12 Supplier simple data
- hdu5245---Joyful(期望)
- android 防刷机
- cron任务会重新生成一个对象
- R12 Intercompany Vendors
- 控制台报错:java.lang.OutOfMemoryError: GC overhead limit exceeded
- R12 Disabled Supplier
- h264 Profile_IDC Level_IDC
- Listview错位的问题