DBA Data[Home] [Help]

APPS.WSH_RLM_INTERFACE dependencies on WSH_NEW_DELIVERIES

Line 910: 'wsh_delivery_assignments_v da,wsh_new_deliveries nd,oe_order_lines_all ol ';

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';
914:

Line 927: 'wsh_delivery_assignments_v da,wsh_new_deliveries nd,oe_order_lines_all ol ';

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' ||
931: ' AND dd.source_header_id IN (select rso_hdr_id FROM rlm_blanket_rso '||

Line 998: WSH_NEW_DELIVERIES DEL,

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
1002: DEL.DELIVERY_ID = ASG.DELIVERY_ID AND