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

TABLE: PON.PON_ACCEPTANCES

Object Details
Object Name: PON_ACCEPTANCES
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.PON_ACCEPTANCES
Subobject Name:
Status: VALID


PON_ACCEPTANCES stores auction and RFQ award information by response (quote/bid) item line. Each record in this table represents either an award or rejection decision indicated by the ACCEPTANCE_TYPE column.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_ACCEPTANCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCEPTANCE_ID
PON_ACCEPTANCES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUCTION_HEADER_ID
ColumnAUCTION_LINE_NUMBER
ColumnBID_NUMBER
ColumnLINE_NUMBER
Columns
Name Datatype Length Mandatory Comments
ACCEPTANCE_ID NUMBER
Yes System-generated unique Identifier
AUCTION_HEADER_ID NUMBER

Auction Header Identifier
AUCTION_LINE_NUMBER NUMBER

Auction Line Item Number
BID_NUMBER NUMBER

Bid Number
LINE_NUMBER NUMBER

Auction Line Item Number
ACCEPTANCE_TYPE VARCHAR2 (25)
Acceptance type to indicate if the Bid line is AWARDED or REJECTED
ACCEPTANCE_DATE DATE

Date of Acceptance
REASON VARCHAR2 (4000)
Reason for award or rejection based on the Acceptance Type
AUCTION_CREATION_DATE DATE

Date of auction creation
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
Query Text

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


SELECT ACCEPTANCE_ID
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      LINE_NUMBER
,      ACCEPTANCE_TYPE
,      ACCEPTANCE_DATE
,      REASON
,      AUCTION_CREATION_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM PON.PON_ACCEPTANCES;

Dependencies

[top of page]

PON.PON_ACCEPTANCES does not reference any database object

PON.PON_ACCEPTANCES is referenced by following:

SchemaPON
ViewPON_ACCEPTANCES#