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


VIEW: APPS.WSH_DSNO_DELIVERY_ATTRIBS_V

Object Details
Object Name: WSH_DSNO_DELIVERY_ATTRIBS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSH_DSNO_DELIVERY_ATTRIBS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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)
Query Text

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;

Dependencies

[top of page]

APPS.WSH_DSNO_DELIVERY_ATTRIBS_V references the following:

SchemaAPPS
SynonymECE_TP_DETAILS
SynonymECE_TP_HEADERS
SynonymHR_LOCATIONS_ALL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTY_SITES
ViewWSH_DELIVERY_ASSIGNMENTS_V
SynonymWSH_DELIVERY_DETAILS
SynonymWSH_LOCATIONS
SynonymWSH_NEW_DELIVERIES

APPS.WSH_DSNO_DELIVERY_ATTRIBS_V is not referenced by any database object