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.INV_UI_ITEM_SUB_LOC_LOVS dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 1750: FROM mtl_item_locations milk, wms_license_plate_numbers lpn

1746: FROM mtl_secondary_inventories msub
1747: WHERE msub.organization_id = p_organization_id
1748: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1749: AND EXISTS( SELECT milk.inventory_location_id
1750: FROM mtl_item_locations milk, wms_license_plate_numbers lpn
1751: WHERE milk.inventory_location_id(+) = lpn.locator_id
1752: AND milk.organization_id(+) = lpn.organization_id
1753: AND milk.organization_id = p_organization_id
1754: AND milk.subinventory_code = msub.secondary_inventory_name

Line 2534: FROM wms_license_plate_numbers a, mtl_secondary_inventories b

2530: , inv_project.get_project_id
2531: , inv_project.get_project_number
2532: , inv_project.get_task_id
2533: , inv_project.get_task_number
2534: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2535: WHERE a.organization_id = p_organization_id
2536: AND (a.lpn_context = 1 OR a.lpn_context = 11)
2537: AND b.organization_id(+) = a.organization_id
2538: AND b.secondary_inventory_name(+) = a.subinventory_code

Line 2544: ,wms_license_plate_numbers wlpn

2540: AND a.license_plate_number LIKE (p_lpn_segments)
2541: AND a.parent_lpn_id IS NULL
2542: AND (p_owning_org_id IS NULL
2543: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2544: ,wms_license_plate_numbers wlpn
2545: WHERE moqd.lpn_id in (wlpn.lpn_id)
2546: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2547: AND moqd.organization_id = a.organization_id
2548: AND moqd.owning_organization_id = p_owning_org_id

Line 2552: ,wms_license_plate_numbers wlpn

2548: AND moqd.owning_organization_id = p_owning_org_id
2549: AND moqd.owning_tp_type = p_owning_tp_type))
2550: AND (p_planning_org_id IS NULL
2551: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2552: ,wms_license_plate_numbers wlpn
2553: WHERE moqd.lpn_id in (wlpn.lpn_id)
2554: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2555: AND moqd.organization_id = a.organization_id
2556: AND moqd.planning_organization_id = p_planning_org_id

Line 2587: FROM wms_license_plate_numbers a, mtl_secondary_inventories b

2583: , inv_project.get_project_id
2584: , inv_project.get_project_number
2585: , inv_project.get_task_id
2586: , inv_project.get_task_number
2587: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2588: WHERE a.organization_id = p_organization_id
2589: AND (a.lpn_context = 1 OR a.lpn_context = 11)
2590: AND b.organization_id(+) = a.organization_id
2591: AND b.secondary_inventory_name(+) = a.subinventory_code

Line 2602: ,wms_license_plate_numbers wlpn

2598: ,p_wms_installed
2599: ,p_transaction_type_id) = 'Y'
2600: AND (p_owning_org_id IS NULL
2601: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2602: ,wms_license_plate_numbers wlpn
2603: WHERE moqd.lpn_id in (wlpn.lpn_id)
2604: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2605: AND moqd.organization_id = a.organization_id
2606: AND moqd.owning_organization_id = p_owning_org_id

Line 2610: ,wms_license_plate_numbers wlpn

2606: AND moqd.owning_organization_id = p_owning_org_id
2607: AND moqd.owning_tp_type = p_owning_tp_type))
2608: AND (p_planning_org_id IS NULL
2609: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2610: ,wms_license_plate_numbers wlpn
2611: WHERE moqd.lpn_id in (wlpn.lpn_id)
2612: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2613: AND moqd.organization_id = a.organization_id
2614: AND moqd.planning_organization_id = p_planning_org_id

Line 2630: FROM wms_license_plate_numbers

2626: CURSOR l_item_cursor IS
2627: SELECT DISTINCT inventory_item_id
2628: FROM wms_lpn_contents
2629: WHERE parent_lpn_id IN (SELECT lpn_id
2630: FROM wms_license_plate_numbers
2631: WHERE outermost_lpn_id = p_lpn_id)
2632: AND inventory_item_id IS NOT NULL;
2633: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2634: BEGIN

Line 2785: FROM wms_license_plate_numbers

2781: SELECT COUNT(*)
2782: INTO l_lpn_rsvd
2783: FROM mtl_reservations
2784: WHERE lpn_id IN (SELECT lpn_id
2785: FROM wms_license_plate_numbers
2786: WHERE outermost_lpn_id = p_lpn_id);
2787: EXCEPTION
2788: WHEN NO_DATA_FOUND THEN
2789: l_lpn_rsvd := 0;

Line 2841: FROM wms_license_plate_numbers

2837: CURSOR l_item_cursor IS
2838: SELECT DISTINCT inventory_item_id
2839: FROM wms_lpn_contents
2840: WHERE parent_lpn_id IN (SELECT lpn_id
2841: FROM wms_license_plate_numbers
2842: WHERE outermost_lpn_id = p_lpn_id)
2843: AND inventory_item_id IS NOT NULL;
2844: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2845: BEGIN

Line 2976: FROM wms_license_plate_numbers

2972: CURSOR l_item_cursor IS
2973: SELECT DISTINCT inventory_item_id
2974: FROM wms_lpn_contents
2975: WHERE parent_lpn_id IN (SELECT lpn_id
2976: FROM wms_license_plate_numbers
2977: WHERE outermost_lpn_id = p_lpn_id)
2978: AND inventory_item_id IS NOT NULL;
2979: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2980: BEGIN

Line 3060: FROM wms_license_plate_numbers wlpn

3056: SELECT 'Y'
3057: INTO oth_val
3058: FROM DUAL
3059: WHERE EXISTS( SELECT wlpn.license_plate_number
3060: FROM wms_license_plate_numbers wlpn
3061: WHERE (wlpn.organization_id = p_org_id
3062: AND wlpn.lpn_context = 5
3063: AND license_plate_number = p_lpn
3064: )

Line 3130: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

3126: , wlc.lot_number
3127: , wlc.inventory_item_id
3128: , wlpn.subinventory_code
3129: , wlpn.locator_id
3130: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
3131: WHERE wlc.organization_id = p_orgid
3132: AND wlc.parent_lpn_id = wlpn.lpn_id
3133: AND wlc.organization_id = wlpn.organization_id
3134: AND wlc.parent_lpn_id IN (SELECT lpn_id

Line 3135: FROM wms_license_plate_numbers

3131: WHERE wlc.organization_id = p_orgid
3132: AND wlc.parent_lpn_id = wlpn.lpn_id
3133: AND wlc.organization_id = wlpn.organization_id
3134: AND wlc.parent_lpn_id IN (SELECT lpn_id
3135: FROM wms_license_plate_numbers
3136: WHERE outermost_lpn_id = p_lpn_id)
3137: AND wlc.inventory_item_id IS NOT NULL
3138: UNION
3139: SELECT DISTINCT serial_number

Line 3147: FROM wms_license_plate_numbers

3143: , current_locator_id
3144: FROM mtl_serial_numbers
3145: WHERE current_organization_id = p_orgid
3146: AND lpn_id IN (SELECT lpn_id
3147: FROM wms_license_plate_numbers
3148: WHERE outermost_lpn_id = p_lpn_id);
3149: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3150: BEGIN
3151: OPEN l_cursor;

Line 4412: FROM wms_license_plate_numbers

4408: SELECT DISTINCT wlc.inventory_item_id
4409: , msi.restrict_subinventories_code
4410: FROM wms_lpn_contents wlc, mtl_system_items msi
4411: WHERE wlc.parent_lpn_id IN(SELECT lpn_id
4412: FROM wms_license_plate_numbers
4413: WHERE outermost_lpn_id = p_lpn_id)
4414: AND wlc.inventory_item_id IS NOT NULL
4415: AND wlc.inventory_item_id = msi.inventory_item_id
4416: AND msi.organization_id = p_organization_id;

Line 4589: FROM wms_license_plate_numbers

4585: CURSOR l_item_cursor IS
4586: SELECT DISTINCT wlc.inventory_item_id, msi.restrict_locators_code
4587: FROM wms_lpn_contents wlc, mtl_system_items msi
4588: WHERE wlc.parent_lpn_id IN (SELECT lpn_id
4589: FROM wms_license_plate_numbers
4590: WHERE outermost_lpn_id = p_lpn_id)
4591: AND wlc.inventory_item_id IS NOT NULL
4592: AND wlc.inventory_item_id = msi.inventory_item_id
4593: AND msi.organization_id = p_organization_id;