POR_REQ_SPLIT_LINES_GT
Global Temporary tableGlobal Temporary tableGlobal Temporary tableGlobal Temporary tableGlobal Temporary tableGlobal Temporary table
Details
-
Schema: FUSION
-
Object owner: POR
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
POR_REQ_SPLIT_LINES_GT_PK |
REQUISITION_LINE_ID, BID_NUMBER, BID_LINE_NUMBER |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| AUCTION_HEADER_ID | NUMBER | AUCTION_HEADER_ID | ||
| BID_NUMBER | NUMBER | Yes | BID_NUMBER | |
| BID_LINE_NUMBER | NUMBER | Yes | BID_LINE_NUMBER | |
| REQUISITION_HEADER_ID | NUMBER | Yes | REQUISITION_HEADER_ID | |
| REQUISITION_LINE_ID | NUMBER | Yes | REQUISITION_LINE_ID | |
| ALLOCATED_QTY | NUMBER | ALLOCATED_QTY | ||
| NEW_REQ_LINE_ID | NUMBER | NEW_REQ_LINE_ID | ||
| NEW_LINE_NUM | NUMBER | NEW_LINE_NUM | ||
| TOTAL_ALLOC_REQ_LINE_QTY | NUMBER | TOTAL_ALLOC_REQ_LINE_QTY | ||
| REQUISITION_LINE_QTY | NUMBER | REQUISITION_LINE_QTY | ||
| MIN_BID_NUMBER | NUMBER | MIN_BID_NUMBER | ||
| MIN_BID_LINE_NUMBER | NUMBER | MIN_BID_LINE_NUMBER | ||
| RECORD_STATUS | VARCHAR2 | 1 | RECORD_STATUS |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| POR_REQ_SPLIT_LINES_GT_U1 | Unique | BID_NUMBER, BID_LINE_NUMBER, REQUISITION_LINE_ID |
| POR_REQ_SPLIT_LINES_GT_U2 | Unique | REQUISITION_LINE_ID, BID_NUMBER, BID_LINE_NUMBER |