DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on WSH_NEW_DELIVERIES

Line 424: wsh_new_deliveries wnd,

420: wnd.name Delivery,
421: wnd.delivery_id,
422: inv_shipping_transaction_pub.get_shipmethod_meaning(wnd.ship_method_code)
423: FROM
424: wsh_new_deliveries wnd,
425: wsh_delivery_assignments_v wda,
426: wsh_delivery_details wdd,
427: wms_license_plate_numbers wlpn
428: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id

Line 446: FROM wsh_new_deliveries_ob_grp_v wnd,

442: SELECT DISTINCT
443: wnd.name Delivery,
444: wnd.delivery_id,
445: inv_shipping_transaction_pub.get_shipmethod_meaning(wnd.ship_method_code)
446: FROM wsh_new_deliveries_ob_grp_v wnd,
447: wsh_delivery_assignments_v wda,
448: wsh_delivery_details_ob_grp_v wdd
449: WHERE wda.delivery_Detail_id = wdd.delivery_Detail_id
450: AND wda.delivery_id = wnd.delivery_id