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

TABLE: PON.PON_BID_BACKING_REQUISITIONS

Object Details
Object Name: PON_BID_BACKING_REQUISITIONS
Object Type: TABLE
Owner: PON
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_BID_BACK_REQUISITIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUCTION_HEADER_ID
ColumnAUCTION_LINE_NUMBER
ColumnBID_NUMBER
ColumnBID_LINE_NUMBER
ColumnREQUISITION_LINE_ID
Columns
Name Datatype Length Mandatory Comments
AUCTION_HEADER_ID NUMBER
Yes
AUCTION_LINE_NUMBER NUMBER
Yes
BID_NUMBER NUMBER
Yes
BID_LINE_NUMBER NUMBER
Yes
REQUISITION_LINE_ID NUMBER
Yes
REQUISITION_HEADER_ID NUMBER

REQUISITION_QUANTITY NUMBER

REQUISITION_NUMBER VARCHAR2 (20)
DESTINATION_TYPE_CODE VARCHAR2 (25)
Stores Destination Type Code of the requisition Line
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      BID_LINE_NUMBER
,      REQUISITION_LINE_ID
,      REQUISITION_HEADER_ID
,      REQUISITION_QUANTITY
,      REQUISITION_NUMBER
,      DESTINATION_TYPE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PON.PON_BID_BACKING_REQUISITIONS;

Dependencies

[top of page]

PON.PON_BID_BACKING_REQUISITIONS does not reference any database object

PON.PON_BID_BACKING_REQUISITIONS is referenced by following:

SchemaPON
ViewPON_BID_BACKING_REQUISITIONS#