View: WSHBV_DELIVERY_DETAILS

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSHBV_DELIVERY_DETAILS

View Text

SELECT WDD.DELIVERY_DETAIL_ID
, WDD.SOURCE_CODE
, WDD.SOURCE_HEADER_ID
, WDD.SOURCE_LINE_ID
, WDD.SOURCE_HEADER_TYPE_ID
, WDD.SOURCE_HEADER_TYPE_NAME SRC_HEADER_TYPE_NAME
, WDD.CUST_PO_NUMBER
, WDD.CUSTOMER_ID
, WDD.SOLD_TO_CONTACT_ID
, WDD.ITEM_DESCRIPTION
, WDD.SHIP_SET_ID
, WDD.ARRIVAL_SET_ID
, WDD.TOP_MODEL_LINE_ID
, WDD.ATO_LINE_ID
, WDD.HOLD_CODE
, '_LA:WDD.SHIP_MODEL_COMPLETE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WDD.HAZARD_CLASS_ID
, WDD.COUNTRY_OF_ORIGIN
, WDD.CLASSIFICATION
, LOC.SOURCE_LOCATION_ID
, WDD.ORGANIZATION_ID
, LOC1.SOURCE_LOCATION_ID
, WDD.SHIP_TO_CONTACT_ID
, LOC2.SOURCE_LOCATION_ID
, WDD.DELIVER_TO_CONTACT_ID
, LOC3.SOURCE_LOCATION_ID
, WDD.INTMED_SHIP_TO_CONTACT_ID
, WDD.SHIP_TOLERANCE_ABOVE
, WDD.SHIP_TOLERANCE_BELOW
, WDD.SRC_REQUESTED_QUANTITY
, WDD.SRC_REQUESTED_QUANTITY_UOM
, WDD.CANCELLED_QUANTITY
, WDD.REQUESTED_QUANTITY
, WDD.REQUESTED_QUANTITY_UOM
, WDD.SHIPPED_QUANTITY
, WDD.DELIVERED_QUANTITY
, WDD.QUALITY_CONTROL_QUANTITY
, WDD.CYCLE_COUNT_QUANTITY
, WDD.MOVE_ORDER_LINE_ID
, WDD.SUBINVENTORY
, WDD.REVISION
, WDD.LOT_NUMBER
, WDD.RELEASED_STATUS
, '_LA:WDD.CUSTOMER_REQUESTED_LOT_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WDD.SERIAL_NUMBER
, WDD.LOCATOR_ID
, '_KF:INV:MTLL:MIL'
, WDD.DATE_REQUESTED
, WDD.DATE_SCHEDULED
, WDD.LOAD_SEQ_NUMBER
, '_LA:WDD.SHIP_METHOD_CODE:FND_LOOKUP_VALUES_VL:SHIP_METHOD:MEANING'
, WDD.CARRIER_ID
, '_LA:WDD.FREIGHT_TERMS_CODE:FND_LOOKUP_VALUES_VL:FREIGHT_TERMS:MEANING'
, '_LA:WDD.SHIPMENT_PRIORITY_CODE:FND_LOOKUP_VALUES_VL:SHIPMENT_PRIORITY:MEANING'
, '_LA:WDD.FOB_CODE:AR_LOOKUPS:FOB:MEANING'
, '_LA:WDD.DEP_PLAN_REQUIRED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WDD.CUSTOMER_PROD_SEQ
, WDD.CUSTOMER_DOCK_CODE
, WDD.NET_WEIGHT
, WDD.WEIGHT_UOM_CODE
, WDD.VOLUME
, WDD.VOLUME_UOM_CODE
, WDD.SHIPPING_INSTRUCTIONS
, WDD.PACKING_INSTRUCTIONS
, WDD.PROJECT_ID
, WDD.TASK_ID
, WDD.ORG_ID
, WDD.OE_INTERFACED_FLAG
, WDD.MVT_STAT_STATUS
, WDD.TRACKING_NUMBER
, WDD.TRANSACTION_TEMP_ID
, WDD.CREATION_DATE
, WDD.CREATED_BY
, WDD.LAST_UPDATE_DATE
, WDD.LAST_UPDATED_BY
, WDD.LAST_UPDATE_LOGIN
, WDD.PROGRAM_APPLICATION_ID
, WDD.PROGRAM_ID
, WDD.PROGRAM_UPDATE_DATE
, WDD.REQUEST_ID
, WDD.MOVEMENT_ID
, WDD.SPLIT_FROM_DELIVERY_DETAIL_ID SPLIT_FROM_DEL_DETAIL_ID
, WDD.INV_INTERFACED_FLAG
, WDD.SEAL_CODE
, WDD.MINIMUM_FILL_PERCENT
, WDD.MAXIMUM_VOLUME
, WDD.MAXIMUM_LOAD_WEIGHT
, WDD.MASTER_SERIAL_NUMBER
, WDD.GROSS_WEIGHT
, WDD.FILL_PERCENT
, WDD.CONTAINER_NAME
, WDD.CONTAINER_TYPE_CODE
, '_LA:WDD.CONTAINER_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WDD.PREFERRED_GRADE
, WDD.SRC_REQUESTED_QUANTITY2
, WDD.SRC_REQUESTED_QUANTITY_UOM2
, WDD.REQUESTED_QUANTITY2
, WDD.SHIPPED_QUANTITY2
, WDD.DELIVERED_QUANTITY2
, WDD.CANCELLED_QUANTITY2
, WDD.QUALITY_CONTROL_QUANTITY2
, WDD.CYCLE_COUNT_QUANTITY2
, WDD.REQUESTED_QUANTITY_UOM2
, WDD.SUBLOT_NUMBER
, WDD.UNIT_PRICE
, WDD.CURRENCY_CODE
, WDD.UNIT_NUMBER
, WDD.FREIGHT_CLASS_CAT_ID
, WDD.COMMODITY_CODE_CAT_ID
, WDD.SOURCE_HEADER_NUMBER
, WDD.SOURCE_LINE_NUMBER
, WDD.SHIP_TO_SITE_USE_ID
, WDD.DELIVER_TO_SITE_USE_ID
, WDD.LPN_ID
, '_LA:WDD.INSPECTION_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WDD.ORIGINAL_SUBINVENTORY
, '_LA:WDD.PICKABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, WDD.INVENTORY_ITEM_ID
, WDD.MASTER_CONTAINER_ITEM_ID
, WDD.DETAIL_CONTAINER_ITEM_ID
, '_KF:INV:MSTK:MSI'
, '_KF:INV:MSTK:MASTER_ITEM'
, '_KF:INV:MSTK:DETAIL_ITEM'
FROM WSH_DELIVERY_DETAILS WDD
, MTL_SYSTEM_ITEMS MSI
, MTL_CUSTOMER_ITEMS CUST_ITEM
, MTL_SYSTEM_ITEMS MASTER_ITEM
, MTL_SYSTEM_ITEMS DETAIL_ITEM
, WSH_LOCATIONS LOC
, WSH_LOCATIONS LOC1
, WSH_LOCATIONS LOC2
, WSH_LOCATIONS LOC3
, MTL_ITEM_LOCATIONS MIL
WHERE WDD.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND WDD.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND WDD.CUSTOMER_ITEM_ID = CUST_ITEM.CUSTOMER_ITEM_ID(+)
AND WDD.MASTER_CONTAINER_ITEM_ID = MASTER_ITEM.INVENTORY_ITEM_ID(+)
AND WDD.ORGANIZATION_ID = MASTER_ITEM.ORGANIZATION_ID(+)
AND WDD.DETAIL_CONTAINER_ITEM_ID = DETAIL_ITEM.INVENTORY_ITEM_ID(+)
AND WDD.ORGANIZATION_ID = DETAIL_ITEM.ORGANIZATION_ID(+)
AND WDD.LOCATOR_ID=MIL.INVENTORY_LOCATION_ID(+)
AND WDD.ORGANIZATION_ID=MIL.ORGANIZATION_ID(+)
AND WDD.SHIP_FROM_LOCATION_ID = LOC.WSH_LOCATION_ID(+)
AND WDD.SHIP_TO_LOCATION_ID = LOC1.WSH_LOCATION_ID(+)
AND WDD.DELIVER_TO_LOCATION_ID= LOC2.WSH_LOCATION_ID(+)
AND WDD.INTMED_SHIP_TO_LOCATION_ID = LOC3.WSH_LOCATION_ID(+)
AND '_SEC:WDD.ORGANIZATION_ID' IS NOT NULL
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY

Columns