Home » Tables » Po Releases All Table In R12

Po Releases All Table In R12

In Lines table I have 4 lines, Line_num 1,2,3,4 for this particular PO number 1000 with header_id 550.

My requirement is, when iam looking to get the release num from PO_RELEASES_ALL for this particular PO number by connecting po_header_id 550 with po_header_id in PO_RELEASES_ALL , i am getting 9 release numbers.

plz clarify me, is these release.

Table Descriptions The following section describes the tables and the columns that Payables supports for matching to purchase orders from your non- Oracle purchase system.

We describe how the columns are used and, if a column is required, the values you must load to successfully perform matching.

1.

Po_releases_all has the release number and that table is tied to po_line_locations_all.

The po_line_locations_all will give you delivery details such as date /qty.

2.

Yes.

But for that to happen, the three items must be on the same blanket po.

Changed Tables in R12 Payables.

Table Name.

Invoice Lines, eBusiness Tax, Payments, SLA, Complex Work POs# Numerous columns were added to this table due to almost all the projects done for R12 , for list of columns added please refer to the TDD of the respective projects.

AP_INVOICE_DISTRIBUTIONS_ALL.

14/04/2013 Table Name : PO_RELEASES_ALL Columns: PO_RELEASE_ID PO_HEADER_ID RELEASE_NUM AGENT_ID RELEASE_DATE Contains information about blanket and planned purchase order releases.

You need one row for each release you issue for a blanket or planned purchase order.

Each row includes the buyer, date, release status, and release number.

Table Name : PO_RELEASES_ALL Columns: PO_RELEASE_ID PO_HEADER_ID RELEASE_NUM AGENT_ID RELEASE_DATE Contains information about blanket and planned purchase order releases.

You need one row for each release you issue for a blanket or planned purchase order.

Each row includes the buyer, date, release status, and release number.

I want to know the meanings of values of approved_flag values in oracle payables ( PO_RELEASES_ALL table ).

I’ve searched on internet for that question but sadly, no results.

Could anyone who know about it tell me or suggest me a reference?

These are all values of approved_flag which are in my database.

1.

null 2.

R 3.

Y 4.

N 5.

F Thank you so much!, 7.

PO_RELEASES_ALL : This table stores information related to planned and blanket Purchase Order releases.

Each row includes the buyer, date, release status, and release number.

Each release must have at least one purchase order shipment.

8.

PO_VENDOR_CONTACTS: This table stores information about contacts related to Supplier site.

08/05/2012 Thanks Hussein.

Yes, I’ve checked the document you recomend, but the problem seems to be when I try to use po_releases, the synomy) and I don’t know why it work with the _all table but not work with the synonym.

po releases all table in r12