WSH_INV_DELIVERY_DETAILS_V

Details

• Schema: FUSION

• Object owner: WSH

• Object type: VIEW

Columns

Name
OE_HEADER_ID TRIP_STOP_ID OE_LINE_ID SHIPPING_DELIVERY_ID SHIP_TO_LOCATION SHIP_FROM_LOCATION SHIPMENT_PRIORITY_CODE SHIPMENT_NUMBER FREIGHT_CODE MOVE_ORDER_LINE_ID RELEASED_STATUS DELIVERY_DETAIL_ID SHIP_TO_PARTY_ID SHIP_TO_PARTY_NUMBER SOLD_TO_PARTY_ID SOLD_TO_PARTY_NUMBER SOURCE_LINE_NUMBER SOURCE_DOCUMENT_TYPE_ID

Query

SQL_Statement

SELECT wdd.source_header_id oe_header_id, null trip_stop_id, wdd.source_line_id oe_line_id, wda.delivery_id shipping_delivery_id, wlt.source_location_id ship_to_location, wlf.source_location_id ship_FROM_location, wdd.shipment_priority_code shipment_priority_code, null shipment_number, wdd.ship_method_code freight_code, wdd.move_order_line_id move_order_line_id, wdd.released_status, wdd.delivery_detail_id, WDD.SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID, ShipToParty.party_number SHIP_TO_PARTY_NUMBER, WDD.SOLD_TO_PARTY_ID SOLD_TO_PARTY_ID, SoldToParty.PARTY_NUMBER SOLD_TO_PARTY_NUMBER, WDD.SOURCE_LINE_NUMBER, wdd.SOURCE_DOCUMENT_TYPE_ID FROM wsh_delivery_details wdd, wsh_delivery_assignments wda, hz_parties ShipToParty, hz_parties SoldToParty, wsh_new_deliveries wnd, wsh_locations_v wlt, wsh_locations_v wlf WHERE wnd.delivery_id(+) = wda.delivery_id AND wdd.delivery_detail_id = wda.delivery_detail_id AND wdd.ship_FROM_location_id = wlf.source_location_id (+) AND 'I' = wlf.location_type (+) AND wdd.ship_to_location_id = wlt.source_location_id (+) AND wdd.ship_to_location_type = wlt.location_type (+) AND NVL(wnd.delivery_type,'STANDARD') = 'STANDARD' AND wdd.ship_to_party_id = ShipToParty.party_id AND wdd.Sold_to_party_id = SoldToParty.party_id(+)