oracle concepts for youFRIDAY, 6 JUNE 2014
R12 Supplier Bank Accounts
In Release 12, Payables Supplier Bank Information is stored somewhere else instead of PO_VENDORS table as in 11i. The supplier (or External) bank account information are stored in the table called IBY_EXT_BANK_ACCOUNTS. The bank and bank branches information are stored in the table HZ_PARTIES. They are linked together through Relationships (in HZ_RELATIONSHIP).
There is a separate link for both Bank to Branch and also from Branch to Bank. Bank sites and Location information are stored in tables: HZ_PARTY_SITES and HZ_LOCATIONS. The bank_id and branch_id fields of IBY_EXT_BANK_ACCOUNTS table link the Bank Account to the relevant Bank and Branch Parties in the HZ_PARTIES table
(IBY_EXT_BANK_ACCOUNTS.BANK_id = hz_paties.party_id).
Supplier (or External) bank accounts are created in Payables, in the Supplier Entry forms. Navigate to Suppliers -> Entry. Query or create your supplier. Click on Banking Details and then choose Create. After you have created the bank account, you can assign the bank account to the supplier site.
When the Bank is assigned to Vendors then it will be updated in a table called HZ_CODE_ASSIGNMENTS. Payment related details of supplier are also inserted in iby_external_payees_all as well as iby_ext_party_pmt_mthds.
The bank branch number can be found in the table: HZ_ORGANIZATION_PROFILES .The HZ_ORGANIZATION_PROFILES table stores a variety of information about a party. This table gets populated when a party of the Organization type is created.
IBY_EXTERNAL_PAYEES_ALL stores payment-related attributes for the funds disbursement payment process for external party payees.
Queries: ElangovanRagavan எ ண ய த ேவ , ந லேவ ெய ண ேவ ; தி ண ய ெந ச ேவ , ெதள த ந லறி ேவ ; ப ண ய பாவெம லா ப தி பன ேய ேபால, ந ண ய நி ன நசி திட ேவ அ னா !
View my complete profile
Join this site
with Google Friend Connect
Members (54) More »
Already a member? Sign in
SELECT aps.vendor_name "VERDOR NAME", apss.vendor_site_code "VENDOR SITE CODE", ieb.bank_name "BANK NAME",
iebb.bank_branch_name "BANK BRANCH NAME", iebb.branch_number "BRANCH NUMBER",
ieba.BANK_ACCOUNT_NUM "BANK ACCOUNT NUMBER", ieba.BANK_ACCOUNT_NAME "BANK ACCOUNT NAME" FROM ap.ap_suppliers aps,
ap.ap_supplier_sites_all apss, apps.iby_ext_bank_accounts ieba, apps.iby_account_owners iao, apps.iby_ext_banks_v ieb,
apps.iby_ext_bank_branches_v iebb WHERE aps.vendor_id = apss.vendor_id
and iao.account_owner_party_id = aps.party_id
and ieba.ext_bank_account_id = iao.ext_bank_account_id and ieb.bank_party_id = iebb.bank_party_id
and ieba.branch_id = iebb.branch_party_id and ieba.bank_id = ieb.bank_party_id;
Older PostSubscribe to: Post Comments (Atom)
Posted by ElangovanRagavan at 16:16
Labels: Bank Query, Supplier
SELECT party_supp.party_name supplier_name , aps.segment1 supplier_number , ass.vendor_site_code supplier_site , ieb.bank_account_num , ieb.bank_account_name , party_bank.party_name bank_name , branch_prof.bank_or_branch_number bank_number , party_branch.party_name branch_name , branch_prof.bank_or_branch_number branch_number FROM hz_parties party_supp
, ap_suppliers aps , hz_party_sites site_supp , ap_supplier_sites_all ass , iby_external_payees_all iep , iby_pmt_instr_uses_all ipi , iby_ext_bank_accounts ieb , hz_parties party_bank , hz_parties party_branch , hz_organization_profiles bank_prof , hz_organization_profiles branch_prof WHERE party_supp.party_id = aps.party_id AND party_supp.party_id = site_supp.party_id AND site_supp.party_site_id = ass.party_site_id AND ass.vendor_id = aps.vendor_id
AND iep.payee_party_id = party_supp.party_id AND iep.party_site_id = site_supp.party_site_id AND iep.supplier_site_id = ass.vendor_site_id AND iep.ext_payee_id = ipi.ext_pmt_party_id AND ipi.instrument_id = ieb.ext_bank_account_id AND ieb.bank_id = party_bank.party_id
AND ieb.bank_id = party_branch.party_id AND party_branch.party_id = branch_prof.party_id AND party_bank.party_id = bank_prof.party_id ORDER BY party_supp.party_name
Recommend this on Google
Enter your comment...
Comment as: Google Account
Post a Comment
Live Traffic Feed
A visitor from Bangalore,
Karnataka viewed "
concepts for you: R12 Supplier
" 47 secs ago
A visitor from Bangalore,
Karnataka viewed "
concepts for you: Oracle Apps
Technical Interview Questions
A visitor from Chennai, Tamil
Nadu viewed "
oracle concepts for
you: To add Responsibility in
Back end Process
" 9 mins ago
A visitor from Mechelen,
Antwerpen viewed "
concepts for you: Contract
Purchase Agreements in Purchase
" 12 mins ago
A visitor from India viewed
oracle concepts for you:
" 17 mins ago
A visitor from Chicago, Illinois
oracle concepts for you:
Different type of xml tags in bi
" 18 mins ago
A visitor from Cuauhtémoc,
Chihuahua viewed "
concepts for you: DBA
" 21 mins
A visitor from San Francisco,
California left "
for you: December 2013
24 mins ago
A visitor from Cambridge,
Massachusetts viewed "
concepts for you: Inventory
Consists in Oracle Apps
" 24 mins
A visitor from San Francisco,
California viewed "
concepts for you: December
" 24 mins agoTOTAL PAGEVIEWS
3 0 8 7 2 6ADF (2) Advanced PL/SQL (16) AIGS (10) AIM Document (1) Alert (7) AME (17) AOL (5) AP Functional Accounting (9) AP_Module (76) APEX (70) API'S / INTREFACES (62) Application Short Name (1) approved supplier list (1) LABELS
APPS (11) AR_Query (54)
Back-to-Back Order Cycle (1) Bank Query (28)
Cash Management (6) concurrent program (40) Contorl file ctl (7)
Contorl file SQL *Loader (4) Current Login Users (1) custom.pll (6) Customer (8) Data Extraction (57) Data Model (2) Date Format (6) DBA (90) DELETE_QUERY (1) DFF (3) Documents (1) EAM (14) elango (5) ERROR (23) Executable (21) FA (12) FlexFields (4) FND_LOAD (9) form personalization (45) Forms (20) FUNCTIONAL (71) gl (69) GL Accounting (6) GRC (21) GRC Tech (12) HRMS (80) Hyperion (7)
ICX - Oracle Self-Service Web Applications (2) iExpenses (8) IF (1) Inventory_Details (30) iprocurement (3) ITEM_TEMPLATE (1) java (7)
Lexical & Bind (2) LINKS IN ALL TABLES (5) Materialized View (1) Multi-Org (13) My Favorited Links (1) MY FAVOURITES (2) O2C CYCLE (19) OBIEE (73) ODI (1)
OM (10) Oracle (1)
ORACLE -Orbital Relational Analytical Computing Logical Equation (5)
Oracle Certification (1) Oracle Discoverer (4)
Oracle Interview Questions (42) Oracle Pricing (6)
Oracle Standard Reports (25) org (4)
Output type in Oracle (1) P2P Cycle (14)
Password in EBS (3) Payroll (2)
Personalize OAF Pages (16) PL/SQL (52) PO (67) profile (7) Projects (37) QUERY (3) R12 (3) RDF report (4) Receipt (1) Reconciled Payments (2) REPORT (13) REPORT NAMES (1) REPORT_QUERY (9) request group (1) Request Set (2) Reset the po (2) Responsibility (16) Shell Script (6) SLA (13) SQL (62) SRW.user_exit (2) SUB_QUERY (1) Supplier (13) sysadmin (15) Tables (60) TAX (15) TCA R12 (6) technical (4) Time Formets (2) TOAD (2) Trace (3) UPDATE QUERY (20) User Hooks (1) USER_RES_MENU (11) Valueset (17) Videos (6)
VPD in Oracle (1) Web ADI in Oracle (4) Windows XP (1) Workflow (4) XLA_SUB_LEDGER (20) xml (78) ▼ 2014 (696) ► November (15) ► October (12) ► September (36) ► August (4) ► July (178) ▼ June (177) ODBC Vs OCI Setting up the ODBC
Connection for OBIEE OBIEE Development Life cycle- Administration Scheduler in OBIEE11g OBIEE 11g log files path OBIEE 11g Security :
Row-Level Security Parent Child Hierarchy in
OBIEE 10g to 11g Upgrade CREATING REPORTS
USING RTF TEMPLATE IN BI PUBLISHE... Creating Analyses and
Building Dashboards in 11g
How To Reset User Password in 8.6.5 and
above:-Concept behind Subledger Accounting
PO to GL link in R12 ATO Configuration Cycle In
Order Management PTO Configuration Cycle In
Order Management API Script to add the
responsibilities to a user API script to Disable the
enabled Responsibilities... API script to Enable the
Disabled Responsibilities... Script to generate the FND
Submit Concurrent Program through DB Trigger Oracle DBA Querys
1. Query To get list of responsibilities. ======== ...
Which User is Locking the table
Query to get the Menu,Submenu and function details... Script to Calculate the Price
and Tax details of t... Script to Calculate the Tax
details of the Product... Script to Calculate the Price
details of the Produ... TCA Api to Update the Party
Information (HZ_PARTY_... P2P Technical
Flow(Complete Query) Customer & Supplier
Banks(External Banks) Technica...
Sub Ledger Accounting SLA (Complete Functional Inf... R12 Subledger Accounting AR to GL link in R12 TCA Create Party Package Query to find attachments of
AP Invoice not getting added to Assets Important TCA APIs Adding list of values to a
field in OAF Create a simple update
Create a Simple Search Page Subledger-Ledger Linkage (Accounts Receivable) Subledger-Ledger Linkage (Accounts Payables) Subledger-Ledger Linkage (Purchasing) Connect By Level Special/French Characters Conversion Sometimes you... Dates in Hours/Minutes/Secs Script to get profile option
values at different l... Script to set profile value at
View Other Users Request Output
Script to Give Grant (Read Only) for all Objects t... Script to create Synonym for
all Objects for a par... XML Publisher Report with
PLSQL as Data Source and...
Let's Play with SQL How to Delete a Service
Information to get the current session SQL stateme... API to delete purchase
User Hooks in Oracle API To Create/Update Party Oracle WebLogic Server
12c: Installing WebLogic Se...
Oracle WebLogic Server (WLS) 12c Release 1 (12.1.1...
Connecting Remotely to Weblogic Management Port - ...
Useful GRC Note Id's Oracle GRC Suite Configuration Controls
Governor - CCG Installation...
Oracle Weblogic 12c Install Configuring SSL R12
-Oracle Applications Configuring DMZ server R12
- Oracle Application Personalize / Customize
E-Business Suite Login Pag...
Personalize Customize Oracle R12 Login Page Marathon Upgrade R12.1.1
to R12.1.3 Direct Login to forms SOA 11g J-Rockit 28 class
allocation footprint in ... Integration of WebLogic
Deployed Application with ...
RMAN Backup Scripts DBA Querys
Displaying Workflow Notification on home page Applying HR Global Patches Allow Backend Access to
Oracle R12 - installation Guide
Oracle 11i And R12 Documentation Db sequential file read
Customer Account Creation Using TCA APIs
Upgrading Oracle GRC from 126.96.36.19900 to
Oracle GRC ACCG Installing CCG Patching strategy CCG configuring with RAC
EBS database using ASM fi...
Step by step Installation & configuration of Oracl... How to use ETRM
Oracle Technical Data Model Oracle Application:Data
1) What is ERP? Architecture of apps? A pa... Create Menu and
responsibility to attached the Use...
Time Converter in US to INDIA
How to check the PF Trace
Delete Script for XML template
RTF Template - Variables RTF Template Word
NACHA FORMAT in Oracle Apps
how to identify the special character in oracle Charli Chaplin
APJ abdul kalam speech How to find the backend SQL query from Self Servic...
R12 Oracle Payables Management Fundamentals
HRMS update position API HRMS update job API Concurrent Executable and
Program Creations and De...
SQL Report - Submenu and Function Details
(Respons... How to submit the
concurrent request from PLSQL
How to register the oracle reports in oracle apps How to register the forms in
Pay on Receipt(s) in Oracle Apps R12
Purchase Order > Approval hierarchy in oracle apps... Query to find Project
Manager Info of an Oracle Pr...
API to cancel AP Invoice Few Important AP Tables How can you query the bank
account associated with... R12 Supplier Bank Accounts Account Payable FAQs Table/View Changes in R12:
Setup - Approval Hierarchies in Oracle Purchasing HZ tables in Oracle
Receivables List of Receipts API in
Oracle Receivables AR Tables:A Diagrammatic Relation Trading Community Architecture (TCA) in Oracle App...
AutoInvoice program setup steps in AR
AutoInvoice in Oracle Apps R12
Order to Cash (O2C) Cycle in oracle apps
Query to get Customer Information in R12 R12 Customer Bank
Payment Method Defaulting Rule in oracle apps Delete HRMS Job API Delete HRMS Position API Summary column vs.
Formula Column vs. Placeholder ...
User Exits in Oracle Reports Calling a Report from a Form
in oracle apps How Create a report with
Lexical Parameter in orac...
Lexical parameterThese are used to replace a value... SRW Package in Oracle
If you want to design similar functionality as bel... 11i vs. R12 Procure to Pay
To Remove Special Characters Use following Replace...
How To Find the
FND_PATCHSET_LEVEL While Applying ... There are no active
responsibilities available for...
Query to check value of Profile Options in R12 Query to find currently
running sql in database Patch release history query
in oracle apps. Oracle apps Reports FAQ Important Tables for Oracle
Free Space in Tempory Tablespace
Obsolete Database Parameters
Oracle Instance last started Database uptime and
startup time / Lost clone in D...
Oracle Dependency Tree structure
Oracle Schema Summery Active session queries in
Table Locking Information in SQL/PLUS
uncommited TRANSACTION in apps
Multiple session list of a user Oracle Certification exams Uncosted Material
Transactions with CSTPSISC.INS_S... APP-FND-00804: Program
error: Invalid arguments to...
How to get the 5th highest value from a table ORA-01002: fetch out of
Dblink Details in oracle apps REP-3000: Internal error
starting Oracle Toolkit Rapid Clone adcfgclone.pl
RA-12154 TNS:could not resolve service name ORA-06512: at line ORA-06550:
Clear the temporary tablespace java.io.FileNotFoundExcepti on, Transuction resister is erroring out Getting 41839 41092 40737 FRM-40734 Wh...
Oracle account error ORA_28000 FRM-40735: ZOOM trigger raised unhandled exception... ► May (181) ► April (23) ► March (10) ► February (5) ► January (55) ► 2013 (556) ► 2012 (301) ► 2011 (239) FISH