[Home] [Help] [Dependency Information]
Object Name: | FTE_TENDER_SNAPSHOT |
---|---|
Object Type: | TABLE |
Owner: | FTE |
FND Design Data: | FTE.FTE_TENDER_SNAPSHOT |
Subobject Name: | |
Status: | VALID |
Stores the snapshot of trip stops while tendering
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FTE_TENDER_SNAPSHOT_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LOAD_TENDER_NUMBER
STOP_ID TRIP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_VALUE | VARCHAR2 | (30) | Stores Session Value | |
LOAD_TENDER_NUMBER | NUMBER | Yes | Stores Load Tender Number | |
TRIP_ID | NUMBER | Yes | Stores Id of the trip that is getting tendered | |
STOP_ID | NUMBER | Yes | Stores the stop id of which we are taking the snapshot | |
TOTAL_WEIGHT | NUMBER | Stores total weight at the stop | ||
WEIGHT_UOM | VARCHAR2 | (3) | Stores weight uom | |
TOTAL_VOLUME | NUMBER | Stored total volume at the stop | ||
VOLUME_UOM | VARCHAR2 | (3) | Stores volume uom | |
CREATION_DATE | DATE | Yes | Creation Date | |
CREATED_BY | NUMBER | Yes | Created By | |
LAST_UPDATE_DATE | DATE | Yes | Last update date | |
LAST_UPDATED_BY | NUMBER | Yes | Last updated by | |
LAST_UPDATE_LOGIN | NUMBER | Last update login | ||
PROGRAM_APPLICATION_ID | NUMBER | Program application id | ||
PROGRAM_ID | NUMBER | Program Id | ||
PROGRAM_UPDATE_DATE | DATE | Program update date |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_VALUE
, LOAD_TENDER_NUMBER
, TRIP_ID
, STOP_ID
, TOTAL_WEIGHT
, WEIGHT_UOM
, TOTAL_VOLUME
, VOLUME_UOM
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM FTE.FTE_TENDER_SNAPSHOT;
FTE.FTE_TENDER_SNAPSHOT does not reference any database object
FTE.FTE_TENDER_SNAPSHOT is referenced by following:
|
|
|