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 706: ' FROM mtl_txn_request_lines mol, mtl_txn_request_headers moh, wms_license_plate_numbers lpn ';

702: '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, '||
703: 'mol.secondary_quantity -NVL(mol.secondary_quantity_delivered,0) secondary_quantity, mol.secondary_uom_code, mol.grade_code'; --INCONV kkillams
704:
705: l_from_str VARCHAR2(2000) :=
706: ' FROM mtl_txn_request_lines mol, mtl_txn_request_headers moh, wms_license_plate_numbers lpn ';
707:
708: -- Bug 3802897
709: -- Make sure the available quantity is greater than 0
710: l_where_str VARCHAR2(2000) :=

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

1199: INTO l_material_rec.lpn,
1200: l_material_rec.parent_lpn_id,
1201: l_material_rec.parent_lpn,
1202: l_material_rec.outermost_lpn_id, l_material_rec.outermost_lpn
1203: FROM wms_license_plate_numbers lpn, wms_license_plate_numbers pLpn, wms_license_plate_numbers oLpn
1204: WHERE lpn.lpn_id = l_material_rec.lpn_id
1205: AND pLpn.lpn_id(+) = lpn.parent_lpn_id
1206: AND oLpn.lpn_id(+) = lpn.outermost_lpn_id;
1207: EXCEPTION

Line 2020: (select lpn_id from wms_license_plate_numbers

2016: AND wdd1.released_status = 'Y'
2017: AND wdd2.lpn_id IS NOT NULL
2018: AND wdd2.released_status = 'X' -- For LPN reuse ER : 6845650
2019: AND wdd2.lpn_id IN
2020: (select lpn_id from wms_license_plate_numbers
2021: where organization_id = p_organization_id
2022: and lpn_context = 11)
2023: -- restriction from find window
2024: AND wdd1.organization_id = p_organization_id

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

2024: AND wdd1.organization_id = p_organization_id
2025: AND wdd1.subinventory = nvl(p_subinventory_code, wdd1.subinventory)
2026: AND nvl(wdd1.locator_id, -999) = nvl(p_locator_id, nvl(wdd1.locator_id, -999))
2027: AND ((wdd2.lpn_id = nvl(p_from_lpn_id, wdd2.lpn_id)) OR
2028: (wdd2.lpn_id IN (select lpn_id from wms_license_plate_numbers where outermost_lpn_id = p_from_lpn_id)))
2029: AND wdd1.inventory_item_id = nvl(p_inventory_item_id, wdd1.inventory_item_id )
2030: AND nvl(wdd1.project_id, -9999) = nvl(p_project_id,nvl(wdd1.project_id, -9999))
2031: AND nvl(wdd1.task_id, -9999) = nvl(p_task_id,nvl(wdd1.task_id, -9999))
2032: AND ((pl_delivery_id IS NULL) OR

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

2295: SELECT lpn.license_plate_number, lpn.parent_lpn_id, pLpn.license_plate_number,
2296: lpn.outermost_lpn_id, oLpn.license_plate_number
2297: INTO l_material_rec.lpn, l_material_rec.parent_lpn_id, l_material_rec.parent_lpn,
2298: l_material_rec.outermost_lpn_id, l_material_rec.outermost_lpn
2299: FROM wms_license_plate_numbers lpn, wms_license_plate_numbers pLpn, wms_license_plate_numbers oLpn
2300: WHERE lpn.lpn_id = l_material_rec.lpn_id
2301: AND pLpn.lpn_id(+) = lpn.parent_lpn_id
2302: AND oLpn.lpn_id(+) = lpn.outermost_lpn_id;
2303: EXCEPTION