APPS.WMS_PUTAWAY_SUGGESTIONS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 401: wms_license_plate_numbers lpn

397: mol.txn_source_id --- for bug 7190056
398: FROM
399: mtl_txn_request_headers moh,
400: mtl_txn_request_lines mol,
401: wms_license_plate_numbers lpn
402: WHERE mol.header_id = moh.header_id
403: AND moh.move_order_type = INV_GLOBALS.g_move_order_put_away
404: AND mol.organization_id = p_organization_id
405: AND mol.lpn_id is not null

Line 479: FROM wms_license_plate_numbers

475: IF p_lpn_id IS NOT NULL THEN --BUG3497572 p_lpn_id is an optional when pre_generate called from concurrent request
476: BEGIN
477: SELECT lpn_context
478: INTO l_lpn_context
479: FROM wms_license_plate_numbers
480: WHERE lpn_id = p_lpn_id
481: AND organization_id = p_organization_id
482: FOR UPDATE nowait;
483:

Line 967: FROM wms_license_plate_numbers wlpn

963: SELECT /*+ ORDERED INDEX(MTRL MTL_TXN_REQUEST_LINES_N7) */ 1
964: INTO l_discrepancy
965: FROM
966: (SELECT wlpn.lpn_id
967: FROM wms_license_plate_numbers wlpn
968: START WITH wlpn.lpn_id = p_lpn_id
969: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id) wlpn,
970: mtl_txn_request_lines mtrl -- Bug 14372071
971: WHERE mtrl.lpn_id = wlpn.lpn_id