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

TABLE: PO.PO_HISTORY_POS_ALL

Object Details
Object Name: PO_HISTORY_POS_ALL
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_HISTORY_POS_ALL
Subobject Name:
Status: VALID


Oracle Purchasing uses the table PO_HISTORY_POS_ALL to store a
summarized account of purchase orders that the Purge process deleted.
The primary uses of this table are to ensure the uniqueness of new
purchase order numbers and to provide a history table for reporting
purposes.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 15
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_HISTORY_POS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEGMENT1
ColumnTYPE_LOOKUP_CODE
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
SEGMENT1 VARCHAR2 (30) Yes Key flexfield segment
TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Type of document
VENDOR_ID NUMBER

Supplier unique identifier
RELEASE_NUM NUMBER

Number for the release
VENDOR_NAME VARCHAR2 (80)
Name of the supplier
VENDOR_SITE_CODE VARCHAR2 (15)
Unique identifier for the supplier site
CURRENCY_CODE VARCHAR2 (15)
Unique identifier for the currency
CREATION_DATE DATE

Standard who column - date when this row was created.
PO_TOTAL NUMBER

Total amount of the order
AGENT_NAME VARCHAR2 (240)
Name of buyer
PURGE_NAME VARCHAR2 (15)
Name of the purge process that purged this order
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).
ORG_ID NUMBER

Organization identifier
Query Text

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


SELECT SEGMENT1
,      TYPE_LOOKUP_CODE
,      VENDOR_ID
,      RELEASE_NUM
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      CURRENCY_CODE
,      CREATION_DATE
,      PO_TOTAL
,      AGENT_NAME
,      PURGE_NAME
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
FROM PO.PO_HISTORY_POS_ALL;

Dependencies

[top of page]

PO.PO_HISTORY_POS_ALL does not reference any database object

PO.PO_HISTORY_POS_ALL is referenced by following:

SchemaPO
ViewPO_HISTORY_POS_ALL#