[Home] [Help] [Dependency Information]
Object Name: | WSH_DSNO_DELIVERY_ATTRIBS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | WSH.WSH_DSNO_DELIVERY_ATTRIBS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TP_HEADER_ID | NUMBER | Yes | ||
TP_DETAIL_ID | NUMBER | Yes | ||
DELIVERY_ID | NUMBER | Yes | ||
WAREHOUSE_LOCATION_ID | NUMBER | Yes | ||
WAREHOUSE_CODE_EXT | VARCHAR2 | (35) | ||
DESTINATION_SITE_USE_ID | NUMBER | (15) | Yes | |
DESTINATION_CUSTOMER_ID | NUMBER | (15) | Yes | |
TP_HEADER_CATEGORY | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE1 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE2 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE3 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE4 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE5 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE6 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE7 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE8 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE9 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE10 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE11 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE12 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE13 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE14 | VARCHAR2 | (150) | ||
TP_HEADER_ATTRIBUTE15 | VARCHAR2 | (150) | ||
TP_DETAIL_CATEGORY | VARCHAR2 | (150) | ||
TP_DETAIL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
TP_DETAIL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
TP_DETAIL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
TP_DETAIL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
TP_DETAIL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
WAREHOUSE_CATEGORY | VARCHAR2 | (30) | ||
WAREHOUSE_ATTRIBUTE1 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE2 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE3 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE4 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE5 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE6 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE7 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE8 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE9 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE10 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE11 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE12 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE13 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE14 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE15 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE16 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE17 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE18 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE19 | VARCHAR2 | (150) | ||
WAREHOUSE_ATTRIBUTE20 | VARCHAR2 | (150) | ||
DESTINATION_CATEGORY | VARCHAR2 | (30) | ||
DESTINATION_ATTRIBUTE1 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE2 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE3 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE4 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE5 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE6 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE7 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE8 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE9 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE10 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE11 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE12 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE13 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE14 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE15 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE16 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE17 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE18 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE19 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE20 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE21 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE22 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE23 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE24 | VARCHAR2 | (150) | ||
DESTINATION_ATTRIBUTE25 | VARCHAR2 | (150) | ||
CUSTOMER_CATEGORY | VARCHAR2 | (30) | ||
CUSTOMER_ATTRIBUTE1 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE2 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE3 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE4 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE5 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE6 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE7 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE8 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE9 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE10 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE11 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE12 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE13 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE14 | VARCHAR2 | (150) | ||
CUSTOMER_ATTRIBUTE15 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_CATEGORY | VARCHAR2 | (30) | ||
CUSTOMER_GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
CUSTOMER_GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
DELIVERY_TP_CATEGORY | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE1 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE2 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE3 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE4 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE5 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE6 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE7 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE8 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE9 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE10 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE11 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE12 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE13 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE14 | VARCHAR2 | (150) | ||
DELIVERY_TP_ATTRIBUTE15 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_CATEGORY | VARCHAR2 | (30) | ||
DELIVERY_GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
DELIVERY_GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
DELIVERY_CATEGORY | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE1 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE2 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE3 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE4 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE5 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE6 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE7 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE8 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE9 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE10 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE11 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE12 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE13 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE14 | VARCHAR2 | (150) | ||
DELIVERY_ATTRIBUTE15 | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT TP_HEADER_ID
, TP_DETAIL_ID
, DELIVERY_ID
, WAREHOUSE_LOCATION_ID
, WAREHOUSE_CODE_EXT
, DESTINATION_SITE_USE_ID
, DESTINATION_CUSTOMER_ID
, TP_HEADER_CATEGORY
, TP_HEADER_ATTRIBUTE1
, TP_HEADER_ATTRIBUTE2
, TP_HEADER_ATTRIBUTE3
, TP_HEADER_ATTRIBUTE4
, TP_HEADER_ATTRIBUTE5
, TP_HEADER_ATTRIBUTE6
, TP_HEADER_ATTRIBUTE7
, TP_HEADER_ATTRIBUTE8
, TP_HEADER_ATTRIBUTE9
, TP_HEADER_ATTRIBUTE10
, TP_HEADER_ATTRIBUTE11
, TP_HEADER_ATTRIBUTE12
, TP_HEADER_ATTRIBUTE13
, TP_HEADER_ATTRIBUTE14
, TP_HEADER_ATTRIBUTE15
, TP_DETAIL_CATEGORY
, TP_DETAIL_ATTRIBUTE1
, TP_DETAIL_ATTRIBUTE2
, TP_DETAIL_ATTRIBUTE3
, TP_DETAIL_ATTRIBUTE4
, TP_DETAIL_ATTRIBUTE5
, WAREHOUSE_CATEGORY
, WAREHOUSE_ATTRIBUTE1
, WAREHOUSE_ATTRIBUTE2
, WAREHOUSE_ATTRIBUTE3
, WAREHOUSE_ATTRIBUTE4
, WAREHOUSE_ATTRIBUTE5
, WAREHOUSE_ATTRIBUTE6
, WAREHOUSE_ATTRIBUTE7
, WAREHOUSE_ATTRIBUTE8
, WAREHOUSE_ATTRIBUTE9
, WAREHOUSE_ATTRIBUTE10
, WAREHOUSE_ATTRIBUTE11
, WAREHOUSE_ATTRIBUTE12
, WAREHOUSE_ATTRIBUTE13
, WAREHOUSE_ATTRIBUTE14
, WAREHOUSE_ATTRIBUTE15
, WAREHOUSE_ATTRIBUTE16
, WAREHOUSE_ATTRIBUTE17
, WAREHOUSE_ATTRIBUTE18
, WAREHOUSE_ATTRIBUTE19
, WAREHOUSE_ATTRIBUTE20
, DESTINATION_CATEGORY
, DESTINATION_ATTRIBUTE1
, DESTINATION_ATTRIBUTE2
, DESTINATION_ATTRIBUTE3
, DESTINATION_ATTRIBUTE4
, DESTINATION_ATTRIBUTE5
, DESTINATION_ATTRIBUTE6
, DESTINATION_ATTRIBUTE7
, DESTINATION_ATTRIBUTE8
, DESTINATION_ATTRIBUTE9
, DESTINATION_ATTRIBUTE10
, DESTINATION_ATTRIBUTE11
, DESTINATION_ATTRIBUTE12
, DESTINATION_ATTRIBUTE13
, DESTINATION_ATTRIBUTE14
, DESTINATION_ATTRIBUTE15
, DESTINATION_ATTRIBUTE16
, DESTINATION_ATTRIBUTE17
, DESTINATION_ATTRIBUTE18
, DESTINATION_ATTRIBUTE19
, DESTINATION_ATTRIBUTE20
, DESTINATION_ATTRIBUTE21
, DESTINATION_ATTRIBUTE22
, DESTINATION_ATTRIBUTE23
, DESTINATION_ATTRIBUTE24
, DESTINATION_ATTRIBUTE25
, CUSTOMER_CATEGORY
, CUSTOMER_ATTRIBUTE1
, CUSTOMER_ATTRIBUTE2
, CUSTOMER_ATTRIBUTE3
, CUSTOMER_ATTRIBUTE4
, CUSTOMER_ATTRIBUTE5
, CUSTOMER_ATTRIBUTE6
, CUSTOMER_ATTRIBUTE7
, CUSTOMER_ATTRIBUTE8
, CUSTOMER_ATTRIBUTE9
, CUSTOMER_ATTRIBUTE10
, CUSTOMER_ATTRIBUTE11
, CUSTOMER_ATTRIBUTE12
, CUSTOMER_ATTRIBUTE13
, CUSTOMER_ATTRIBUTE14
, CUSTOMER_ATTRIBUTE15
, CUSTOMER_GLOBAL_CATEGORY
, CUSTOMER_GLOBAL_ATTRIBUTE1
, CUSTOMER_GLOBAL_ATTRIBUTE2
, CUSTOMER_GLOBAL_ATTRIBUTE3
, CUSTOMER_GLOBAL_ATTRIBUTE4
, CUSTOMER_GLOBAL_ATTRIBUTE5
, CUSTOMER_GLOBAL_ATTRIBUTE6
, CUSTOMER_GLOBAL_ATTRIBUTE7
, CUSTOMER_GLOBAL_ATTRIBUTE8
, CUSTOMER_GLOBAL_ATTRIBUTE9
, CUSTOMER_GLOBAL_ATTRIBUTE10
, CUSTOMER_GLOBAL_ATTRIBUTE11
, CUSTOMER_GLOBAL_ATTRIBUTE12
, CUSTOMER_GLOBAL_ATTRIBUTE13
, CUSTOMER_GLOBAL_ATTRIBUTE14
, CUSTOMER_GLOBAL_ATTRIBUTE15
, CUSTOMER_GLOBAL_ATTRIBUTE16
, CUSTOMER_GLOBAL_ATTRIBUTE17
, CUSTOMER_GLOBAL_ATTRIBUTE18
, CUSTOMER_GLOBAL_ATTRIBUTE19
, CUSTOMER_GLOBAL_ATTRIBUTE20
, DELIVERY_TP_CATEGORY
, DELIVERY_TP_ATTRIBUTE1
, DELIVERY_TP_ATTRIBUTE2
, DELIVERY_TP_ATTRIBUTE3
, DELIVERY_TP_ATTRIBUTE4
, DELIVERY_TP_ATTRIBUTE5
, DELIVERY_TP_ATTRIBUTE6
, DELIVERY_TP_ATTRIBUTE7
, DELIVERY_TP_ATTRIBUTE8
, DELIVERY_TP_ATTRIBUTE9
, DELIVERY_TP_ATTRIBUTE10
, DELIVERY_TP_ATTRIBUTE11
, DELIVERY_TP_ATTRIBUTE12
, DELIVERY_TP_ATTRIBUTE13
, DELIVERY_TP_ATTRIBUTE14
, DELIVERY_TP_ATTRIBUTE15
, DELIVERY_GLOBAL_CATEGORY
, DELIVERY_GLOBAL_ATTRIBUTE1
, DELIVERY_GLOBAL_ATTRIBUTE2
, DELIVERY_GLOBAL_ATTRIBUTE3
, DELIVERY_GLOBAL_ATTRIBUTE4
, DELIVERY_GLOBAL_ATTRIBUTE5
, DELIVERY_GLOBAL_ATTRIBUTE6
, DELIVERY_GLOBAL_ATTRIBUTE7
, DELIVERY_GLOBAL_ATTRIBUTE8
, DELIVERY_GLOBAL_ATTRIBUTE9
, DELIVERY_GLOBAL_ATTRIBUTE10
, DELIVERY_GLOBAL_ATTRIBUTE11
, DELIVERY_GLOBAL_ATTRIBUTE12
, DELIVERY_GLOBAL_ATTRIBUTE13
, DELIVERY_GLOBAL_ATTRIBUTE14
, DELIVERY_GLOBAL_ATTRIBUTE15
, DELIVERY_GLOBAL_ATTRIBUTE16
, DELIVERY_GLOBAL_ATTRIBUTE17
, DELIVERY_GLOBAL_ATTRIBUTE18
, DELIVERY_GLOBAL_ATTRIBUTE19
, DELIVERY_GLOBAL_ATTRIBUTE20
, DELIVERY_CATEGORY
, DELIVERY_ATTRIBUTE1
, DELIVERY_ATTRIBUTE2
, DELIVERY_ATTRIBUTE3
, DELIVERY_ATTRIBUTE4
, DELIVERY_ATTRIBUTE5
, DELIVERY_ATTRIBUTE6
, DELIVERY_ATTRIBUTE7
, DELIVERY_ATTRIBUTE8
, DELIVERY_ATTRIBUTE9
, DELIVERY_ATTRIBUTE10
, DELIVERY_ATTRIBUTE11
, DELIVERY_ATTRIBUTE12
, DELIVERY_ATTRIBUTE13
, DELIVERY_ATTRIBUTE14
, DELIVERY_ATTRIBUTE15
FROM APPS.WSH_DSNO_DELIVERY_ATTRIBS_V;
APPS.WSH_DSNO_DELIVERY_ATTRIBS_V is not referenced by any database object
|
|
|