VIEW: APPS.WSH_ITM_CONTAINERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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