APPS.WMS_CONSOLIDATION_PUB dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 448: wsh_delivery_details_ob_grp_v wdd

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
451: AND wdd.released_status = 'Y'
452: AND wnd.organization_id = p_organization_id

Line 584: wsh_delivery_details_ob_grp_v wdd,

580: wda.delivery_id,
581: --c.customer_name -- Commented for Bug# 4579790
582: party.party_name customer_name -- Added for Bug# 4579790
583: FROM
584: wsh_delivery_details_ob_grp_v wdd,
585: wsh_delivery_assignments_v wda,
586: -- ra_customers c, -- Commented for Bug# 4579790
587: hz_parties party, -- Added for Bug# 4579790
588: hz_cust_accounts cust_acct -- Added for Bug# 4579790

Line 2731: Wsh_Delivery_Details_Ob_Grp_v Wdd,

2727: l_from_sub,
2728: l_from_loc
2729: From Mtl_Material_Transactions Mmt,
2730: Wms_Dispatched_Tasks_History Wdth,
2731: Wsh_Delivery_Details_Ob_Grp_v Wdd,
2732: Wsh_Delivery_Assignments Wda,
2733: Wsh_Delivery_Details_Ob_Grp_v Wddc,
2734: Wms_License_Plate_Numbers Wlpn
2735: Where 1 = 1

Line 2733: Wsh_Delivery_Details_Ob_Grp_v Wddc,

2729: From Mtl_Material_Transactions Mmt,
2730: Wms_Dispatched_Tasks_History Wdth,
2731: Wsh_Delivery_Details_Ob_Grp_v Wdd,
2732: Wsh_Delivery_Assignments Wda,
2733: Wsh_Delivery_Details_Ob_Grp_v Wddc,
2734: Wms_License_Plate_Numbers Wlpn
2735: Where 1 = 1
2736: And Decode(Mmt.Transfer_Transaction_Id,
2737: Null,