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_ALL

Object Details

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

PO_RELEASES_ALL 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. Each release must have at
least one purchase order shipment (PO_LINE_LOCATIONS_ALL). RELEASE_NUM
is the number you assign to the release.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_RELEASES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PO_RELEASE_ID
PO_RELEASES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID RELEASE_NUM
PO_RELEASES_F1	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DECODE("CONSIGNED_CONSUMPTION_FLAG",'Y',DECODE("CLOSED_CODE",'FINALLY CLOSED',NULL,'Y'),NULL)
PO_RELEASES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AGENT_ID
PO_RELEASES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WF_ITEM_TYPE WF_ITEM_KEY
PO_RELEASES_N20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OTM_RECOVERY_FLAG
PO_RELEASES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
PO_RELEASES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
PO_RELEASES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AUTHORIZATION_STATUS

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 or not
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 or not
ACCEPTANCE_DUE_DATE	DATE			Date the acceptance is due
HOLD_BY	NUMBER	(9)		Unique identifier of the employee who placed the release on hold (Unused since release version 8.0)
HOLD_DATE	DATE			Date the release was placed on hold (Unused since release version 8.0)
HOLD_REASON	VARCHAR2	(240)		Reason the release was placed on hold (Unused since release version 8.0)
HOLD_FLAG	VARCHAR2	(1)		Indicates whether the release is on hold or not
CANCEL_FLAG	VARCHAR2	(1)		Indicates whether the release is cancelled or not
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
AUTHORIZATION_STATUS	VARCHAR2	(25)		Authorization status of the release
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 release is frozen or not
RELEASE_TYPE	VARCHAR2	(25)		Describes whether release is for a blanket or planned purchase order
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
WF_ITEM_TYPE	VARCHAR2	(8)		Approval workflow item type
WF_ITEM_KEY	VARCHAR2	(240)		Approval workflow item key
PCARD_ID	NUMBER	(15)		Unique identifier for the procurement card used for the order
PAY_ON_CODE	VARCHAR2	(25)		Indicator of whether the release will be paid upon receipt
XML_FLAG	VARCHAR2	(3)		Indicator for the delivery option of the PO document is through XML or not. Y if so.
XML_SEND_DATE	DATE			The XML document generation date, if XML delivery option is chosen.
XML_CHANGE_SEND_DATE	DATE			The change XML document generation date, if XML delivery option is chosen.
CONSIGNED_CONSUMPTION_FLAG	VARCHAR2	(1)		Flag indicates that the PO Release is a consumption advice
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
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.
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
TAX_ATTRIBUTE_UPDATE_CODE	VARCHAR2	(15)		Keeps track of create/update actions on this entity
COMM_REV_NUM	NUMBER			Revision Number
OTM_STATUS_CODE	VARCHAR2	(40)		Status of OTM Communication
OTM_RECOVERY_FLAG	VARCHAR2	(1)		Flag to indicate whether OTM communication needs to be recovered

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
,      AUTHORIZATION_STATUS
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CLOSED_CODE
,      FROZEN_FLAG
,      RELEASE_TYPE
,      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
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      PCARD_ID
,      PAY_ON_CODE
,      XML_FLAG
,      XML_SEND_DATE
,      XML_CHANGE_SEND_DATE
,      CONSIGNED_CONSUMPTION_FLAG
,      CBC_ACCOUNTING_DATE
,      CHANGE_REQUESTED_BY
,      SHIPPING_CONTROL
,      CHANGE_SUMMARY
,      VENDOR_ORDER_NUM
,      DOCUMENT_CREATION_METHOD
,      SUBMIT_DATE
,      TAX_ATTRIBUTE_UPDATE_CODE
,      COMM_REV_NUM
,      OTM_STATUS_CODE
,      OTM_RECOVERY_FLAG
FROM PO.PO_RELEASES_ALL;

Dependencies

[top of page]

PO.PO_RELEASES_ALL does not reference any database object

PO.PO_RELEASES_ALL is referenced by following:

PO: PO_RELEASES_ALL#