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

TABLE: FTE.FTE_TENDER_SNAPSHOT

Object Details
Object Name: FTE_TENDER_SNAPSHOT
Object Type: TABLE
Owner: FTE
FND Design Data: TableFTE.FTE_TENDER_SNAPSHOT
Subobject Name:
Status: VALID


Stores the snapshot of trip stops while tendering


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_TENDER_SNAPSHOT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOAD_TENDER_NUMBER
ColumnSTOP_ID
ColumnTRIP_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

FTE.FTE_TENDER_SNAPSHOT does not reference any database object

FTE.FTE_TENDER_SNAPSHOT is referenced by following:

SchemaFTE
ViewFTE_TENDER_SNAPSHOT#