APPS.INV_LABEL_PVT7 dependencies on WSH_DELIVERY_DETAILS

Line 43: wsh_delivery_details wdd

39: SELECT 'Y'
40: FROM mtl_material_transactions mmt ,
41: mtl_material_transactions_temp mmtt,
42: wsh_delivery_assignments wda,
43: wsh_delivery_details wdd
44: WHERE mmtt.transaction_temp_id = p_transaction_id
45: AND wda.delivery_id = p_delivery_id
46: AND mmt.organization_id = mmtt.organization_id
47: AND mmt.transaction_source_type_id IN (INV_GLOBALS.G_SOURCETYPE_SALESORDER,INV_GLOBALS.G_SOURCETYPE_INTORDER)

Line 115: , wsh_delivery_details wdd

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;
119:

Line 123: wsh_delivery_details wdd, mtl_material_transactions_temp mmtt

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
127: AND mmtt.transaction_temp_id = p_transaction_id;

Line 134: wsh_delivery_details wdd, mtl_material_transactions_temp mmtt

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
138: AND wnd.delivery_id (+) = wda.delivery_id

Line 156: FROM wsh_delivery_details wdd

152:
153:
154: CURSOR c_wdd_delivery_dtl_id IS
155: SELECT delivery_detail_id
156: FROM wsh_delivery_details wdd
157: WHERE wdd.move_order_line_id = l_move_order_line_id;
158:
159:
160: CURSOR c_wda_delivery_id IS

Line 168: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

164:
165: /* Combined the above three cursors into one */
166: CURSOR c_mmtt_pick_drop IS
167: SELECT wda.delivery_id, mmtt.organization_id, mmtt.transfer_subinventory
168: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
169: , mtl_material_transactions_temp mmtt
170: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
171: AND wdd.move_order_line_id = mmtt.move_order_line_id
172: AND mmtt.transaction_temp_id = p_transaction_id;

Line 182: ,wsh_delivery_details wdd

178: * New cursor to derive delivery_id with LPN */
179: CURSOR c_lpn_delivery(p_lpn_id NUMBER) IS
180: SELECT wda.delivery_id
181: FROM wsh_delivery_assignments_v wda
182: ,wsh_delivery_details wdd
183: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
184: AND wda.delivery_id IS NOT NULL
185: AND wdd.lpn_id IS NOT NULL
186: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 362: from wsh_delivery_details wdd

358: , wsh_trip_stops wts
359: , wsh_trips wt
360: --Added to fix the issue reported in the Bug#4445708
361: , ( select party_site.addressee addressee
362: from wsh_delivery_details wdd
363: , wsh_delivery_assignments wda
364: , hz_cust_site_uses_all hcsua
365: , hz_party_sites party_site
366: , hz_loc_assignments loc_assign

Line 481: -- from the wsh_delivery_details.

477: -- Old Design.
478: -- when the transactions manager calls printing for business flow of 'Pick Drop' (19) and passes the
479: -- transactions_temp_id, we derive the the transfer_lpn_id and the content_lpn_id from the MMTT and using either
480: -- the transfer_lpn_id or content_lpn_id (imp: only if transfer_lpn_id is null) derive the delivery_detail_id
481: -- from the wsh_delivery_details.
482: -- There may be no delivery at Pick Load, Pick Drop, and Cartonization is the users fails to create one.
483: -- But a delivery ID will be automatically created after ship confirm.
484: -- This means that of the business flows of Pick Load, Pick Drop, and Cartonization there may be no delivery
485: -- label printed on some ocassions mentioned above.

Line 517: FROM wsh_delivery_details wdd,

513: -- Bug 5740331 - Added the following block to fetch the sales order header.
514: BEGIN
515: SELECT DISTINCT(source_header_id)
516: INTO l_sales_order_header_id
517: FROM wsh_delivery_details wdd,
518: wsh_delivery_assignments wda
519: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
520: AND wda.delivery_id = l_delivery_id
521: AND wdd.container_flag = 'N' ;