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
446: AND wdd.released_status = 'Y'
447: AND wnd.organization_id = p_organization_id
575: wda.delivery_id,
576: --c.customer_name -- Commented for Bug# 4579790
577: party.party_name customer_name -- Added for Bug# 4579790
578: FROM
579: wsh_delivery_details_ob_grp_v wdd,
580: wsh_delivery_assignments_v wda,
581: -- ra_customers c, -- Commented for Bug# 4579790
582: hz_parties party, -- Added for Bug# 4579790
583: hz_cust_accounts cust_acct -- Added for Bug# 4579790