DBA Data[Home] [Help]

APPS.MST_RELEASE dependencies on WSH_DELIVERY_DETAILS

Line 1356: from wsh_delivery_details wdd

1352: procedure update_ids_in_wdd_iface_tab (p_release_id in pls_integer) is
1353: cursor cur_wdd_ids (l_release_id in pls_integer)
1354: is
1355: select wdd_iface.delivery_detail_interface_id, min(wdd.source_header_id), min(wdd.source_line_id), min(wdd.source_line_set_id)
1356: from wsh_delivery_details wdd
1357: , mst_release_temp_gt mrt
1358: , wsh_del_details_interface wdd_iface
1359: where wdd.source_code = wdd_iface.source_code
1360: and wdd.source_header_number = wdd_iface.source_header_number

Line 1395: , wsh_delivery_details wdd

1391: select wda_iface.delivery_interface_id, wdd_iface.delivery_detail_interface_id, mplav.cust_location_id
1392: from mst_po_location_asso_v mplav
1393: , wsh_del_details_interface wdd_iface
1394: , wsh_del_assgn_interface wda_iface
1395: , wsh_delivery_details wdd
1396: , mst_release_temp_gt mrt
1397: where mplav.location_id = wdd_iface.ship_to_location_id
1398: and wdd_iface.delivery_detail_id = wdd.delivery_detail_id
1399: and wdd.ship_to_location_id <> wdd_iface.ship_to_location_id

Line 2137: , wsh_delivery_details wdd

2133: , l_date
2134: , l_user
2135: , l_user
2136: from mst_release_temp_gt mrt
2137: , wsh_delivery_details wdd
2138: where mrt.release_id = p_release_id
2139: and mrt.sr_delivery_detail_id = wdd.delivery_detail_id (+)
2140: and mrt.delivery_detail_id is not null
2141: );