APPS.INV_LABEL_PVT3 dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 201: FROM wms_license_plate_numbers lpn, rcv_transactions rt

197: SELECT lpn.parent_lpn_id
198: , rt.po_header_id
199: , rt.subinventory
200: , rt.locator_id
201: FROM wms_license_plate_numbers lpn, rcv_transactions rt
202: WHERE lpn.lpn_id = rt.lpn_id
203: -- AND lpn.parent_lpn_id <> rt.lpn_id
204: AND rt.group_id = p_transaction_id
205: AND lpn.parent_lpn_id is not null

Line 222: FROM wms_license_plate_numbers lpn, rcv_transactions rt

218: SELECT lpn.outermost_lpn_id
219: , rt.po_header_id
220: , rt.subinventory
221: , rt.locator_id
222: FROM wms_license_plate_numbers lpn, rcv_transactions rt
223: WHERE lpn.lpn_id = rt.lpn_id
224: -- AND lpn.outermost_lpn_id <> lpn.lpn_id
225: -- AND lpn.outermost_lpn_id <> lpn.parent_lpn_id
226: AND rt.group_id = p_transaction_id

Line 263: FROM wms_license_plate_numbers lpn, rcv_transactions rt

259: SELECT lpn.parent_lpn_id
260: , rt.po_header_id
261: , rt.subinventory
262: , rt.locator_id
263: FROM wms_license_plate_numbers lpn, rcv_transactions rt
264: WHERE lpn.lpn_id = rt.transfer_lpn_id
265: -- AND rt.transfer_lpn_id <> rt.lpn_id
266: -- AND lpn.parent_lpn_id <> lpn.lpn_id
267: AND lpn.parent_lpn_id is not null

Line 285: FROM wms_license_plate_numbers lpn, rcv_transactions rt

281: SELECT lpn.outermost_lpn_id
282: , rt.po_header_id
283: , rt.subinventory
284: , rt.locator_id
285: FROM wms_license_plate_numbers lpn, rcv_transactions rt
286: WHERE lpn.lpn_id = rt.transfer_lpn_id
287: -- AND rt.transfer_lpn_id <> rt.lpn_id
288: -- AND lpn.outermost_lpn_id <> lpn.lpn_id
289: -- AND lpn.outermost_lpn_id <> lpn.parent_lpn_id

Line 302: , wms_license_plate_numbers wlpn -- Bug 3836623

298: AND p_label_type_info.business_flow_code = 1
299: )
300: )) all_lpn
301: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
302: , wms_license_plate_numbers wlpn -- Bug 3836623
303: WHERE pha.po_header_id(+) = all_lpn.po_header_id
304: -- Bug 3836623
305: -- Add check for LPN context
306: -- When cross docking happens, label printing are called for both cross docking and putaway

Line 355: FROM wms_license_plate_numbers lpn

351: , lpn.attribute12 attribute12
352: , lpn.attribute13 attribute13
353: , lpn.attribute14 attribute14
354: , lpn.attribute15 attribute15
355: FROM wms_license_plate_numbers lpn
356: , wms_license_plate_numbers plpn
357: , wms_license_plate_numbers olpn
358: , mtl_system_items_kfv msik
359: , mtl_parameters mp

Line 356: , wms_license_plate_numbers plpn

352: , lpn.attribute13 attribute13
353: , lpn.attribute14 attribute14
354: , lpn.attribute15 attribute15
355: FROM wms_license_plate_numbers lpn
356: , wms_license_plate_numbers plpn
357: , wms_license_plate_numbers olpn
358: , mtl_system_items_kfv msik
359: , mtl_parameters mp
360: , mtl_item_locations milkfv

Line 357: , wms_license_plate_numbers olpn

353: , lpn.attribute14 attribute14
354: , lpn.attribute15 attribute15
355: FROM wms_license_plate_numbers lpn
356: , wms_license_plate_numbers plpn
357: , wms_license_plate_numbers olpn
358: , mtl_system_items_kfv msik
359: , mtl_parameters mp
360: , mtl_item_locations milkfv
361: WHERE lpn.lpn_id = p_lpn_id

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

Line 445: from wms_license_plate_numbers lpn,

441: , rsl.po_header_id, rsl.po_line_id
442: , lpn.subinventory_code, lpn.locator_id
443: , rsh.shipment_header_id
444: , rsl.po_line_location_id
445: from wms_license_plate_numbers lpn,
446: rcv_shipment_headers rsh,
447: rcv_shipment_lines rsl
448: where lpn.source_name = rsh.shipment_num
449: AND lpn.lpn_context = 7

Line 460: from wms_license_plate_numbers lpn,

456: , rsl.po_header_id, rsl.po_line_id
457: , lpn.subinventory_code, lpn.locator_id
458: , rsh.shipment_header_id
459: , rsl.po_line_location_id
460: from wms_license_plate_numbers lpn,
461: rcv_shipment_headers rsh,
462: rcv_shipment_lines rsl
463: where lpn.source_name = rsh.shipment_num
464: AND lpn.lpn_context = 7

Line 596: FROM wms_license_plate_numbers

592: SELECT lpn_id
593: , license_plate_number
594: , parent_lpn_id
595: , outermost_lpn_id
596: FROM wms_license_plate_numbers
597: START WITH lpn_id = p_parent_lpn_id
598: CONNECT BY lpn_id = PRIOR parent_lpn_id;
599:
600: CURSOR nested_child_lpn_cursor (p_lpn_id NUMBER) IS

Line 605: FROM wms_license_plate_numbers

601: SELECT lpn_id
602: , license_plate_number
603: , parent_lpn_id
604: , outermost_lpn_id
605: FROM wms_license_plate_numbers
606: START WITH parent_lpn_id = p_lpn_id
607: CONNECT BY parent_lpn_id = PRIOR lpn_id;
608: --END Conf Label ER
609: