Monday, 13 May 2013

Purchasing Entity Base Tables

Buyer/Requester base table :
Select * from apps.HR_EMPLOYEES;
Select * from apps.PO_AGENTS;

Payment Term base table :
Select * from apps.AP_TERMS;

FOB Term base table :
select * from apps.FND_LOOKUP_VALUES;

Currency base table :
select * from apps.FND_CURRENCIES;

Location base table :
select * from apps.HR_LOCATIONS_ALL;

Operating Unit base table :
select * from apps.HR_OPERATING_UNITS;

Unit Of Measure base table :
select * from apps.MTL_UNITS_OF_MEASURE;

Item base table :
select * from apps.MTL_SYSTEM_ITEMS;

Supplier base table :
select * from apps.PO_VENDORS;

Supplier Sites base table :
select * from apps.PO_VENDOR_SITES_ALL;

No comments:

Post a Comment