1/27/2021 Oracle Application's Blog: PO base tables in oracle apps r12 Complete Information's: Purchase Order Tables Complete
ation's: Purchase Order Tables Complete Technical Flow
ORACLE APPLICATION'S BLOG
The purpose of this blog , is to do Knowledge sharing with my Followers through my own Experiences. Do your comments , feedback and your
suggestions to keep this going.
Fusion E-Books Workflows OAF Interfaces Scripts XML Posts Fusion Technical Fusion Financial EBS R12
Thursday, 31 May 2018
PO base tables in oracle apps r12 Complete Information's: Free Oracle Fusion
Certifications Dump's (Click to
Purchase Order Tables Complete Technical Flow Download)
po base tables in oracle apps r12 Complete Information's
po_headers_all
This is the Purchase Order Headers Table in Oracle Apps. Here below you will find po_headers_all table columns
details.
We can find the po number in po_headers_all in Segment1 Column of PO_HEADERS_ALL table.
Oracle Interview's Question
Series
This table have informa ons like PO Number, PO Type , Vendor Id ,Vendor Site Id,Currency ,PO Status.
TOP 21 Oracle Fusion HCM Interview
Questions
Complete Tax Setups in Oracle Fusion
Top 50 oracle reports interview
questions
33 Most Important Oracle Fusion fixed
assets interview questions
TOP 33 Most Important Oracle Apps
PO_LINES_ALL Technical Interview Questions
25 Most Important Oracle receivable
Here's Below we can find po_lines_all table descrip on interview questions
21 Most Important Oracle r12 Payables
Interview Questions
This is the PO Lines Tables in Oracle Apps. In This Table We have ITem_Id , Qty , ITem Descrip on ,UOM , TOP 20 general ledger interview
UNIT_PRICE and many other important Columns. questions in oracle apps r12
TOP 23 Most Important Oracle Fusion
Interview Questions
TOP 23 Most Important oaf interview
questions
Online Oracle Courses (Free of
PO_DISTRIBUTIONS_ALL Cost)
Complete Tax Setups in Oracle Fusion
Learn Tax Implementation in Oracle
Fusion
Learn P2P Cycle in Oracle Fusion
This Contains PO distribu ons Data. It handles the GL Account for the Line and Ship to loca ons too. Learn Oracle Reports XML Tutorial
https://rpforacle.blogspot.com/2018/05/po-base-tables-in-oracle-apps-r12.html 1/5
1/27/2021 Oracle Application's Blog: PO base tables in oracle apps r12 Complete Information's: Purchase Order Tables Complete Technical Flow
Learn Oracle Fusion Custom Roles
Tutorial
Learn Oracle Fusion Technical Online
Learn Oracle Fusion/cloud Financials
Online
Learn Oracle Cloud BPM Online
po_line_locations_all Learn Complete OAF Step by Step
Online
This is the PO Lines Tables in Oracle Apps. In This Table We have ITem_Id , Qty , ITem Descrip on ,UOM , Learn Oracle Workflow Builder Online
UNIT_PRICE and many other important Columns. This table also provide informa on about total received qty
against PO line and Total Invoiced Quan ty too.
Learn Fusion Financial's
1,499(INR) Only
SQL Query To find the PO Lines from the Purchase Order
select A2.* from PO_HEADERS_ALL A1,PO_LINES_ALL A2
WHERE A1.PO_HEADER_ID=A2.PO_HEADER_ID
Click To Know More
AND A1.SEGMENT1=:PO_NUMBER
Online Fusion Financials
AND A1.ORG_ID=:ORG_ID
Training Click To Know More
SQL Query To find the PO Distributions Data from the
Purchase Order
select A2.* from PO_HEADERS_ALL A1,PO_DISTRIBUTIONS_ALL A2
Online Fusion Financials Training Click To
Know More
WHERE A1.PO_HEADER_ID=A2.PO_HEADER_ID
AND A1.SEGMENT1=:PO_NUMBER
For Oracle Issues Help
AND A1.ORG_ID=:ORG_ID
SQL Query To find the PO Vendor Name from the Purchase
For Oracle Issues Help
Order
Oracle Cloud Instance Access
(Click to Know More)
select A2.* from PO_HEADERS_ALL A1,AP_SUPPLIERS A2
WHERE A1.VENDOR_ID=A2.VENDOR_ID
https://rpforacle.blogspot.com/2018/05/po-base-tables-in-oracle-apps-r12.html 2/5
1/27/2021 Oracle Application's Blog: PO base tables in oracle apps r12 Complete Information's: Purchase Order Tables Complete Technical Flow
AND A1.SEGMENT1=:PO_NUMBER
AND A1.ORG_ID=:ORG_ID
SQL Query To find the PO Vendor SITE from the Purchase
Order
Contact Me
select A2.* from PO_HEADERS_ALL A1,AP_SUPPLIER_SITES_ALL A2 [email protected]
Most Viewed Posts
WHERE A1.VENDOR_SITE_ID=A2.VENDOR_SITE_ID Report Bursting in oracle fusion
AR to GL reconciliation in oracle apps
r12
Set the override email address in Oracle
AND A1.SEGMENT1=:PO_NUMBER Fusion
How to Create PO and Receiving
Inquiry(View Only) Role in Oracle
Fusion
AND A1.ORG_ID=:ORG_ID
How to create a new Oracle apps Data
base source to Design the BIP reports
How to add hyperlink in the email body
using Bursting in Oracle Cloud BIP
reports
What is Rapid Implementation in Oracle
Cloud : Rapid Implementation Data
Upload Process in Oracle Fusion
Drill Down OTBI reports to Navigate
Directly in to Oracle Cloud Payment
Page
SQL Query To find the PO Lines Inventory Items from the How to create vacation rules in Oracle
cloud
Purchase Order TOP 30 Most Important OAF Interview
Questions
select A2.* from PO_HEADERS_ALL A1,PO_LINES_ALL A2,MTL_SYSTEM_ITEMS_B A3 ,PO_DISTRIBUTIONS_ALL A4
WHERE A1.PO_HEADER_ID=A2.PO_HEADER_ID
AND A1.PO_HEADER_ID=A4.PO_HEADER_ID
AND A2.PO_LINE_ID=A4.PO_LINE_ID
AND A2.ITEM_ID=A3.INVENTORY_ITEM_ID
AND A3.ORGANIZATION_ID=A4.DESTINATION_ORGANIZATION_ID
AND A1.SEGMENT1=:PO_NUMBER
AND A1.ORG_ID=:ORG_ID
SQL Query To find the PO Buyers from the Purchase Order
https://rpforacle.blogspot.com/2018/05/po-base-tables-in-oracle-apps-r12.html 3/5
1/27/2021 Oracle Application's Blog: PO base tables in oracle apps r12 Complete Information's: Purchase Order Tables Complete Technical Flow
SELECT A2.* FROM PO_HEADERS_ALL A1,PER_ALL_PEOPLE_F A2
WHERE A1.AGMENT_ID=A2.PERSON_ID
AND A1.SEGMENT1=:PO_NUMBER
AND A1.ORG_ID=:ORG_ID
SQL Query To find the PO Receipts from the Purchase Order
po receipt tables in oracle apps r12
select a2.* from rcv_shipment_lines a1,rcv_shipment_headers a2 ,PO_HEADERS_ALL A3
where 1=1
and a1.SHIPMENT_HEADER_ID=a2.SHIPMENT_HEADER_ID
and a1.po_header_id=a3.po_header_id
and a3.SEGMENT1=:PO_NUMBER
SQL Query To find the PO Matching AP Invoice Numbers
from the Purchase Order
select a3.* from ap_invoice_lines_all a1,ap_invoices_all a2,PO_HEADERS_ALL A3
where a1.po_header_id=a1.po_header_id
and a1.invoice_id=a2.invoice_id
and a3.SEGMENT1=:PO_NUMBER
PO base tables in oracle apps r12 Complete Information's:
Purchase Order Tables Complete Technical Flow
at 21:55 (2018-05-31T21:55:00-07:00)
Labels: _headers_all table columns details, po base tables in oracle apps r12, po receipt tables in oracle apps r12,
PO_DISTRIBUTIONS_ALL, po_headers_all, po_line_locations_all, PO_LINES_ALL
2 comments:
arif said...
https://rpforacle.blogspot.com/2018/05/po-base-tables-in-oracle-apps-r12.html 4/5
1/27/2021 Oracle Application's Blog: PO base tables in oracle apps r12 Complete Information's: Purchase Order Tables Complete Technical Flow
Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check
oracleappstechnical.com
4 June 2019 at 00:26
Rifath said...
Brilliant blog I visit this blog it's incredibly awesome. Curiously, in this blog content formed doubtlessly
and sensible. The substance of information is helpful.
Oracle Fusion HCM Online Training
15 November 2019 at 03:10
Post a comment
Enter your comment...
Comment as: talha.tahirrrr@g Sign out
Publish Preview Notify me
Newer Post Home Older Post
https://rpforacle.blogspot.com/2018/05/po-base-tables-in-oracle-apps-r12.html 5/5
