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_ATF_RUNTIME_PUB_APIS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 4083: l_subinventory_code WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE%TYPE;

4079: INDEX BY BINARY_INTEGER;
4080:
4081: --3631633
4082: --Variable to hold license plate details
4083: l_subinventory_code WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE%TYPE;
4084: l_locator_id WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID%TYPE;
4085:
4086: CURSOR mol_details IS
4087: SELECT mol.inspection_status,

Line 4084: l_locator_id WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID%TYPE;

4080:
4081: --3631633
4082: --Variable to hold license plate details
4083: l_subinventory_code WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE%TYPE;
4084: l_locator_id WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID%TYPE;
4085:
4086: CURSOR mol_details IS
4087: SELECT mol.inspection_status,
4088: SUM(NVL(mmtt.primary_quantity, wms_task_dispatch_gen.get_primary_quantity(mol.inventory_item_id,mol.organization_id,(mol.quantity - Nvl(mol.quantity_delivered,0)),mol.uom_code))) quantity,

Line 4409: select subinventory_code,locator_id into l_subinventory_code,l_locator_id from WMS_LICENSE_PLATE_NUMBERS where lpn_id=p_lpn_id;

4405:
4406: --3631633
4407: --Select license plate number details
4408: IF p_lpn_id IS NOT NULL THEN
4409: select subinventory_code,locator_id into l_subinventory_code,l_locator_id from WMS_LICENSE_PLATE_NUMBERS where lpn_id=p_lpn_id;
4410: END IF;
4411:
4412: --Bug 4730925 BEGIN
4413: --Get Item controls and then call quantity tree