DBA Data[Home] [Help]

APPS.WSH_INV_INTEGRATION_GRP dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 153: wsh_delivery_assignments_v da ,

149: CURSOR detail_rec_csr IS
150: SELECT st.stop_id, wdd.delivery_detail_id
151: FROM wsh_delivery_details wdd,
152: mtl_transactions_interface mtf,
153: wsh_delivery_assignments_v da ,
154: wsh_delivery_legs dg,
155: wsh_new_deliveries dl,
156: wsh_trip_stops st
157: WHERE wdd.delivery_detail_id = mtf.picking_line_id

Line 192: wsh_delivery_assignments_v wda,

188: CURSOR c_lines_not_interfaced(p_stop_id NUMBER) IS
189: SELECT wdd.delivery_detail_id
190: FROM wsh_trip_stops wts,
191: wsh_delivery_legs wdl,
192: wsh_delivery_assignments_v wda,
193: wsh_delivery_details wdd
194: WHERE (wdd.inv_interfaced_flag IN ('N', 'P') OR wdd.oe_interfaced_flag <> 'Y')
195: AND wts.stop_id = p_stop_id
196: AND wts.stop_location_id = wdd.ship_from_location_id