Skip to content

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: TableFTE.FTE_DELIVERY_PROOF
Subobject Name:
Status: VALID


This table holds the POD portion of the ShowShipment message


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FTE_DELIVERY_PROOF_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnID
FTE_DELIVERY_PROOF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_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:

SchemaFTE
ViewFTE_DELIVERY_PROOF#