APPS.WSH_RLM_INTERFACE dependencies on WSH_DELIVERY_DETAILS

Line 909: 'FROM wsh_delivery_Details dd,wsh_trip_stops s,wsh_delivery_legs dl,'||

905: v_select_clause :=
906:
907: 'SELECT dd.delivery_detail_id,s.stop_id,s.actual_departure_date,'||
908: 'nd.name,dd.shipped_quantity, NULL, ol.ordered_item_id, ol.header_id order_hdr_id '||
909: 'FROM wsh_delivery_Details dd,wsh_trip_stops s,wsh_delivery_legs dl,'||
910: 'wsh_delivery_assignments_v da,wsh_new_deliveries nd,oe_order_lines_all ol ';
911: --
912: v_where_clause := v_where_clause ||
913: ' AND dd.source_header_id = :order_header_id';

Line 926: 'FROM wsh_delivery_Details dd,wsh_trip_stops s,wsh_delivery_legs dl,'||

922:
923: 'SELECT dd.delivery_detail_id,s.stop_id,s.actual_departure_date,'||
924: 'nd.name,dd.shipped_quantity,ol.blanket_number,ol.ordered_item_id,'||
925: 'ol.header_id order_hdr_id '||
926: 'FROM wsh_delivery_Details dd,wsh_trip_stops s,wsh_delivery_legs dl,'||
927: 'wsh_delivery_assignments_v da,wsh_new_deliveries nd,oe_order_lines_all ol ';
928: --
929: v_where_clause := v_where_clause ||
930: ' AND ol.blanket_number = :blanket_number' ||

Line 997: WSH_DELIVERY_DETAILS DET,

993: FROM WSH_TRIP_STOPS STP
994: WHERE STP.STOP_ID in
995: ( SELECT distinct(LEG.PICK_UP_STOP_ID)
996: FROM
997: WSH_DELIVERY_DETAILS DET,
998: WSH_NEW_DELIVERIES DEL,
999: WSH_DELIVERY_LEGS LEG,
1000: wsh_delivery_assignments_v ASG
1001: WHERE