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.

[Home] [Help]

APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 4043: l_subinventory_code WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE%TYPE;

4039: INDEX BY BINARY_INTEGER;
4040:
4041: --3631633
4042: --Variable to hold license plate details
4043: l_subinventory_code WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE%TYPE;
4044: l_locator_id WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID%TYPE;
4045:
4046: CURSOR mol_details IS
4047: SELECT mol.inspection_status,

Line 4044: l_locator_id WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID%TYPE;

4040:
4041: --3631633
4042: --Variable to hold license plate details
4043: l_subinventory_code WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE%TYPE;
4044: l_locator_id WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID%TYPE;
4045:
4046: CURSOR mol_details IS
4047: SELECT mol.inspection_status,
4048: 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 4366: select subinventory_code,locator_id into l_subinventory_code,l_locator_id from WMS_LICENSE_PLATE_NUMBERS where lpn_id=p_lpn_id;

4362:
4363: --3631633
4364: --Select license plate number details
4365: IF p_lpn_id IS NOT NULL THEN
4366: select subinventory_code,locator_id into l_subinventory_code,l_locator_id from WMS_LICENSE_PLATE_NUMBERS where lpn_id=p_lpn_id;
4367: END IF;
4368:
4369: --Bug 4730925 BEGIN
4370: --Get Item controls and then call quantity tree