Logo

Welcome

Welcome to HandsonERP.com

This site provides video based training of Oracle Financials.
Learn concepts and functionality in a step by step manner.

Login

HandsonERP - Oracle E-Business Suite Training
Welcome, Guest
Please Login or Register.    Lost Password?
Please post inquiries related to lessons content here. All questions and inquiries related to the website should be submitted directly using Contact form in the top menu.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Supplier Site Form
#1899
dave (User)
Expert Boarder
Posts: 109
graphgraph
User Offline Click here to see the profile of this user
Supplier Site Form 15 Years, 2 Months ago  
Hi Hasan:

Can you pls advice in what table the Supplier site name is stored that we specify on Supplier site form.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1900
pdhir (User)
Junior Boarder
Posts: 22
graphgraph
User Offline Click here to see the profile of this user
Re:Supplier Site Form 15 Years, 2 Months ago  
AP_SUPPLIER_SITES_ALL > Vendor_site_code is column name
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#1905
handsonerp (Admin)
Admin
Posts: 1989
graph
User Offline Click here to see the profile of this user
Re:Supplier Site Form 15 Years, 2 Months ago  
Here are useful tables names related to suppliers in R12.
HZ_PARTIES - Parties
HZ_PARTY_SITES_ALL - Party Sites
HZ_PARTY_USG_ASSIGNMENTS - Party Usages
HZ_ORGANIZATION_PROFILES - Additional Supplier Information
IBY_EXTERNAL_PAYEES_ALL - Supplier Payment Details
AP_SUPPLIERS - Suppliers
AP_SUPPLIER_SITES_ALL - Supplier Sites
POS_SUPPLIER_MAPPINGS - Holds mapping between HZ_PARTIES.PARTY_ID and AP_SUPPLIERS.VENDOR_ID
ZX_PARTY_TAX_PROFILE - Taxation Related Details
PO_VENDORS - This is a view in R12. Joins AP_SUPPLIERS and HZ_PARTIES
PO_VENDOR_SITES_ALL - This is a view in R12.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
 
Copyright © 2009
SAP Training| Online Information Technology Training| Free IT Tutorials| Oracle Financials| Oracle Applications Training| Free Tutorials| Free Training| Excel Tutorial| Information Technology Tutorials| SQL Tutorial| PL/SQL Tutorial| Project Management Training| JDeveloper Tutorial| Oracle DBA Tutorial| Ruby on Rails Tutorial| Resources