View: WSH_DLVY_DELIVERABLES_V

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

View Text

SELECT TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, WDD.ROWID
, DECODE(WDD.CONTAINER_FLAG
, 'Y'
, 'C'
, 'L')
, WDD.DELIVERY_DETAIL_ID
, TO_NUMBER(DECODE(WDD.CONTAINER_FLAG
, 'N'
, WDD.DELIVERY_DETAIL_ID
, NULL))
, TO_NUMBER(DECODE(WDD.CONTAINER_FLAG
, 'Y'
, WDD.DELIVERY_DETAIL_ID
, NULL))
, WDD.CONTAINER_NAME
, WDA.DELIVERY_ID
, WDD.SOURCE_CODE
, WL_SOURCE.MEANING
, WDD.SOURCE_HEADER_ID
, WDD.SOURCE_LINE_ID
, WDD.SOURCE_HEADER_NUMBER
, WDD.SOURCE_HEADER_TYPE_ID
, WDD.SOURCE_HEADER_TYPE_NAME
, WDD.SOURCE_LINE_NUMBER
, WDD.SRC_REQUESTED_QUANTITY
, WDD.SRC_REQUESTED_QUANTITY_UOM
, WDD.CUSTOMER_ID
, WDD.SOLD_TO_CONTACT_ID
, WDD.INVENTORY_ITEM_ID
, WDD.ITEM_DESCRIPTION
, WDD.COUNTRY_OF_ORIGIN
, WDD.CLASSIFICATION
, WDD.SHIP_FROM_LOCATION_ID
, WDD.SHIP_TO_LOCATION_ID
, WDD.SHIP_TO_CONTACT_ID
, WDD.DELIVER_TO_LOCATION_ID
, WDD.DELIVER_TO_CONTACT_ID
, WDD.INTMED_SHIP_TO_LOCATION_ID
, WDD.INTMED_SHIP_TO_CONTACT_ID
, WDD.SHIP_TOLERANCE_ABOVE
, WDD.SHIP_TOLERANCE_BELOW
, WDD.REQUESTED_QUANTITY
, WDD.SHIPPED_QUANTITY
, WDD.DELIVERED_QUANTITY
, WDD.CANCELLED_QUANTITY
, WDD.REQUESTED_QUANTITY_UOM
, WDD.SUBINVENTORY
, WDD.REVISION
, WDD.LOT_NUMBER
, WDD.CUSTOMER_REQUESTED_LOT_FLAG
, WDD.SERIAL_NUMBER
, WDD.LOCATOR_ID
, WDD.DATE_REQUESTED
, WDD.DATE_SCHEDULED
, WDD.MASTER_CONTAINER_ITEM_ID
, WDD.DETAIL_CONTAINER_ITEM_ID
, WDD.LOAD_SEQ_NUMBER
, WDD.SHIP_METHOD_CODE
, WDD.CARRIER_ID
, WDD.FREIGHT_TERMS_CODE
, WDD.SHIPMENT_PRIORITY_CODE
, WDD.FOB_CODE
, WDD.CUSTOMER_ITEM_ID
, WDD.DEP_PLAN_REQUIRED_FLAG
, WDD.CUSTOMER_PROD_SEQ
, WDD.CUSTOMER_DOCK_CODE
, WDD.UNIT_WEIGHT
, WDD.UNIT_VOLUME
, WDD.WV_FROZEN_FLAG
, WDD.GROSS_WEIGHT
, (WDD.GROSS_WEIGHT-NVL(WDD.NET_WEIGHT
, 0))
, WDD.NET_WEIGHT
, WDD.WEIGHT_UOM_CODE
, WDD.FILLED_VOLUME
, WDD.VOLUME
, WDD.VOLUME_UOM_CODE
, WDD.FILL_PERCENT
, WDD.MAXIMUM_LOAD_WEIGHT
, WDD.MAXIMUM_VOLUME
, WDD.MINIMUM_FILL_PERCENT
, WDD.MVT_STAT_STATUS
, WDD.RELEASED_STATUS
, WL_RELEASED.MEANING
, WDD.ORGANIZATION_ID
, WDD.TRANSACTION_TEMP_ID
, WDD.SHIP_SET_ID
, WDD.ARRIVAL_SET_ID
, WDD.SHIP_MODEL_COMPLETE_FLAG
, WDD.TOP_MODEL_LINE_ID
, WDD.HOLD_CODE
, WDD.CUST_PO_NUMBER
, WDD.ATO_LINE_ID
, WDD.MOVE_ORDER_LINE_ID
, WDD.HAZARD_CLASS_ID
, WDD.QUALITY_CONTROL_QUANTITY
, WDD.CYCLE_COUNT_QUANTITY
, WDD.TRACKING_NUMBER
, WDD.MOVEMENT_ID
, WDD.SHIPPING_INSTRUCTIONS
, WDD.PACKING_INSTRUCTIONS
, WDD.PROJECT_ID
, WDD.TASK_ID
, WDD.ORG_ID
, WDD.OE_INTERFACED_FLAG
, WDD.SPLIT_FROM_DELIVERY_DETAIL_ID
, WDD.INV_INTERFACED_FLAG
, WDA.PARENT_DELIVERY_DETAIL_ID
, WDD.MASTER_SERIAL_NUMBER
, WDD.CONTAINER_FLAG
, WDD.CONTAINER_TYPE_CODE
, WDD.SEAL_CODE
, TO_CHAR(NULL)
, WDD.ATTRIBUTE_CATEGORY
, WDD.ATTRIBUTE1
, WDD.ATTRIBUTE2
, WDD.ATTRIBUTE3
, WDD.ATTRIBUTE4
, WDD.ATTRIBUTE5
, WDD.ATTRIBUTE6
, WDD.ATTRIBUTE7
, WDD.ATTRIBUTE8
, WDD.ATTRIBUTE9
, WDD.ATTRIBUTE10
, WDD.ATTRIBUTE11
, WDD.ATTRIBUTE12
, WDD.ATTRIBUTE13
, WDD.ATTRIBUTE14
, WDD.ATTRIBUTE15
, WDD.TP_ATTRIBUTE_CATEGORY
, WDD.TP_ATTRIBUTE1
, WDD.TP_ATTRIBUTE2
, WDD.TP_ATTRIBUTE3
, WDD.TP_ATTRIBUTE4
, WDD.TP_ATTRIBUTE5
, WDD.TP_ATTRIBUTE6
, WDD.TP_ATTRIBUTE7
, WDD.TP_ATTRIBUTE8
, WDD.TP_ATTRIBUTE9
, WDD.TP_ATTRIBUTE10
, WDD.TP_ATTRIBUTE11
, WDD.TP_ATTRIBUTE12
, WDD.TP_ATTRIBUTE13
, WDD.TP_ATTRIBUTE14
, WDD.TP_ATTRIBUTE15
, 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.PREFERRED_GRADE
, WDD.SHIPPED_QUANTITY2
, WDD.DELIVERED_QUANTITY2
, WDD.CANCELLED_QUANTITY2
, WDD.REQUESTED_QUANTITY2
, WDD.REQUESTED_QUANTITY_UOM2
, WDD.SRC_REQUESTED_QUANTITY2
, WDD.SRC_REQUESTED_QUANTITY_UOM2
, WDD.QUALITY_CONTROL_QUANTITY2
, WDD.CYCLE_COUNT_QUANTITY2
, WDD.UNIT_NUMBER
, WDD.UNIT_PRICE
, WDD.CURRENCY_CODE
, WDD.FREIGHT_CLASS_CAT_ID
, WDD.COMMODITY_CODE_CAT_ID
, WDD.INSPECTION_FLAG
, WDD.PICKABLE_FLAG
, WDD.SHIP_TO_SITE_USE_ID
, WDD.DELIVER_TO_SITE_USE_ID
, WDD.TO_SERIAL_NUMBER
, WDD.PICKED_QUANTITY
, WDD.PICKED_QUANTITY2
, WDD.CUSTOMER_PRODUCTION_LINE
, WDD.CUSTOMER_JOB
, WDD.CUST_MODEL_SERIAL_NUMBER
, WDD.RECEIVED_QUANTITY
, WDD.RECEIVED_QUANTITY2
, WDD.SOURCE_LINE_SET_ID
, WDD.BATCH_ID
, WDD.LPN_ID
, WDD.ORIGINAL_SUBINVENTORY
, WDD.SERVICE_LEVEL
, WDD.MODE_OF_TRANSPORT
, WDD.IGNORE_FOR_PLANNING
, NVL(WDD.LINE_DIRECTION
, 'O')
, WDD.PARTY_ID
, WDD.ROUTING_REQ_ID
, WDD.SHIPPING_CONTROL
, WDD.SOURCE_BLANKET_REFERENCE_ID
, WDD.SOURCE_BLANKET_REFERENCE_NUM
, WDD.PO_SHIPMENT_LINE_ID
, WDD.PO_SHIPMENT_LINE_NUMBER
, WDD.RETURNED_QUANTITY
, WDD.RETURNED_QUANTITY2
, WDD.SOURCE_LINE_TYPE_CODE
, WDD.RCV_SHIPMENT_LINE_ID
, WDD.SUPPLIER_ITEM_NUMBER
, WDD.VENDOR_ID
, WDD.SHIP_FROM_SITE_ID
, WDD.EARLIEST_PICKUP_DATE
, WDD.LATEST_PICKUP_DATE
, WDD.EARLIEST_DROPOFF_DATE
, WDD.LATEST_DROPOFF_DATE
, WDD.REQUEST_DATE_TYPE_CODE
, WDD.TP_DELIVERY_DETAIL_ID
, WDD.SOURCE_DOCUMENT_TYPE_ID
, WDD.PO_REVISION_NUMBER
, WDD.RELEASE_REVISION_NUMBER
FROM WSH_DELIVERY_DETAILS WDD
, WSH_DELIVERY_ASSIGNMENTS WDA
, WSH_LOOKUPS WL_SOURCE
, WSH_LOOKUPS WL_RELEASED
WHERE WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
AND WL_SOURCE.LOOKUP_TYPE = 'SOURCE_SYSTEM'
AND WL_SOURCE.LOOKUP_CODE = WDD.SOURCE_CODE
AND WL_RELEASED.LOOKUP_TYPE = 'PICK_STATUS'
AND WL_RELEASED.LOOKUP_CODE = NVL(WDD.RELEASED_STATUS
, 'X')
AND WDA.DELIVERY_ID IS NOT NULL
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO')

Columns