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


VIEW: APPS.CLN_XML_CONTAINERS_V

Object Details
Object Name: CLN_XML_CONTAINERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCLN.CLN_XML_CONTAINERS_V
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


View for SHIPUNIT containers section in OAG SHOW_SHIPMENT_005 XML payload


[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTAINER_INSTANCE_ID NUMBER
Yes Primary Key to identify delivery container line
CONTAINER_SERIAL_NUMBER VARCHAR2 (30)
Serial Number of a container item
CONTAINER_TYPE_INT VARCHAR2 (30)
Container type code
CONTAINER_VOLUME NUMBER

Volume
CONTAINER_VOLUME_UOM_CODE_INT VARCHAR2 (3)
CONTAINER_NET_WEIGHT NUMBER

Container Net Weight
CONTAINER_SEAL_CODE VARCHAR2 (30)
Seal Code
CONTAINER_TRACKING_NUMBER VARCHAR2 (30)
Tracking number
DELIVERY_ID NUMBER

Foreign Key to WSH_NEW_DELIVERIES
UNIT_HEIGHT NUMBER

Container Item height
UNIT_LENGTH NUMBER

Container Item length
UNIT_WIDTH NUMBER

Container Item width
PARENT_DELIVERY_DETAIL_ID NUMBER

Foreign Key to WSH_NEW_DELIVERIES for parent delivery
LPN_ID NUMBER

Query Text

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


SELECT CONTAINER_INSTANCE_ID
,      CONTAINER_SERIAL_NUMBER
,      CONTAINER_TYPE_INT
,      CONTAINER_VOLUME
,      CONTAINER_VOLUME_UOM_CODE_INT
,      CONTAINER_NET_WEIGHT
,      CONTAINER_SEAL_CODE
,      CONTAINER_TRACKING_NUMBER
,      DELIVERY_ID
,      UNIT_HEIGHT
,      UNIT_LENGTH
,      UNIT_WIDTH
,      PARENT_DELIVERY_DETAIL_ID
,      LPN_ID
FROM APPS.CLN_XML_CONTAINERS_V;

Dependencies

[top of page]

APPS.CLN_XML_CONTAINERS_V references the following:

SchemaAPPS
SynonymMTL_SYSTEM_ITEMS
SynonymWSH_DELIVERY_ASSIGNMENTS
SynonymWSH_DELIVERY_DETAILS

APPS.CLN_XML_CONTAINERS_V is not referenced by any database object