eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FTE.FTE_DELIVERY_PROOF

Object Details

Object Name:	FTE_DELIVERY_PROOF
Object Type:	TABLE
Owner:	FTE
FND Design Data:	FTE.FTE_DELIVERY_PROOF
Subobject Name:
Status:	VALID

This table holds the POD portion of the ShowShipment message

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_DELIVERY_PROOF_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
FTE_DELIVERY_PROOF_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary Key
RECEIVED_DATE	DATE			Received Date
NAME1	VARCHAR2	(50)
SHIP_UNIT_QUANTITY	NUMBER			Ship Unit Quantity
SHIP_UNIT_UOM	VARCHAR2	(30)		Ship Unit Unit of Measure
NOTES1	VARCHAR2	(2000)		Notes
NOTES2	VARCHAR2	(2000)		Notes
NOTES3	VARCHAR2	(2000)		Notes
NOTES4	VARCHAR2	(2000)		Notes
NOTES5	VARCHAR2	(2000)		Notes
NOTES6	VARCHAR2	(2000)		Notes
NOTES7	VARCHAR2	(2000)		Notes
NOTES8	VARCHAR2	(2000)		Notes
NOTES9	VARCHAR2	(2000)		Notes
SHIP_UNIT_SEQ	NUMBER			Ship Unit Sequence Number
SHIP_UNIT_TOTAL	NUMBER			Ship Unit Total (highest sequence number)
CREATED_BY	NUMBER			Created by
CREATION_DATE	DATE			Creation Date
LAST_UPDATED_BY	NUMBER			Last Updated By
LAST_UPDATE_DATE	DATE			Last Update Date
LAST_UPDATE_LOGIN	NUMBER			Last Update Login
TRANSACTION_ID	NUMBER			Transaction ID FK reference to Shipment Status Headers table
TRACKING_ID	VARCHAR2	(30)		Tracking Id used in message
TRACKING_ID_TYPE	VARCHAR2	(50)		Tracking Id Type
CONSIGNEE_NAME	VARCHAR2	(50)		Name of recipient
STATUS	VARCHAR2	(20)		Status of the Delivered Shipment
SHIPMENT_WEIGHT	NUMBER			Weight of the Shipment
SHIPMENT_VOLUME	NUMBER			Volume of the Shipment
LOCATION	VARCHAR2	(500)		Location where Shipment was received by the Consignee

Query Text

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


SELECT ID
,      RECEIVED_DATE
,      NAME1
,      SHIP_UNIT_QUANTITY
,      SHIP_UNIT_UOM
,      NOTES1
,      NOTES2
,      NOTES3
,      NOTES4
,      NOTES5
,      NOTES6
,      NOTES7
,      NOTES8
,      NOTES9
,      SHIP_UNIT_SEQ
,      SHIP_UNIT_TOTAL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TRANSACTION_ID
,      TRACKING_ID
,      TRACKING_ID_TYPE
,      CONSIGNEE_NAME
,      STATUS
,      SHIPMENT_WEIGHT
,      SHIPMENT_VOLUME
,      LOCATION
FROM FTE.FTE_DELIVERY_PROOF;

Dependencies

[top of page]

FTE.FTE_DELIVERY_PROOF does not reference any database object

FTE.FTE_DELIVERY_PROOF is referenced by following:

APPS: FTE_DELIVERY_PROOF