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

VIEW: APPS.WSH_SS_CONTAINERS_V

Object Details
Object Name: WSH_SS_CONTAINERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSH_SS_CONTAINERS_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
CONTAINER_NAME VARCHAR2 (30)
SEAL_CODE VARCHAR2 (30)
CONTAINER_TYPE_CODE VARCHAR2 (30)
ITEM_NUMBER VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (250)
DELIVERY_DETAIL_ID NUMBER
Yes
PARENT_DELIVERY_DETAIL_ID NUMBER

DELIVERY_ID NUMBER

GROSS_WEIGHT NUMBER

NET_WEIGHT NUMBER

WEIGHT_UOM_CODE VARCHAR2 (3)
VOLUME NUMBER

VOLUME_UOM_CODE VARCHAR2 (3)
LOT_NUMBER VARCHAR2 (80)
REVISION VARCHAR2 (3)
FROM_SERIAL_NUMBER VARCHAR2 (30)
TO_SERIAL_NUMBER VARCHAR2 (30)
TRACKING_NUMBER VARCHAR2 (30)
COUNTRY_OF_ORIGIN VARCHAR2 (50)
DATE_SCHEDULED DATE

SHIP_METHOD_CODE VARCHAR2 (30)
FREIGHT_TERMS_CODE VARCHAR2 (30)
FOB_CODE VARCHAR2 (30)
SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
PACKING_INSTRUCTIONS VARCHAR2 (2000)
DELIVER_TO_LOCATION_ID NUMBER

ORG_ID NUMBER

CUSTOMER_ID NUMBER

UNIT_HEIGHT NUMBER

UNIT_LENGTH NUMBER

UNIT_WIDTH NUMBER

DIMENSION_UOM_CODE VARCHAR2 (3)
SHIP_FROM_LOCATION VARCHAR2 (60) Yes
CATEGORY_SET_NAME VARCHAR2 (30)
HAZARD_CLASS VARCHAR2 (40)
CONTAINER_ATTRIBUTE_CATEGORY VARCHAR2 (150)
CONTAINER_ATTRIBUTE1 VARCHAR2 (150)
CONTAINER_ATTRIBUTE2 VARCHAR2 (150)
CONTAINER_ATTRIBUTE3 VARCHAR2 (150)
CONTAINER_ATTRIBUTE4 VARCHAR2 (150)
CONTAINER_ATTRIBUTE5 VARCHAR2 (150)
CONTAINER_ATTRIBUTE6 VARCHAR2 (150)
CONTAINER_ATTRIBUTE7 VARCHAR2 (150)
CONTAINER_ATTRIBUTE8 VARCHAR2 (150)
CONTAINER_ATTRIBUTE9 VARCHAR2 (150)
CONTAINER_ATTRIBUTE10 VARCHAR2 (150)
CONTAINER_ATTRIBUTE11 VARCHAR2 (150)
CONTAINER_ATTRIBUTE12 VARCHAR2 (150)
CONTAINER_ATTRIBUTE13 VARCHAR2 (150)
CONTAINER_ATTRIBUTE14 VARCHAR2 (150)
CONTAINER_ATTRIBUTE15 VARCHAR2 (150)
FILL_PERCENT NUMBER

Fill Percent of the container
FILLED_VOLUME NUMBER

Filled Volume of the container
MANUAL_WV VARCHAR2 (1)
'N' if W/V is System calculated. 'Y' if W/V is manually entered
Query Text

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


SELECT CONTAINER_NAME
,      SEAL_CODE
,      CONTAINER_TYPE_CODE
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      DELIVERY_DETAIL_ID
,      PARENT_DELIVERY_DETAIL_ID
,      DELIVERY_ID
,      GROSS_WEIGHT
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME
,      VOLUME_UOM_CODE
,      LOT_NUMBER
,      REVISION
,      FROM_SERIAL_NUMBER
,      TO_SERIAL_NUMBER
,      TRACKING_NUMBER
,      COUNTRY_OF_ORIGIN
,      DATE_SCHEDULED
,      SHIP_METHOD_CODE
,      FREIGHT_TERMS_CODE
,      FOB_CODE
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      DELIVER_TO_LOCATION_ID
,      ORG_ID
,      CUSTOMER_ID
,      UNIT_HEIGHT
,      UNIT_LENGTH
,      UNIT_WIDTH
,      DIMENSION_UOM_CODE
,      SHIP_FROM_LOCATION
,      CATEGORY_SET_NAME
,      HAZARD_CLASS
,      CONTAINER_ATTRIBUTE_CATEGORY
,      CONTAINER_ATTRIBUTE1
,      CONTAINER_ATTRIBUTE2
,      CONTAINER_ATTRIBUTE3
,      CONTAINER_ATTRIBUTE4
,      CONTAINER_ATTRIBUTE5
,      CONTAINER_ATTRIBUTE6
,      CONTAINER_ATTRIBUTE7
,      CONTAINER_ATTRIBUTE8
,      CONTAINER_ATTRIBUTE9
,      CONTAINER_ATTRIBUTE10
,      CONTAINER_ATTRIBUTE11
,      CONTAINER_ATTRIBUTE12
,      CONTAINER_ATTRIBUTE13
,      CONTAINER_ATTRIBUTE14
,      CONTAINER_ATTRIBUTE15
,      FILL_PERCENT
,      FILLED_VOLUME
,      MANUAL_WV
FROM APPS.WSH_SS_CONTAINERS_V;

Dependencies

[top of page]

APPS.WSH_SS_CONTAINERS_V references the following:

SchemaAPPS
SynonymHR_LOCATIONS_ALL_TL
ViewMTL_CATEGORY_SETS_VL
SynonymMTL_SYSTEM_ITEMS_KFV
ViewPO_HAZARD_CLASSES_VL
ViewWSH_DELIVERY_ASSIGNMENTS_V
SynonymWSH_DELIVERY_DETAILS
SynonymWSH_LOCATIONS

APPS.WSH_SS_CONTAINERS_V is not referenced by any database object