APPS.INV_LABEL_PVT3 dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 174: FROM wms_license_plate_numbers lpn, rcv_transactions rt

170: SELECT lpn.parent_lpn_id
171: , rt.po_header_id
172: , rt.subinventory
173: , rt.locator_id
174: FROM wms_license_plate_numbers lpn, rcv_transactions rt
175: WHERE lpn.lpn_id = rt.lpn_id
176: -- AND lpn.parent_lpn_id <> rt.lpn_id
177: AND rt.group_id = p_transaction_id
178: AND lpn.parent_lpn_id is not null

Line 195: FROM wms_license_plate_numbers lpn, rcv_transactions rt

191: SELECT lpn.outermost_lpn_id
192: , rt.po_header_id
193: , rt.subinventory
194: , rt.locator_id
195: FROM wms_license_plate_numbers lpn, rcv_transactions rt
196: WHERE lpn.lpn_id = rt.lpn_id
197: -- AND lpn.outermost_lpn_id <> lpn.lpn_id
198: -- AND lpn.outermost_lpn_id <> lpn.parent_lpn_id
199: AND rt.group_id = p_transaction_id

Line 236: FROM wms_license_plate_numbers lpn, rcv_transactions rt

232: SELECT lpn.parent_lpn_id
233: , rt.po_header_id
234: , rt.subinventory
235: , rt.locator_id
236: FROM wms_license_plate_numbers lpn, rcv_transactions rt
237: WHERE lpn.lpn_id = rt.transfer_lpn_id
238: -- AND rt.transfer_lpn_id <> rt.lpn_id
239: -- AND lpn.parent_lpn_id <> lpn.lpn_id
240: AND lpn.parent_lpn_id is not null

Line 258: FROM wms_license_plate_numbers lpn, rcv_transactions rt

254: SELECT lpn.outermost_lpn_id
255: , rt.po_header_id
256: , rt.subinventory
257: , rt.locator_id
258: FROM wms_license_plate_numbers lpn, rcv_transactions rt
259: WHERE lpn.lpn_id = rt.transfer_lpn_id
260: -- AND rt.transfer_lpn_id <> rt.lpn_id
261: -- AND lpn.outermost_lpn_id <> lpn.lpn_id
262: -- AND lpn.outermost_lpn_id <> lpn.parent_lpn_id

Line 275: , wms_license_plate_numbers wlpn -- Bug 3836623

271: AND p_label_type_info.business_flow_code = 1
272: )
273: )) all_lpn
274: , po_headers_all pha
275: , wms_license_plate_numbers wlpn -- Bug 3836623
276: WHERE pha.po_header_id(+) = all_lpn.po_header_id
277: -- Bug 3836623
278: -- Add check for LPN context
279: -- When cross docking happens, label printing are called for both cross docking and putaway

Line 328: FROM wms_license_plate_numbers lpn

324: , lpn.attribute12 attribute12
325: , lpn.attribute13 attribute13
326: , lpn.attribute14 attribute14
327: , lpn.attribute15 attribute15
328: FROM wms_license_plate_numbers lpn
329: , wms_license_plate_numbers plpn
330: , wms_license_plate_numbers olpn
331: , mtl_system_items_kfv msik
332: , mtl_parameters mp

Line 329: , wms_license_plate_numbers plpn

325: , lpn.attribute13 attribute13
326: , lpn.attribute14 attribute14
327: , lpn.attribute15 attribute15
328: FROM wms_license_plate_numbers lpn
329: , wms_license_plate_numbers plpn
330: , wms_license_plate_numbers olpn
331: , mtl_system_items_kfv msik
332: , mtl_parameters mp
333: , mtl_item_locations milkfv

Line 330: , wms_license_plate_numbers olpn

326: , lpn.attribute14 attribute14
327: , lpn.attribute15 attribute15
328: FROM wms_license_plate_numbers lpn
329: , wms_license_plate_numbers plpn
330: , wms_license_plate_numbers olpn
331: , mtl_system_items_kfv msik
332: , mtl_parameters mp
333: , mtl_item_locations milkfv
334: WHERE lpn.lpn_id = p_lpn_id

Line 400: from wms_license_plate_numbers lpn,

396: , rsl.po_header_id, rsl.po_line_id
397: , lpn.subinventory_code, lpn.locator_id
398: , rsh.shipment_header_id
399: , rsl.po_line_location_id
400: from wms_license_plate_numbers lpn,
401: rcv_shipment_headers rsh,
402: rcv_shipment_lines rsl
403: where lpn.source_name = rsh.shipment_num
404: AND lpn.lpn_context = 7

Line 415: from wms_license_plate_numbers lpn,

411: , rsl.po_header_id, rsl.po_line_id
412: , lpn.subinventory_code, lpn.locator_id
413: , rsh.shipment_header_id
414: , rsl.po_line_location_id
415: from wms_license_plate_numbers lpn,
416: rcv_shipment_headers rsh,
417: rcv_shipment_lines rsl
418: where lpn.source_name = rsh.shipment_num
419: AND lpn.lpn_context = 7

Line 430: from wms_license_plate_numbers lpn,

426: , rsl.po_header_id, rsl.po_line_id
427: , lpn.subinventory_code, lpn.locator_id
428: , rsh.shipment_header_id
429: , rsl.po_line_location_id
430: from wms_license_plate_numbers lpn,
431: rcv_shipment_headers rsh,
432: rcv_shipment_lines rsl
433: where lpn.source_name = rsh.shipment_num
434: AND lpn.lpn_context = 7