eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PO.PO_RELEASES_ARCHIVE_ALL

Object Details

Object Name:	PO_RELEASES_ARCHIVE_ALL
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_RELEASES_ARCHIVE_ALL
Subobject Name:
Status:	VALID

PO_RELEASES_ARCHIVE_ALL contains archived release header information.
Oracle Purchasing only archives releases for the following documents:
.
{{"bul:1"}}Planned purchase order releases {{"bul:1"}}Blanket purchase
order releases
.
{{"bodytext"}}When you modify a release, Oracle Purchasing will
archive it after you (re)approve the release or after you print it
(this depends on the purchasing system options). You can retrieve
revisions of the releases using this table.
.
The latest archived revision will have LATEST_EXTERNAL_FLAG set to 'Y'.
.
You need one row for each release you archive. Each row contains the
same information as the PO_RELEASES_ALL table. Oracle Purchasing uses
this information to ensure you keep copies of your legal documents.
.
Oracle Purchasing does not currently read or retrieve information in
this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_RELEASES_ARCHIVE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PO_RELEASE_ID REVISION_NUM
PO_RELEASES_ARCHIVE_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID RELEASE_NUM REVISION_NUM
PO_RELEASES_ARCHIVE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AGENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PO_RELEASE_ID	NUMBER		Yes	Release unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PO_HEADER_ID	NUMBER		Yes	Document header unique identifier
RELEASE_NUM	NUMBER		Yes	Release number
AGENT_ID	NUMBER	(9)	Yes	Buyer unique identifier
RELEASE_DATE	DATE		Yes	Date of the release
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
REVISION_NUM	NUMBER			Release revision number
REVISED_DATE	DATE			Last revision date
APPROVED_FLAG	VARCHAR2	(1)		Indicates whether the release is approved
APPROVED_DATE	DATE			Date the release was approved
PRINT_COUNT	NUMBER			Number of times the release was printed
PRINTED_DATE	DATE			Date the release was printed
ACCEPTANCE_REQUIRED_FLAG	VARCHAR2	(1)		Indicates whether an acceptance is required
ACCEPTANCE_DUE_DATE	DATE			Date the acceptance is due
HOLD_BY	NUMBER	(9)		No longer used
HOLD_DATE	DATE			No longer used
HOLD_REASON	VARCHAR2	(240)		No longer used
HOLD_FLAG	VARCHAR2	(1)		Indicates whether the release is on hold
CANCEL_FLAG	VARCHAR2	(1)		Indicates whether the release is cancelled
CANCELLED_BY	NUMBER	(9)		Unique identifier of the employee who cancelled the release
CANCEL_DATE	DATE			Date the release was cancelled
CANCEL_REASON	VARCHAR2	(240)		Reason for cancellation
FIRM_STATUS_LOOKUP_CODE	VARCHAR2	(25)		Firm status
FIRM_DATE	DATE			Date the release becomes firmed
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
LATEST_EXTERNAL_FLAG	VARCHAR2	(1)		Indicates whether this is the latest archived revision
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		United States standard general ledger transaction code
GOVERNMENT_CONTEXT	VARCHAR2	(30)		USSGL descriptive flexfield context column
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
CLOSED_CODE	VARCHAR2	(25)		Describes the closure status of the release
FROZEN_FLAG	VARCHAR2	(1)		Indicates whether the document is frozen
RELEASE_TYPE	VARCHAR2	(25)		Describes whether release is for a blanket or planned purchase order
AUTHORIZATION_STATUS	VARCHAR2	(25)		Authorization status of the release
NOTE_TO_VENDOR	VARCHAR2	(480)		Note to the supplier
ORG_ID	NUMBER			Organization identifier
EDI_PROCESSED_FLAG	VARCHAR2	(1)		This flag is used by e-Commerce Gateway to identify documents that have been sent via EDI. This flag is updated to Y by the e-Commerce Gateway extraction routines.
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality
PCARD_ID	NUMBER	(15)		Unique identifier for the procurement card used on the release
WF_ITEM_TYPE	VARCHAR2	(8)		Approval workflow item type
WF_ITEM_KEY	VARCHAR2	(240)		Approval workflow item key
PAY_ON_CODE	VARCHAR2	(25)		Indicator of whether the release will be paid upon receipt.
XML_FLAG	VARCHAR2	(3)		Indicator if the user has chosen XML delivery option for the release PO document. Y if selected.
XML_SEND_DATE	DATE			Date on which XML was generated for a new release, if XML delivery was chosen.
XML_CHANGE_SEND_DATE	DATE			Date on which XML was generated for the last changed release, if XML delivery was chosen.
CONSIGNED_CONSUMPTION_FLAG	VARCHAR2	(1)		Consigned Consumption Flag
SHIPPING_CONTROL	VARCHAR2	(30)		Indicator of who is responsible for arranging transportation
CHANGE_SUMMARY	VARCHAR2	(2000)		Description of changes made. This information is entered by the Buyer when submitting the document for approval and may be used in generating an amendment document.
CBC_ACCOUNTING_DATE	DATE			Column used to store the accounting action date for dual budgetary controls
CHANGE_REQUESTED_BY	VARCHAR2	(20)		Column used to store the change request userid
VENDOR_ORDER_NUM	VARCHAR2	(25)		Supplier's order number for release
DOCUMENT_CREATION_METHOD	VARCHAR2	(30)		Document Creation Method - Autocreate, Enter PO, copy, etc...
SUBMIT_DATE	DATE			Date when release was first submitted for approval

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PO_RELEASE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PO_HEADER_ID
,      RELEASE_NUM
,      AGENT_ID
,      RELEASE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REVISION_NUM
,      REVISED_DATE
,      APPROVED_FLAG
,      APPROVED_DATE
,      PRINT_COUNT
,      PRINTED_DATE
,      ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      HOLD_BY
,      HOLD_DATE
,      HOLD_REASON
,      HOLD_FLAG
,      CANCEL_FLAG
,      CANCELLED_BY
,      CANCEL_DATE
,      CANCEL_REASON
,      FIRM_STATUS_LOOKUP_CODE
,      FIRM_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LATEST_EXTERNAL_FLAG
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CLOSED_CODE
,      FROZEN_FLAG
,      RELEASE_TYPE
,      AUTHORIZATION_STATUS
,      NOTE_TO_VENDOR
,      ORG_ID
,      EDI_PROCESSED_FLAG
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      PCARD_ID
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      PAY_ON_CODE
,      XML_FLAG
,      XML_SEND_DATE
,      XML_CHANGE_SEND_DATE
,      CONSIGNED_CONSUMPTION_FLAG
,      SHIPPING_CONTROL
,      CHANGE_SUMMARY
,      CBC_ACCOUNTING_DATE
,      CHANGE_REQUESTED_BY
,      VENDOR_ORDER_NUM
,      DOCUMENT_CREATION_METHOD
,      SUBMIT_DATE
FROM PO.PO_RELEASES_ARCHIVE_ALL;

Dependencies

[top of page]

PO.PO_RELEASES_ARCHIVE_ALL does not reference any database object

PO.PO_RELEASES_ARCHIVE_ALL is referenced by following:

APPS: PO_RELEASES_ARCHIVE; PO_RELEASES_ARCHIVE_ALL