APPS.INV_LABEL_PVT7 dependencies on WSH_NEW_DELIVERIES

Line 114: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd

110: ------------------------End of this change for Custom Labels project code--------------------
111:
112: CURSOR c_wdd_shipping IS
113: SELECT wda.delivery_id, wdd.organization_id, wdd.subinventory
114: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
115: , wsh_delivery_details wdd
116: WHERE wda.delivery_detail_id = p_transaction_id
117: AND wnd.delivery_id = wda.delivery_id
118: AND wdd.delivery_detail_id(+) = wda.delivery_detail_id;

Line 122: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd,

118: AND wdd.delivery_detail_id(+) = wda.delivery_detail_id;
119:
120: CURSOR c_cart_shipping IS
121: SELECT wda.delivery_id, mmtt.organization_id, mmtt.subinventory_code
122: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd,
123: wsh_delivery_details wdd, mtl_material_transactions_temp mmtt
124: WHERE mmtt.move_order_line_id = wdd.move_order_line_id
125: AND wda.delivery_detail_id = wdd.delivery_detail_id
126: AND wnd.delivery_id = wda.delivery_id

Line 133: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd,

129: -- Fix for Bug# 3786272. Removed the 'wms_packaging_hist' from the 'FROM' clause.
130:
131: CURSOR c_cart_shipping_pkg IS
132: SELECT DISTINCT(wda.delivery_id)
133: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd,
134: wsh_delivery_details wdd, mtl_material_transactions_temp mmtt
135: --wms_packaging_hist wph
136: WHERE mmtt.move_order_line_id = wdd.move_order_line_id (+)
137: AND wda.delivery_detail_id (+) = wdd.delivery_detail_id

Line 197: * tp_attribute_category, global_attribute_category from wsh_new_deliveries

193:
194:
195: /* Patchset J- Select attribute1..attribute15, tp_attribute1..tp_attribute15
196: *, global_attribute1..global_attribute15, attribute_category,
197: * tp_attribute_category, global_attribute_category from wsh_new_deliveries
198: */
199:
200: CURSOR c_delivery(p_delivery_id NUMBER) IS
201: SELECT wnd.delivery_id delivery_number

Line 351: wsh_new_deliveries wnd,

347: ,hz.address2 address_line_2,hz.address3 address_line_3
348: ,hz.address4 address_line_4,hz.city city,hz.postal_code postal_code
349: ,hz.state state,hz.county county,hz.country country,hz.province province
350: from hz_locations hz ) hrl1,
351: wsh_new_deliveries wnd,
352: wsh_delivery_legs wdl,
353: wsh_document_instances wdi
354: -- Bug 2878652, get carrier name and ship method name
355: , fnd_common_lookups fcl