VIEW: APPS.WSH_DEL_DTL_ASSGN_V

Source

View Text - Preformatted

SELECT wda.Delivery_Interface_id, wdd.DELIVERY_DETAIL_INTERFACE_ID, wdd.DELIVERY_DETAIL_ID, wdd.SOURCE_CODE, wdd.SOURCE_HEADER_ID, wdd.SOURCE_LINE_ID, wdd.CUSTOMER_ID, wdd.SOLD_TO_CONTACT_ID, wdd.INVENTORY_ITEM_ID, wdd.ITEM_DESCRIPTION, wdd.COUNTRY_OF_ORIGIN, 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.CANCELLED_QUANTITY, wdd.SHIPPED_QUANTITY, wdd.DELIVERED_QUANTITY, wdd.REQUESTED_QUANTITY_UOM, wdd.SHIPPING_QUANTITY_UOM, wdd.SUBINVENTORY, wdd.REVISION, wdd.LOT_NUMBER, wdd.CUSTOMER_REQUESTED_LOT_FLAG, wdd.SERIAL_NUMBER, 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.GROSS_WEIGHT, wdd.NET_WEIGHT, wdd.WEIGHT_UOM_CODE, wdd.VOLUME, wdd.VOLUME_UOM_CODE, 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.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.CREATION_DATE, wdd.CREATED_BY, wdd.LAST_UPDATE_DATE, wdd.LAST_UPDATE_LOGIN, wdd.PROGRAM_APPLICATION_ID, wdd.PROGRAM_ID, wdd.PROGRAM_UPDATE_DATE, wdd.REQUEST_ID, wdd.INTERFACE_ACTION_CODE, wdd.LOCK_FLAG, wdd.PROCESS_FLAG, wdd.PROCESS_MODE, wdd.DELETE_FLAG, wdd.PROCESS_STATUS_FLAG, wdd.SOURCE_HEADER_NUMBER, wdd.SOURCE_HEADER_TYPE_ID, wdd.SOURCE_HEADER_TYPE_NAME, wdd.CUST_PO_NUMBER, wdd.SHIP_SET_ID, wdd.ARRIVAL_SET_ID, wdd.TOP_MODEL_LINE_ID, wdd.ATO_LINE_ID, wdd.SHIP_MODEL_COMPLETE_FLAG, wdd.HAZARD_CLASS_ID, wdd.CLASSIFICATION, wdd.ORGANIZATION_ID, wdd.SRC_REQUESTED_QUANTITY, wdd.SRC_REQUESTED_QUANTITY_UOM, wdd.QUALITY_CONTROL_QUANTITY, wdd.CYCLE_COUNT_QUANTITY, wdd.MOVE_ORDER_LINE_ID, wdd.LOCATOR_ID, wdd.MVT_STAT_STATUS, wdd.TRANSACTION_TEMP_ID, 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.COMMODITY_CODE_CAT_ID, wdd.CONTAINER_FLAG, wdd.CONTAINER_NAME, wdd.CONTAINER_TYPE_CODE, wdd.CURRENCY_CODE, wdd.CUST_MODEL_SERIAL_NUMBER, wdd.CUSTOMER_JOB, wdd.CUSTOMER_PRODUCTION_LINE, wdd.DELIVER_TO_SITE_USE_ID, wdd.FILL_PERCENT, wdd.FREIGHT_CLASS_CAT_ID, wdd.INSPECTION_FLAG, wdd.LPN_CONTENT_ID, wdd.LPN_ID, wdd.MASTER_SERIAL_NUMBER, wdd.MAXIMUM_LOAD_WEIGHT, wdd.MAXIMUM_VOLUME, wdd.MINIMUM_FILL_PERCENT, wdd.MOVEMENT_ID, wdd.ORG_ID, wdd.ORIGINAL_SUBINVENTORY, wdd.PACKING_INSTRUCTIONS, wdd.PICKED_QUANTITY, wdd.PICKED_QUANTITY2, wdd.PROJECT_ID, wdd.SEAL_CODE, wdd.SHIP_TO_SITE_USE_ID, wdd.SHIPPING_INSTRUCTIONS, wdd.SOURCE_LINE_NUMBER, wdd.SPLIT_FROM_DELIVERY_DETAIL_ID, wdd.TASK_ID, wdd.TO_SERIAL_NUMBER, wdd.TRACKING_NUMBER, wdd.UNIT_NUMBER, wdd.UNIT_PRICE, wdd.CARRIER_CODE, wdd.COMMODITY_CODE_CAT_CODE, wdd.CUSTOMER_NUMBER, wdd.CUSTOMER_ITEM_NUMBER, wdd.DELIVER_TO_LOCATION_CODE, wdd.DETAIL_CONTAINER_ITEM_CODE, wdd.FREIGHT_CLASS_CAT_CODE, wdd.HAZARD_CLASS_CODE, wdd.INTMED_SHIP_TO_LOCATION_CODE, wdd.ITEM_NUMBER, wdd.LOCATOR_CODE, wdd.MASTER_CONTAINER_ITEM_NUMBER, wdd.ORGANIZATION_CODE, wdd.SHIP_FROM_LOCATION_CODE, wdd.SHIP_TO_LOCATION_CODE, wdd.CUSTOMER_NAME, wdd.LAST_UPDATED_BY, WDD.WV_FROZEN_FLAG, WDD.FILLED_VOLUME , nvl(wdd.line_direction,'O') line_direction, wdd.request_date_type_code request_date_type_code, wdd.earliest_pickup_date earliest_pickup_date, wdd.latest_pickup_date latest_pickup_date, wdd.earliest_dropoff_date earliest_dropoff_date, wdd.latest_dropoff_date latest_dropoff_date, wdd.line_number line_number , wdd.unit_selling_price unit_selling_price , wdd.ship_set_name ship_set_name FROM wsh_del_details_interface wdd, wsh_del_assgn_interface wda WHERE wda.Delivery_Detail_Interface_ID = wdd.Delivery_Detail_Interface_ID

View Text - HTML Formatted

SELECT WDA.DELIVERY_INTERFACE_ID
, WDD.DELIVERY_DETAIL_INTERFACE_ID
, WDD.DELIVERY_DETAIL_ID
, WDD.SOURCE_CODE
, WDD.SOURCE_HEADER_ID
, WDD.SOURCE_LINE_ID
, WDD.CUSTOMER_ID
, WDD.SOLD_TO_CONTACT_ID
, WDD.INVENTORY_ITEM_ID
, WDD.ITEM_DESCRIPTION
, WDD.COUNTRY_OF_ORIGIN
, 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.CANCELLED_QUANTITY
, WDD.SHIPPED_QUANTITY
, WDD.DELIVERED_QUANTITY
, WDD.REQUESTED_QUANTITY_UOM
, WDD.SHIPPING_QUANTITY_UOM
, WDD.SUBINVENTORY
, WDD.REVISION
, WDD.LOT_NUMBER
, WDD.CUSTOMER_REQUESTED_LOT_FLAG
, WDD.SERIAL_NUMBER
, 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.GROSS_WEIGHT
, WDD.NET_WEIGHT
, WDD.WEIGHT_UOM_CODE
, WDD.VOLUME
, WDD.VOLUME_UOM_CODE
, 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.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.CREATION_DATE
, WDD.CREATED_BY
, WDD.LAST_UPDATE_DATE
, WDD.LAST_UPDATE_LOGIN
, WDD.PROGRAM_APPLICATION_ID
, WDD.PROGRAM_ID
, WDD.PROGRAM_UPDATE_DATE
, WDD.REQUEST_ID
, WDD.INTERFACE_ACTION_CODE
, WDD.LOCK_FLAG
, WDD.PROCESS_FLAG
, WDD.PROCESS_MODE
, WDD.DELETE_FLAG
, WDD.PROCESS_STATUS_FLAG
, WDD.SOURCE_HEADER_NUMBER
, WDD.SOURCE_HEADER_TYPE_ID
, WDD.SOURCE_HEADER_TYPE_NAME
, WDD.CUST_PO_NUMBER
, WDD.SHIP_SET_ID
, WDD.ARRIVAL_SET_ID
, WDD.TOP_MODEL_LINE_ID
, WDD.ATO_LINE_ID
, WDD.SHIP_MODEL_COMPLETE_FLAG
, WDD.HAZARD_CLASS_ID
, WDD.CLASSIFICATION
, WDD.ORGANIZATION_ID
, WDD.SRC_REQUESTED_QUANTITY
, WDD.SRC_REQUESTED_QUANTITY_UOM
, WDD.QUALITY_CONTROL_QUANTITY
, WDD.CYCLE_COUNT_QUANTITY
, WDD.MOVE_ORDER_LINE_ID
, WDD.LOCATOR_ID
, WDD.MVT_STAT_STATUS
, WDD.TRANSACTION_TEMP_ID
, 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.COMMODITY_CODE_CAT_ID
, WDD.CONTAINER_FLAG
, WDD.CONTAINER_NAME
, WDD.CONTAINER_TYPE_CODE
, WDD.CURRENCY_CODE
, WDD.CUST_MODEL_SERIAL_NUMBER
, WDD.CUSTOMER_JOB
, WDD.CUSTOMER_PRODUCTION_LINE
, WDD.DELIVER_TO_SITE_USE_ID
, WDD.FILL_PERCENT
, WDD.FREIGHT_CLASS_CAT_ID
, WDD.INSPECTION_FLAG
, WDD.LPN_CONTENT_ID
, WDD.LPN_ID
, WDD.MASTER_SERIAL_NUMBER
, WDD.MAXIMUM_LOAD_WEIGHT
, WDD.MAXIMUM_VOLUME
, WDD.MINIMUM_FILL_PERCENT
, WDD.MOVEMENT_ID
, WDD.ORG_ID
, WDD.ORIGINAL_SUBINVENTORY
, WDD.PACKING_INSTRUCTIONS
, WDD.PICKED_QUANTITY
, WDD.PICKED_QUANTITY2
, WDD.PROJECT_ID
, WDD.SEAL_CODE
, WDD.SHIP_TO_SITE_USE_ID
, WDD.SHIPPING_INSTRUCTIONS
, WDD.SOURCE_LINE_NUMBER
, WDD.SPLIT_FROM_DELIVERY_DETAIL_ID
, WDD.TASK_ID
, WDD.TO_SERIAL_NUMBER
, WDD.TRACKING_NUMBER
, WDD.UNIT_NUMBER
, WDD.UNIT_PRICE
, WDD.CARRIER_CODE
, WDD.COMMODITY_CODE_CAT_CODE
, WDD.CUSTOMER_NUMBER
, WDD.CUSTOMER_ITEM_NUMBER
, WDD.DELIVER_TO_LOCATION_CODE
, WDD.DETAIL_CONTAINER_ITEM_CODE
, WDD.FREIGHT_CLASS_CAT_CODE
, WDD.HAZARD_CLASS_CODE
, WDD.INTMED_SHIP_TO_LOCATION_CODE
, WDD.ITEM_NUMBER
, WDD.LOCATOR_CODE
, WDD.MASTER_CONTAINER_ITEM_NUMBER
, WDD.ORGANIZATION_CODE
, WDD.SHIP_FROM_LOCATION_CODE
, WDD.SHIP_TO_LOCATION_CODE
, WDD.CUSTOMER_NAME
, WDD.LAST_UPDATED_BY
, WDD.WV_FROZEN_FLAG
, WDD.FILLED_VOLUME
, NVL(WDD.LINE_DIRECTION
, 'O') LINE_DIRECTION
, WDD.REQUEST_DATE_TYPE_CODE REQUEST_DATE_TYPE_CODE
, WDD.EARLIEST_PICKUP_DATE EARLIEST_PICKUP_DATE
, WDD.LATEST_PICKUP_DATE LATEST_PICKUP_DATE
, WDD.EARLIEST_DROPOFF_DATE EARLIEST_DROPOFF_DATE
, WDD.LATEST_DROPOFF_DATE LATEST_DROPOFF_DATE
, WDD.LINE_NUMBER LINE_NUMBER
, WDD.UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, WDD.SHIP_SET_NAME SHIP_SET_NAME
FROM WSH_DEL_DETAILS_INTERFACE WDD
, WSH_DEL_ASSGN_INTERFACE WDA
WHERE WDA.DELIVERY_DETAIL_INTERFACE_ID = WDD.DELIVERY_DETAIL_INTERFACE_ID