[Home] [Help] [Dependency Information]
Object Name: | FTE_DELIVERY_PROOF# |
---|---|
Object Type: | VIEW |
Owner: | FTE |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
RECEIVED_DATE | DATE | |||
NAME1 | VARCHAR2 | (50) | ||
SHIP_UNIT_QUANTITY | NUMBER | |||
SHIP_UNIT_UOM | VARCHAR2 | (30) | ||
NOTES1 | VARCHAR2 | (2000) | ||
NOTES2 | VARCHAR2 | (2000) | ||
NOTES3 | VARCHAR2 | (2000) | ||
NOTES4 | VARCHAR2 | (2000) | ||
NOTES5 | VARCHAR2 | (2000) | ||
NOTES6 | VARCHAR2 | (2000) | ||
NOTES7 | VARCHAR2 | (2000) | ||
NOTES8 | VARCHAR2 | (2000) | ||
NOTES9 | VARCHAR2 | (2000) | ||
SHIP_UNIT_SEQ | NUMBER | |||
SHIP_UNIT_TOTAL | NUMBER | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | |||
TRANSACTION_ID | NUMBER | |||
TRACKING_ID | VARCHAR2 | (30) | ||
TRACKING_ID_TYPE | VARCHAR2 | (50) | ||
CONSIGNEE_NAME | VARCHAR2 | (50) | ||
STATUS | VARCHAR2 | (20) | ||
SHIPMENT_WEIGHT | NUMBER | |||
SHIPMENT_VOLUME | NUMBER | |||
LOCATION | VARCHAR2 | (500) |
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#;
|
|
|