[Home] [Help] [Dependency Information]
Object Name: | PO_REQ_SPLIT_LINES_GT |
---|---|
Object Type: | TABLE |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
For Internal Use Only: This table is used for internal processing of data for requisition splitting for Consume Req Demand Project. Oracle Sourcing inserts data into this table.
PO.PO_REQ_SPLIT_LINES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUCTION_HEADER_ID | NUMBER | |||
BID_NUMBER | NUMBER | |||
BID_LINE_NUMBER | NUMBER | |||
REQUISITION_HEADER_ID | NUMBER | |||
REQUISITION_LINE_ID | NUMBER | |||
ALLOCATED_QTY | NUMBER | |||
NEW_REQ_LINE_ID | NUMBER | |||
NEW_LINE_NUM | NUMBER | |||
TOTAL_ALLOC_REQ_LINE_QTY | NUMBER | |||
REQUISITION_LINE_QTY | NUMBER | |||
MIN_BID_NUMBER | NUMBER | |||
RECORD_STATUS | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT AUCTION_HEADER_ID
, BID_NUMBER
, BID_LINE_NUMBER
, REQUISITION_HEADER_ID
, REQUISITION_LINE_ID
, ALLOCATED_QTY
, NEW_REQ_LINE_ID
, NEW_LINE_NUM
, TOTAL_ALLOC_REQ_LINE_QTY
, REQUISITION_LINE_QTY
, MIN_BID_NUMBER
, RECORD_STATUS
FROM PO.PO_REQ_SPLIT_LINES_GT;
PO.PO_REQ_SPLIT_LINES_GT does not reference any database object
PO.PO_REQ_SPLIT_LINES_GT is referenced by following:
|
|
|