eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 763: ' FROM mtl_txn_request_lines mol, mtl_txn_request_headers moh, wms_license_plate_numbers lpn ';

759: 'mol.inventory_item_id inventory_item_id, :item item, mol.lpn_id lpn_id, mol.revision revision, mol.uom_code uom, mol.quantity-nvl(mol.quantity_delivered,0) quantity, mol.lot_number, '||
760: 'mol.secondary_quantity -NVL(mol.secondary_quantity_delivered,0) secondary_quantity, mol.secondary_uom_code, mol.grade_code'; --INCONV kkillams
761:
762: l_from_str VARCHAR2(2000) :=
763: ' FROM mtl_txn_request_lines mol, mtl_txn_request_headers moh, wms_license_plate_numbers lpn ';
764:
765: -- Bug 3802897
766: -- Make sure the available quantity is greater than 0
767: l_where_str VARCHAR2(2000) :=

Line 1266: FROM wms_license_plate_numbers lpn, wms_license_plate_numbers pLpn, wms_license_plate_numbers oLpn

1262: INTO l_material_rec.lpn,
1263: l_material_rec.parent_lpn_id,
1264: l_material_rec.parent_lpn,
1265: l_material_rec.outermost_lpn_id, l_material_rec.outermost_lpn
1266: FROM wms_license_plate_numbers lpn, wms_license_plate_numbers pLpn, wms_license_plate_numbers oLpn
1267: WHERE lpn.lpn_id = l_material_rec.lpn_id
1268: AND pLpn.lpn_id(+) = lpn.parent_lpn_id
1269: AND oLpn.lpn_id(+) = lpn.outermost_lpn_id;
1270: EXCEPTION

Line 2093: (select lpn_id from wms_license_plate_numbers

2089: AND wdd1.released_status = 'Y'
2090: AND wdd2.lpn_id IS NOT NULL
2091: AND wdd2.released_status = 'X' -- For LPN reuse ER : 6845650
2092: AND wdd2.lpn_id IN
2093: (select lpn_id from wms_license_plate_numbers
2094: where organization_id = p_organization_id
2095: and lpn_context = 11)
2096: -- restriction from find window
2097: AND wdd1.organization_id = p_organization_id

Line 2101: (wdd2.lpn_id IN (select lpn_id from wms_license_plate_numbers where outermost_lpn_id = p_from_lpn_id)))

2097: AND wdd1.organization_id = p_organization_id
2098: AND wdd1.subinventory = nvl(p_subinventory_code, wdd1.subinventory)
2099: AND nvl(wdd1.locator_id, -999) = nvl(p_locator_id, nvl(wdd1.locator_id, -999))
2100: AND ((wdd2.lpn_id = nvl(p_from_lpn_id, wdd2.lpn_id)) OR
2101: (wdd2.lpn_id IN (select lpn_id from wms_license_plate_numbers where outermost_lpn_id = p_from_lpn_id)))
2102: AND wdd1.inventory_item_id = nvl(p_inventory_item_id, wdd1.inventory_item_id )
2103: AND nvl(wdd1.project_id, -9999) = nvl(p_project_id,nvl(wdd1.project_id, -9999))
2104: AND nvl(wdd1.task_id, -9999) = nvl(p_task_id,nvl(wdd1.task_id, -9999))
2105: AND ((pl_delivery_id IS NULL) OR

Line 2372: FROM wms_license_plate_numbers lpn, wms_license_plate_numbers pLpn, wms_license_plate_numbers oLpn

2368: SELECT lpn.license_plate_number, lpn.parent_lpn_id, pLpn.license_plate_number,
2369: lpn.outermost_lpn_id, oLpn.license_plate_number
2370: INTO l_material_rec.lpn, l_material_rec.parent_lpn_id, l_material_rec.parent_lpn,
2371: l_material_rec.outermost_lpn_id, l_material_rec.outermost_lpn
2372: FROM wms_license_plate_numbers lpn, wms_license_plate_numbers pLpn, wms_license_plate_numbers oLpn
2373: WHERE lpn.lpn_id = l_material_rec.lpn_id
2374: AND pLpn.lpn_id(+) = lpn.parent_lpn_id
2375: AND oLpn.lpn_id(+) = lpn.outermost_lpn_id;
2376: EXCEPTION