DBA Data[Home] [Help]

APPS.WMS_CONSOLIDATION_PUB dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 443: wsh_delivery_details_ob_grp_v wdd

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

Line 579: wsh_delivery_details_ob_grp_v wdd,

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