--R12供应商地点层付款方法SQL:select ipmv.payment_method_name,ipmv.payment_method_code,'N' primary_flag,'Y' globalfrom iby_applicable_pmt_mthds aipmv,iby_payment_methods_vl ipmvwhere aipmv.paymen

--R12供应商银行账户SQL：SELECT APS.VENDOR_NAME,       APS.SEGMENT1 VENDOR_CODE,       HP_BANK.PARTY_NAME AS BANK_NAME,       IEBA.BANK_ACCOUNT_NAME,       IEBA.BANK_ACCOUNT_NUM,       HP_BRANCH.PA

SELECT ibybanks.bank_name,                 --银行         ibybanks.bank_branch_name,          --分行         ibybanks.bank_account_num_electronic--银行帐号    FROM iby_external_payers_all iepa,       

--R12公司银行账户SQL：/*BEGIN   mo_global.init('M');END;*/SELECT BA.BANK_ACCOUNT_NAME,       BA.BANK_ACCOUNT_NUM,       BA.BANK_ACCOUNT_ID,       BA.CURRENCY_CODE BANK_CURRENCY_CODE,       CB

转自：http://blog.chinaunix.net/uid-324202-id-3413901.html一、应付帐款--发票分录select ai.INVOICE_NUM, xal.*  from AP_INVOICES_ALL          ai,       XLA_TRANSACTION_ENTITIES xte,       xla_events 

一、应付帐款--发票分录select ai.INVOICE_NUM, xal.*from AP_INVOICES_ALL          ai,XLA_TRANSACTION_ENTITIES xte,xla_events               xe,XLA_AE_HEADERS           xah,XLA_AE_LI

转自：http://www.cnblogs.com/toowang/p/3346831.htmlApplies to:   Oracle Inventory Management - Version: 12.0.6 and later   [Release: 12 and later ] Information in this document applies to any platfor