View: WSH_ITM_CONTAINERS_V

Product:	WSH - Shipping Execution
Description:	Temporary Table to return WSH_SS_CONTAINERS_V along with Dummy Records to avoid problems in Retreiving Data while using XSU.
Implementation/DBA Data:	APPS.WSH_ITM_CONTAINERS_V

View Text

SELECT DISTINCT WDD.CONTAINER_NAME CONTAINER_NAME
, WDD.SEAL_CODE SEAL_CODE
, WDD.CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE
, MSIK.CONCATENATED_SEGMENTS ITEM_NUMBER
, WDD.ITEM_DESCRIPTION ITEM_DESCRIPTION
, WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, WDA.PARENT_DELIVERY_DETAIL_ID PARENT_DELIVERY_DETAIL_ID
, WDA.DELIVERY_ID DELIVERY_ID
, WDD.GROSS_WEIGHT GROSS_WEIGHT
, WDD.NET_WEIGHT NET_WEIGHT
, WDD.WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, WDD.VOLUME VOLUME
, WDD.VOLUME_UOM_CODE VOLUME_UOM_CODE
, WDD.LOT_NUMBER LOT_NUMBER
, WDD.SUBLOT_NUMBER SUBLOT_NUMBER
, WDD.REVISION REVISION
, WDD.SERIAL_NUMBER FROM_SERIAL_NUMBER
, WDD.TO_SERIAL_NUMBER TO_SERIAL_NUMBER
, WDD.TRACKING_NUMBER TRACKING_NUMBER
, WDD.COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN
, WDD.DATE_SCHEDULED DATE_SCHEDULED
, WDD.SHIP_METHOD_CODE SHIP_METHOD_CODE
, WDD.FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, WDD.FOB_CODE FOB_CODE
, WDD.SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, WDD.PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, WDD.DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, WDD.ORG_ID ORG_ID
, WDD.CUSTOMER_ID CUSTOMER_ID
, MSIK.UNIT_HEIGHT UNIT_HEIGHT
, MSIK.UNIT_LENGTH UNIT_LENGTH
, MSIK.UNIT_WIDTH UNIT_WIDTH
, MSIK.DIMENSION_UOM_CODE DIMENSION_UOM_CODE
, HRL.LOCATION_CODE SHIP_FROM_LOCATION
, MCSV.CATEGORY_SET_NAME CATEGORY_SET_NAME
, PHCV.HAZARD_CLASS HAZARD_CLASS
, WDD.ATTRIBUTE_CATEGORY CONTAINER_ATTRIBUTE_CATEGORY
, WDD.ATTRIBUTE1 CONTAINER_ATTRIBUTE1
, WDD.ATTRIBUTE2 CONTAINER_ATTRIBUTE2
, WDD.ATTRIBUTE3 CONTAINER_ATTRIBUTE3
, WDD.ATTRIBUTE4 CONTAINER_ATTRIBUTE4
, WDD.ATTRIBUTE5 CONTAINER_ATTRIBUTE5
, WDD.ATTRIBUTE6 CONTAINER_ATTRIBUTE6
, WDD.ATTRIBUTE7 CONTAINER_ATTRIBUTE7
, WDD.ATTRIBUTE8 CONTAINER_ATTRIBUTE8
, WDD.ATTRIBUTE9 CONTAINER_ATTRIBUTE9
, WDD.ATTRIBUTE10 CONTAINER_ATTRIBUTE10
, WDD.ATTRIBUTE11 CONTAINER_ATTRIBUTE11
, WDD.ATTRIBUTE12 CONTAINER_ATTRIBUTE12
, WDD.ATTRIBUTE13 CONTAINER_ATTRIBUTE13
, WDD.ATTRIBUTE14 CONTAINER_ATTRIBUTE14
, WDD.ATTRIBUTE15 CONTAINER_ATTRIBUTE15
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS_V WDA
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_CATEGORY_SETS_VL MCSV
, PO_HAZARD_CLASSES_VL PHCV
, HR_LOCATIONS_ALL_TL HRL
, WSH_LOCATIONS WL
WHERE WDD.CONTAINER_FLAG = 'Y'
AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
AND WDD.SHIP_FROM_LOCATION_ID = WL.WSH_LOCATION_ID
AND WL.LOCATION_SOURCE_CODE = 'HR'
AND WL.SOURCE_LOCATION_ID = HRL.LOCATION_ID
AND HRL.LANGUAGE = USERENV('LANG')
AND WDD.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID(+)
AND WDD.ORGANIZATION_ID = MSIK.ORGANIZATION_ID(+)
AND WDD.HAZARD_CLASS_ID = PHCV.HAZARD_CLASS_ID (+)
AND WDD.FREIGHT_CLASS_CAT_ID= MCSV.CATEGORY_SET_ID (+) UNION SELECT 'DUMMY'
, NULL
, NULL
, NULL
, NULL
, -99
, -999
, WND.DELIVERY_ID DELIVERY_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM WSH_NEW_DELIVERIES WND UNION SELECT 'DUMMY'
, NULL
, NULL
, NULL
, NULL
, -999
, TO_NUMBER(NULL)
, WND.DELIVERY_ID DELIVERY_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM WSH_NEW_DELIVERIES WND

Columns