DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on WSH_NEW_DELIVERIES

Line 419: wsh_new_deliveries wnd,

415: wnd.name Delivery,
416: wnd.delivery_id,
417: inv_shipping_transaction_pub.get_shipmethod_meaning(wnd.ship_method_code)
418: FROM
419: wsh_new_deliveries wnd,
420: wsh_delivery_assignments_v wda,
421: wsh_delivery_details wdd,
422: wms_license_plate_numbers wlpn
423: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id

Line 441: FROM wsh_new_deliveries_ob_grp_v wnd,

437: SELECT DISTINCT
438: wnd.name Delivery,
439: wnd.delivery_id,
440: inv_shipping_transaction_pub.get_shipmethod_meaning(wnd.ship_method_code)
441: FROM wsh_new_deliveries_ob_grp_v wnd,
442: wsh_delivery_assignments_v wda,
443: wsh_delivery_details_ob_grp_v wdd
444: WHERE wda.delivery_Detail_id = wdd.delivery_Detail_id
445: AND wda.delivery_id = wnd.delivery_id