VIEW: APPS.WSH_STND_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 , DECODE(WDD.CLIENT_ID,NULL,MSIK.CONCATENATED_SEGMENTS, SUBSTR(MSIK.CONCATENATED_SEGMENTS, 1, INSTR(MSIK.CONCATENATED_SEGMENTS,FFSV.CONCATENATED_SEGMENT_DELIMITER,-1)-1)) 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.TRACKING_NUMBER TRACKING_NUMBER , 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 , 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 , WDD.FILL_PERCENT FILL_PERCENT , WDD.FILLED_VOLUME FILLED_VOLUME , NVL(WDD.WV_FROZEN_FLAG,'Y') MANUAL_WV , WDD.GROSS_WEIGHT - NVL(WDD.NET_WEIGHT,0) TARE_WEIGHT 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, FND_ID_FLEX_STRUCTURES_VL FFSV 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 (+) AND FFSV.APPLICATION_ID = 401 AND FFSV.ID_FLEX_CODE = 'MSTK' AND FFSV.ID_FLEX_NUM = 101

View Text - HTML Formatted

SELECT DISTINCT WDD.CONTAINER_NAME CONTAINER_NAME
, WDD.SEAL_CODE SEAL_CODE
, WDD.CONTAINER_TYPE_CODE CONTAINER_TYPE_CODE
, DECODE(WDD.CLIENT_ID
, NULL
, MSIK.CONCATENATED_SEGMENTS
, SUBSTR(MSIK.CONCATENATED_SEGMENTS
, 1
, INSTR(MSIK.CONCATENATED_SEGMENTS
, FFSV.CONCATENATED_SEGMENT_DELIMITER
, -1)-1)) 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.TRACKING_NUMBER TRACKING_NUMBER
, 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
, 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
, WDD.FILL_PERCENT FILL_PERCENT
, WDD.FILLED_VOLUME FILLED_VOLUME
, NVL(WDD.WV_FROZEN_FLAG
, 'Y') MANUAL_WV
, WDD.GROSS_WEIGHT - NVL(WDD.NET_WEIGHT
, 0) TARE_WEIGHT
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
, FND_ID_FLEX_STRUCTURES_VL FFSV
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 (+)
AND FFSV.APPLICATION_ID = 401
AND FFSV.ID_FLEX_CODE = 'MSTK'
AND FFSV.ID_FLEX_NUM = 101