View: WSH_TRIP_DELIVERABLES_V

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

View Text

SELECT T.TRIP_ID
, TO_NUMBER(NULL)
, WDV.ROW_ID
, WDV.TYPE
, WDV.DELIVERY_DETAIL_ID
, WDV.DELIVERY_LINE_ID
, WDV.CONTAINER_INSTANCE_ID
, WDV.CONTAINER_NAME
, WDV.DELIVERY_ID
, WDV.SOURCE_CODE
, WDV.SOURCE_NAME
, WDV.SOURCE_HEADER_ID
, WDV.SOURCE_LINE_ID
, WDV.SOURCE_HEADER_NUMBER
, WDV.SOURCE_HEADER_TYPE_ID
, WDV.SOURCE_HEADER_TYPE_NAME
, WDV.SOURCE_LINE_NUMBER
, WDV.SRC_REQUESTED_QUANTITY
, WDV.SRC_REQUESTED_QUANTITY_UOM
, WDV.CUSTOMER_ID
, WDV.SOLD_TO_CONTACT_ID
, WDV.INVENTORY_ITEM_ID
, WDV.ITEM_DESCRIPTION
, WDV.COUNTRY_OF_ORIGIN
, WDV.CLASSIFICATION
, WDV.SHIP_FROM_LOCATION_ID
, WDV.SHIP_TO_LOCATION_ID
, WDV.SHIP_TO_CONTACT_ID
, WDV.DELIVER_TO_LOCATION_ID
, WDV.DELIVER_TO_CONTACT_ID
, WDV.INTMED_SHIP_TO_LOCATION_ID
, WDV.INTMED_SHIP_TO_CONTACT_ID
, WDV.SHIP_TOLERANCE_ABOVE
, WDV.SHIP_TOLERANCE_BELOW
, WDV.REQUESTED_QUANTITY
, WDV.SHIPPED_QUANTITY
, WDV.DELIVERED_QUANTITY
, WDV.CANCELLED_QUANTITY
, WDV.REQUESTED_QUANTITY_UOM
, WDV.SUBINVENTORY
, WDV.REVISION
, WDV.LOT_NUMBER
, WDV.CUSTOMER_REQUESTED_LOT_FLAG
, WDV.SERIAL_NUMBER
, WDV.LOCATOR_ID
, WDV.DATE_REQUESTED
, WDV.DATE_SCHEDULED
, WDV.MASTER_CONTAINER_ITEM_ID
, WDV.DETAIL_CONTAINER_ITEM_ID
, WDV.LOAD_SEQ_NUMBER
, WDV.SHIP_METHOD_CODE
, WDV.CARRIER_ID
, WDV.FREIGHT_TERMS_CODE
, WDV.SHIPMENT_PRIORITY_CODE
, WDV.FOB_CODE
, WDV.CUSTOMER_ITEM_ID
, WDV.DEP_PLAN_REQUIRED_FLAG
, WDV.CUSTOMER_PROD_SEQ
, WDV.CUSTOMER_DOCK_CODE
, WDV.UNIT_WEIGHT
, WDV.UNIT_VOLUME
, WDV.WV_FROZEN_FLAG
, WDV.GROSS_WEIGHT
, WDV.TARE_WEIGHT
, WDV.NET_WEIGHT
, WDV.WEIGHT_UOM_CODE
, WDV.FILLED_VOLUME
, WDV.VOLUME
, WDV.VOLUME_UOM_CODE
, WDV.FILL_PERCENT
, WDV.MAXIMUM_LOAD_WEIGHT
, WDV.MAXIMUM_VOLUME
, WDV.MINIMUM_FILL_PERCENT
, WDV.MVT_STAT_STATUS
, WDV.RELEASED_STATUS
, WDV.RELEASED_STATUS_NAME
, WDV.ORGANIZATION_ID
, WDV.TRANSACTION_TEMP_ID
, WDV.SHIP_SET_ID
, WDV.ARRIVAL_SET_ID
, WDV.SHIP_MODEL_COMPLETE_FLAG
, WDV.TOP_MODEL_LINE_ID
, WDV.HOLD_CODE
, WDV.CUST_PO_NUMBER
, WDV.ATO_LINE_ID
, WDV.MOVE_ORDER_LINE_ID
, WDV.HAZARD_CLASS_ID
, WDV.QUALITY_CONTROL_QUANTITY
, WDV.CYCLE_COUNT_QUANTITY
, WDV.TRACKING_NUMBER
, WDV.MOVEMENT_ID
, WDV.SHIPPING_INSTRUCTIONS
, WDV.PACKING_INSTRUCTIONS
, WDV.PROJECT_ID
, WDV.TASK_ID
, WDV.ORG_ID
, WDV.OE_INTERFACED_FLAG
, WDV.SPLIT_FROM_DELIVERY_DETAIL_ID
, WDV.INV_INTERFACED_FLAG
, WDV.PARENT_CONTAINER_INSTANCE_ID
, WDV.MASTER_SERIAL_NUMBER
, WDV.CONTAINER_FLAG
, WDV.CONTAINER_TYPE_CODE
, WDV.SEAL_CODE
, DECODE(PICKUP_STOP.STATUS_CODE
, 'OP'
, 'RE'
, 'AR'
, 'LO'
, 'CL'
, DECODE(DROPOFF_STOP.STATUS_CODE
, 'OP'
, 'OB'
, 'AR'
, 'UL'
, 'CL'
, 'CO')) ACTIVITY_CODE
, WDV.ATTRIBUTE_CATEGORY
, WDV.ATTRIBUTE1
, WDV.ATTRIBUTE2
, WDV.ATTRIBUTE3
, WDV.ATTRIBUTE4
, WDV.ATTRIBUTE5
, WDV.ATTRIBUTE6
, WDV.ATTRIBUTE7
, WDV.ATTRIBUTE8
, WDV.ATTRIBUTE9
, WDV.ATTRIBUTE10
, WDV.ATTRIBUTE11
, WDV.ATTRIBUTE12
, WDV.ATTRIBUTE13
, WDV.ATTRIBUTE14
, WDV.ATTRIBUTE15
, WDV.TP_ATTRIBUTE_CATEGORY
, WDV.TP_ATTRIBUTE1
, WDV.TP_ATTRIBUTE2
, WDV.TP_ATTRIBUTE3
, WDV.TP_ATTRIBUTE4
, WDV.TP_ATTRIBUTE5
, WDV.TP_ATTRIBUTE6
, WDV.TP_ATTRIBUTE7
, WDV.TP_ATTRIBUTE8
, WDV.TP_ATTRIBUTE9
, WDV.TP_ATTRIBUTE10
, WDV.TP_ATTRIBUTE11
, WDV.TP_ATTRIBUTE12
, WDV.TP_ATTRIBUTE13
, WDV.TP_ATTRIBUTE14
, WDV.TP_ATTRIBUTE15
, WDV.CREATION_DATE
, WDV.CREATED_BY
, WDV.LAST_UPDATE_DATE
, WDV.LAST_UPDATED_BY
, WDV.LAST_UPDATE_LOGIN
, WDV.PROGRAM_APPLICATION_ID
, WDV.PROGRAM_ID
, WDV.PROGRAM_UPDATE_DATE
, WDV.REQUEST_ID
, WDV.PREFERRED_GRADE
, WDV.SHIPPED_QUANTITY2
, WDV.DELIVERED_QUANTITY2
, WDV.CANCELLED_QUANTITY2
, WDV.REQUESTED_QUANTITY2
, WDV.REQUESTED_QUANTITY_UOM2
, WDV.SRC_REQUESTED_QUANTITY2
, WDV.SRC_REQUESTED_QUANTITY_UOM2
, WDV.QUALITY_CONTROL_QUANTITY2
, WDV.CYCLE_COUNT_QUANTITY2
, WDV.UNIT_NUMBER
, WDV.UNIT_PRICE
, WDV.CURRENCY_CODE
, WDV.FREIGHT_CLASS_CAT_ID
, WDV.COMMODITY_CODE_CAT_ID
, WDV.INSPECTION_FLAG
, WDV.PICKABLE_FLAG
, WDV.SHIP_TO_SITE_USE_ID
, WDV.DELIVER_TO_SITE_USE_ID
, WDV.TO_SERIAL_NUMBER
, WDV.PICKED_QUANTITY
, WDV.PICKED_QUANTITY2
, WDV.CUSTOMER_PRODUCTION_LINE
, WDV.CUSTOMER_JOB
, WDV.CUST_MODEL_SERIAL_NUMBER
, WDV.RECEIVED_QUANTITY
, WDV.RECEIVED_QUANTITY2
, WDV.SOURCE_LINE_SET_ID
, WDV.BATCH_ID
, WDV.LPN_ID
, WDV.ORIGINAL_SUBINVENTORY
, WDV.IGNORE_FOR_PLANNING
, WDV.SERVICE_LEVEL
, WDV.MODE_OF_TRANSPORT
, WDV.LINE_DIRECTION
, WDV.PARTY_ID
, WDV.ROUTING_REQ_ID
, WDV.SHIPPING_CONTROL
, WDV.SOURCE_BLANKET_REFERENCE_ID
, WDV.SOURCE_BLANKET_REFERENCE_NUM
, WDV.PO_SHIPMENT_LINE_ID
, WDV.PO_SHIPMENT_LINE_NUMBER
, WDV.RETURNED_QUANTITY
, WDV.RETURNED_QUANTITY2
, WDV.SOURCE_LINE_TYPE_CODE
, WDV.RCV_SHIPMENT_LINE_ID
, WDV.SUPPLIER_ITEM_NUMBER
, WDV.VENDOR_ID
, WDV.SHIP_FROM_SITE_ID
, WDV.EARLIEST_PICKUP_DATE
, WDV.LATEST_PICKUP_DATE
, WDV.EARLIEST_DROPOFF_DATE
, WDV.LATEST_DROPOFF_DATE
, WDV.REQUEST_DATE_TYPE_CODE
, WDV.TP_DELIVERY_DETAIL_ID
, WDV.SOURCE_DOCUMENT_TYPE_ID
, WDV.PO_REVISION_NUMBER
, WDV.RELEASE_REVISION_NUMBER
, WDV.REPLENISHMENT_STATUS
, WDV.REFERENCE_NUMBER
, WDV.REFERENCE_LINE_NUMBER
, WDV.REFERENCE_LINE_QUANTITY
, WDV.REFERENCE_LINE_QUANTITY_UOM
, WDV.ORIGINAL_LOCATOR_ID
, WDV.ORIGINAL_REVISION
, WDV.ORIGINAL_LOT_NUMBER
, WDV.CLIENT_ID
, WDV.CONSIGNEE_FLAG
FROM WSH_DLVY_DELIVERABLES_V WDV
, WSH_DELIVERY_LEGS DL
, WSH_TRIP_STOPS PICKUP_STOP
, WSH_TRIP_STOPS DROPOFF_STOP
, WSH_TRIPS T
WHERE WDV.DELIVERY_ID = DL.DELIVERY_ID AND DL.PICK_UP_STOP_ID = PICKUP_STOP.STOP_ID AND DL.DROP_OFF_STOP_ID = DROPOFF_STOP.STOP_ID AND PICKUP_STOP.TRIP_ID = T.TRIP_ID

Columns