APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 363: wms_license_plate_numbers lpn

359: mol.txn_source_id --- for bug 7190056
360: FROM
361: mtl_txn_request_headers moh,
362: mtl_txn_request_lines mol,
363: wms_license_plate_numbers lpn
364: WHERE mol.header_id = moh.header_id
365: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away
366: AND mol.organization_id = p_organization_id
367: AND mol.lpn_id is not null

Line 441: FROM wms_license_plate_numbers

437: IF p_lpn_id IS NOT NULL THEN --BUG3497572 p_lpn_id is an optional when pre_generate called from concurrent request
438: BEGIN
439: SELECT lpn_context
440: INTO l_lpn_context
441: FROM wms_license_plate_numbers
442: WHERE lpn_id = p_lpn_id
443: AND organization_id = p_organization_id
444: FOR UPDATE nowait;
445:

Line 870: FROM wms_license_plate_numbers wlpn

866: SELECT /*+ ORDERED INDEX(MTRL MTL_TXN_REQUEST_LINES_N7) */ 1
867: INTO l_discrepancy
868: FROM mtl_txn_request_lines mtrl,
869: (SELECT wlpn.lpn_id
870: FROM wms_license_plate_numbers wlpn
871: START WITH wlpn.lpn_id = p_lpn_id
872: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id) wlpn
873: WHERE mtrl.lpn_id = wlpn.lpn_id
874: AND mtrl.line_status = 7