Key Oracle Applications Purchasing Tables

Following are some of the most frequently used tables in oracle Purchasing. 

Table Name : PO_REQUISITION_HEADERS_ALL
Important Columns:
REQUISITION_HEADER_ID
PREPARER_ID
SEGMENT1
SUMMARY_FLAG
ENABLED_FLAG


Segment1: Is the system–assigned number you use to identify in forms and reports?

PO_REQUISITION_HEADERS_ALL Stores information about requisition headers.  Each row contains the requisition number, preparer, status, and description. SEGMENT1 is the number you use to identify the requisition in forms and reports (unique).

Table Name : PO_REQUISITION_LINES_ALL

Important Columns:
REQUISITION_LINE_ID
REQUISITION_HEADER_ID
LINE_NUM
LINE_TYPE_ID
CATEGORY_ID
ITEM_DESCRIPTION
UNIT_MEAS_LOOKUP_CODE
UNIT_PRICE, QUANTITY
DELIVER_TO_LOCATION_ID
TO_PERSON_ID
SOURCE_TYPE_CODE


PO_REQUISITION_LINES_ALL Stores information about requisition-lines.It contains Line number, item number, item category, item description, need–by date, deliver–to location, item quantities, units, prices, requestor, notes, and suggested supplier information for the requisitions created. 

Table Name : PO_HEADERS_ALL

Important Columns:
PO_HEADER_ID
AGENT_ID
TYPE_LOOKUP_CODE
SEGMENT1
SUMMARY_FLAG
ENABLED_FLAG


PO_HEADERS_ALL stores the Information for your purchasing documents. There are six types of documents that use PO_HEADERS_ALL. RFQs, Quotations, Standard purchase orders, planned purchase orders, Blanket purchase orders, Contracts can uniquely identify a row in PO_HEADERS_ALL using SEGMENT1 and TYPE_LOOKUP_CODE or using PO_HEADER_ID.

Table Name : PO_LINES_ALL

Important Columns:
PO_LINE_ID
PO_HEADER_ID
LINE_TYPE_ID
LINE_NUM


PO_LINES_ALL Stores current information about each purchase order line. CONTRACT_NUM references a contract purchase order from a standard purchase order line.

Table Name : PO_VENDORS

Important Columns:
VENDOR_ID
VENDOR_NAME
SEGMENT1
SUMMARY_FLAG
ENABLED_FLAG


PO_VENDORS stores information about your suppliers. Purchasing, Receiving, Payment, Accounting, Tax, Classification, and General Information.

Table Name : PO_VENDOR_SITES_ALL
Important Columns:
VENDOR_SITE_ID
VENDOR_ID
VENDOR_SITE_CODE


PO_VENDOR_SITES_ALL stores information about the supplier sites. Each row includes the site address, supplier reference, purchasing, payment, bank, and general information.

Table Name : PO_DISTRIBUTIONS_ALL

Important Columns:
PO_DISTRIBUTION_ID
PO_HEADER_ID
PO_LINE_ID
LINE_LOCATION_ID
SET_OF_BOOKS_ID
CODE_COMBINATION_ID
QUANTITY_ORDERED
DISTRIBUTION_NUM


PO_DISTRIBUTIONS_ALL contains accounting distribution information for a purchase order shipment line. It includes the Destination Type, Requestor ID, Quantity Ordered and Deliver–To Location for the distribution. You need one row for each distribution line you attach to a purchase order shipment.

There are 4 - types of documents using distributions in Oracle Purchasing:
· Standard Purchase Orders
· Planned Purchase Orders
· Planned Purchase Order Releases
· Blanket Purchase Order Releases

Table Name : PO_RELEASES_ALL

Important Columns:
PO_RELEASE_ID
PO_HEADER_ID
RELEASE_NUM
AGENT_ID
RELEASE_DATE


PO_RELEASES_ALL Contains information about blanket and planned purchase order releases. Each row includes the buyer, date, release status, and release number. Each release must have at least one purchase order shipment.

Table Name : PO_VENDOR_CONTACTS
Important Columns:
VENDOR_CONTACT_ID
VENDOR_SITE_ID


PO_VENDOR_CONTACTS stores information about contacts for a supplier-site.  
Each row includes the contact name and site.

Table Name : PO_ACTION_HISTORY

Important Columns:
OBJECT_ID
OBJECT_TYPE_CODE
OBJECT_SUB_TYPE_CODE
SEQUENCE_NUM


PO_ACTION_HISTORY stores information about the approval and control history of your purchasing documents. The table stores one record for each approval or control action an employee takes on a purchase order, purchase agreement, release or requisition.

Table Name : PO_REQ_DISTRIBUTIONS_ALL
Important Columns:
DISTRIBUTION_ID
REQUISITION_LINE_ID
SET_OF_BOOKS_ID
CODE_COMBINATION_ID
REQ_LINE_QUANTITY
DISTRIBUTION_NUM


PO_REQ_DISTRIBUTIONS_ALL stores information about the accounting distributions associated with each requisition line.

Table Name : PO_LINE_LOCATIONS_ALL

Important Columns:
LINE_LOCATION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
PO_HEADER_ID
PO_LINE_ID
SHIPMENT_TYPE


PO_LINE_LOCATIONS_ALL Contains information about purchase order shipment schedules and blanket agreement price breaks. There exist one row for each schedule or price break you attach to a document line. There are 7- Types of documents that use shipment schedules:
· RFQs
· Quotations
· Standard Purchase Orders
· Planned Purchase Orders
· Planned Purchase Order Releases
· Blanket Purchase Orders
· Blanket Purchase Order Releases


Each row includes the location, quantity, and dates for each shipment schedule. Oracle Purchasing uses this information to record delivery schedule information for purchase orders, and price break information for blanket purchase orders, quotations and RFQs

Most Useful Oracle Apps Articles:

  1. Types Of Tables In Oracle Applications
  2. Oracle Applications Technical Questions And Answers
  3. Oracle Apps AOL and Sysadmin Interview Questions And Answers
  4. Oracle Apps AR Module Interview Questions And Answers
  5. Oracle Financials Interview Questions And Answers
  6. Oracle Purchasing Interview Questions And Answers
  7. Oracle R12 Tables and Views Changes
  8. Purpose of MO_GLOBAL.SET_POLICY_CONTEXT

COMMENTS

Name

Advance Table In OAF,1,AOL Concepts,18,AP Holds,1,Apps Initialization,1,Blanket Purchase Orders,1,Blanket Releases,1,Careers,9,Common Errors and Solutions,2,Concurrent Programs,10,Contract Purchase Orders,1,Corporate Culture,3,Corporate Ladder,3,Customer Interface,3,Customization,1,De-Normalization,1,EAM,1,EBS Tutorials,10,Education,16,Emterprise Asset Management,1,English,1,Enterprise Asset Management,1,Entrepreneur,1,Error Fixes,1,Executables,2,Extension,1,fnd_user,1,FNDLOAD,1,Global Agreements,1,Guest Posts,7,Handy Scripts,63,Health Tips,1,Important Apps Queries,1,Infographic,3,Interview Preparation,57,Interview Q/A,57,Inventory Org ID,1,Iproc,4,Iprocurement,4,IT,3,jDeveloper,1,Job Search,1,Key Tables In Oracle Apps,5,Learning English,1,MDS,1,Metadata Tables,2,Multi Org Architecture,2,Normalization,1,O2C,1,OAF Interview,49,OAF Personalization,1,OAF Tutorials,52,Operating Unit,1,Oracle Alerts,1,Oracle AP,11,Oracle APIs,4,Oracle Application Object Library,19,Oracle Applications,10,Oracle Apps,2,Oracle Apps Interviews,29,Oracle Apps Tips,8,Oracle Apps Tutorials,97,Oracle AR,18,Oracle Assets,2,Oracle Dabase Structure,2,Oracle Database Architecture,2,Oracle Database Key Tables,3,Oracle EAM,2,Oracle EBS,5,Oracle Financials,2,Oracle Forms And Reports,17,Oracle Forms Interview Questions,6,Oracle Forms Tutorials,6,Oracle GL,4,Oracle Holds,1,Oracle HRMS,10,Oracle Human Resources,1,Oracle Inventory,4,Oracle Payables,1,Oracle Payroll,1,Oracle POTutorials,1,Oracle Purchasing,7,Oracle Reports Interview,9,Oracle Reports Tutorials,3,Oracle System Administrator,4,Oracle Workflow,3,Order Management,2,Organization ID,3,Organizations,3,Performance Tuning,2,Personalization,1,PL/SQL Block,1,PL/SQL Interview Questions,11,PL/SQL Scripts,44,PL/SQL Tutorials,53,Planned Purchase Orders,1,PO,1,PO Action History,1,PO_ACTION_HISTORY,1,POracle Purchasing,1,PR,1,Procedures And Functions,2,Profile Options,2,Purchase Orders,1,Purchase Requisition,2,Receipts,1,Request Groups,1,Responsibility,1,Shell Script,1,SOA Tutorials,4,Social Media,1,Software Industry,2,Software Tools,1,SQL And PL/SQL Interview,38,SQL Interview,51,SQL Scripts,38,SQL Tutorials,43,Standard Purchase Orders,1,Troubleshooting,1,Unexpected error,1,Unix/Linux Commands,3,User,1,Value Sets,1,Weblogic,1,XML Publisher,3,
ltr
item
Oracle Apps Guy: Key Oracle Applications Purchasing Tables
Key Oracle Applications Purchasing Tables
Oracle Apps Guy
https://www.oracleappsguy.com/2011/09/key-oracle-applications-purchasing.html
https://www.oracleappsguy.com/
https://www.oracleappsguy.com/
https://www.oracleappsguy.com/2011/09/key-oracle-applications-purchasing.html
true
4186973960539901882
UTF-8
Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy