VIEW: APPS.WSH_TRIP_DELIVERABLES_V

Source

View Text - Preformatted

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.shipment_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

View Text - HTML Formatted

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.SHIPMENT_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