R12供应商和银行
来源:互联网 发布:淘宝网店的等级 编辑:程序博客网 时间:2024/04/29 17:41
SELECT ass.vendor_id vendor_id,
ass.party_id party_id,
bank.party_id bank_id,
bank.party_name bank_name,
branch.party_id branch_id,
branch.party_name bank_branch_name,
ieba.bank_account_num bank_account_num
FROM ap_suppliers ass,
hz_parties hp,
iby_account_owners iao,
iby_ext_bank_accounts ieba,
hz_parties bank,
hz_parties branch
WHERE ass.party_id = hp.party_id
AND hp.party_id = iao.account_owner_party_id(+)
AND iao.ext_bank_account_id = ieba.ext_bank_account_id(+)
AND ieba.bank_id = bank.party_id(+)
AND ieba.branch_id = branch.party_id(+)
AND ass.vendor_id = p_vendor_id
ORDER BY ieba.creation_date;
ass.party_id party_id,
bank.party_id bank_id,
bank.party_name bank_name,
branch.party_id branch_id,
branch.party_name bank_branch_name,
ieba.bank_account_num bank_account_num
FROM ap_suppliers ass,
hz_parties hp,
iby_account_owners iao,
iby_ext_bank_accounts ieba,
hz_parties bank,
hz_parties branch
WHERE ass.party_id = hp.party_id
AND hp.party_id = iao.account_owner_party_id(+)
AND iao.ext_bank_account_id = ieba.ext_bank_account_id(+)
AND ieba.bank_id = bank.party_id(+)
AND ieba.branch_id = branch.party_id(+)
AND ass.vendor_id = p_vendor_id
ORDER BY ieba.creation_date;
0 0
- R12供应商和银行
- R12供应商银行账户SQL
- 供应商导入R12
- 供应商 银行 SQL
- R12供应商地点层付款方法SQL
- Oracle EBS 供应商银行创建
- R12公司银行账户SQL
- R12 银行/银行分行/银行帐户 设置
- R12 银行/银行分行/银行帐户 设置
- R12法人实体(LEGAL ENTITY)和业务实体(OPERATING UNIT)银行行业的实例
- EBS R11i和R12
- 供应商,地址,业务实体,地点关联银行账户
- 详解EBS接口开发之供应商导入(补充)--供应商银行账户更新
- 供应商
- 客户和供应商账户信息
- 客制供应商申请审批单和供应商导入api
- SAP供应商和客户的创建
- 互联网金融IT解决方案和服务供应商
- 老程序员学C# ------操作DataGridView控件详解
- 倒序输出(2)
- iOS7应用开发16:模态segue、文本框、警告、Action Sheet
- 归并排序
- VirtualBox下linux与win7之间数据空间的建立
- R12供应商和银行
- Free buffer waits 等待事件总结
- 分治算法——快速排序
- FindFirstFile
- 参加广州网页平面UI设计培训让你成为企业精英
- 使用CGI进行远程编辑
- vim中NERDTree 的安装和使用
- 供应商,地址,业务实体,地点关联银行账户
- ubuntu安装