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 2125: FROM mtl_item_locations milk, wms_license_plate_numbers lpn

2121: FROM mtl_secondary_inventories msub
2122: WHERE msub.organization_id = p_organization_id
2123: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2124: AND EXISTS( SELECT milk.inventory_location_id
2125: FROM mtl_item_locations milk, wms_license_plate_numbers lpn
2126: WHERE milk.inventory_location_id(+) = lpn.locator_id
2127: AND milk.organization_id(+) = lpn.organization_id
2128: AND milk.organization_id = p_organization_id
2129: AND milk.subinventory_code = msub.secondary_inventory_name

Line 2911: FROM wms_license_plate_numbers a, mtl_secondary_inventories b

2907: , inv_project.get_project_id
2908: , inv_project.get_project_number
2909: , inv_project.get_task_id
2910: , inv_project.get_task_number
2911: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2912: WHERE a.organization_id = p_organization_id
2913: AND (a.lpn_context = 1 OR a.lpn_context = 11)
2914: AND b.organization_id(+) = a.organization_id
2915: AND b.secondary_inventory_name(+) = a.subinventory_code

Line 2921: ,wms_license_plate_numbers wlpn

2917: AND a.license_plate_number LIKE (p_lpn_segments)
2918: AND a.parent_lpn_id IS NULL
2919: AND (p_owning_org_id IS NULL
2920: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2921: ,wms_license_plate_numbers wlpn
2922: WHERE moqd.lpn_id in (wlpn.lpn_id)
2923: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2924: AND moqd.organization_id = a.organization_id
2925: AND moqd.owning_organization_id = p_owning_org_id

Line 2929: ,wms_license_plate_numbers wlpn

2925: AND moqd.owning_organization_id = p_owning_org_id
2926: AND moqd.owning_tp_type = p_owning_tp_type))
2927: AND (p_planning_org_id IS NULL
2928: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2929: ,wms_license_plate_numbers wlpn
2930: WHERE moqd.lpn_id in (wlpn.lpn_id)
2931: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2932: AND moqd.organization_id = a.organization_id
2933: AND moqd.planning_organization_id = p_planning_org_id

Line 2964: FROM wms_license_plate_numbers a, mtl_secondary_inventories b

2960: , inv_project.get_project_id
2961: , inv_project.get_project_number
2962: , inv_project.get_task_id
2963: , inv_project.get_task_number
2964: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2965: WHERE a.organization_id = p_organization_id
2966: AND (a.lpn_context = 1 OR a.lpn_context = 11)
2967: AND b.organization_id(+) = a.organization_id
2968: AND b.secondary_inventory_name(+) = a.subinventory_code

Line 2979: ,wms_license_plate_numbers wlpn

2975: ,p_wms_installed
2976: ,p_transaction_type_id) = 'Y'
2977: AND (p_owning_org_id IS NULL
2978: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2979: ,wms_license_plate_numbers wlpn
2980: WHERE moqd.lpn_id in (wlpn.lpn_id)
2981: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2982: AND moqd.organization_id = a.organization_id
2983: AND moqd.owning_organization_id = p_owning_org_id

Line 2987: ,wms_license_plate_numbers wlpn

2983: AND moqd.owning_organization_id = p_owning_org_id
2984: AND moqd.owning_tp_type = p_owning_tp_type))
2985: AND (p_planning_org_id IS NULL
2986: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
2987: ,wms_license_plate_numbers wlpn
2988: WHERE moqd.lpn_id in (wlpn.lpn_id)
2989: AND wlpn.outermost_lpn_id = a.outermost_lpn_id
2990: AND moqd.organization_id = a.organization_id
2991: AND moqd.planning_organization_id = p_planning_org_id

Line 3007: FROM wms_license_plate_numbers

3003: CURSOR l_item_cursor IS
3004: SELECT DISTINCT inventory_item_id
3005: FROM wms_lpn_contents
3006: WHERE parent_lpn_id IN (SELECT lpn_id
3007: FROM wms_license_plate_numbers
3008: WHERE outermost_lpn_id = p_lpn_id)
3009: AND inventory_item_id IS NOT NULL;
3010: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3011: BEGIN

Line 3162: FROM wms_license_plate_numbers

3158: SELECT COUNT(*)
3159: INTO l_lpn_rsvd
3160: FROM mtl_reservations
3161: WHERE lpn_id IN (SELECT lpn_id
3162: FROM wms_license_plate_numbers
3163: WHERE outermost_lpn_id = p_lpn_id);
3164: EXCEPTION
3165: WHEN NO_DATA_FOUND THEN
3166: l_lpn_rsvd := 0;

Line 3218: FROM wms_license_plate_numbers

3214: CURSOR l_item_cursor IS
3215: SELECT DISTINCT inventory_item_id
3216: FROM wms_lpn_contents
3217: WHERE parent_lpn_id IN (SELECT lpn_id
3218: FROM wms_license_plate_numbers
3219: WHERE outermost_lpn_id = p_lpn_id)
3220: AND inventory_item_id IS NOT NULL;
3221: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3222: BEGIN

Line 3371: FROM wms_license_plate_numbers

3367: CURSOR l_item_cursor IS
3368: SELECT DISTINCT inventory_item_id
3369: FROM wms_lpn_contents
3370: WHERE parent_lpn_id IN (SELECT lpn_id
3371: FROM wms_license_plate_numbers
3372: WHERE outermost_lpn_id = p_lpn_id)
3373: AND inventory_item_id IS NOT NULL;
3374: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3375: BEGIN

Line 3455: FROM wms_license_plate_numbers wlpn

3451: SELECT 'Y'
3452: INTO oth_val
3453: FROM DUAL
3454: WHERE EXISTS( SELECT wlpn.license_plate_number
3455: FROM wms_license_plate_numbers wlpn
3456: WHERE (wlpn.organization_id = p_org_id
3457: AND wlpn.lpn_context = 5
3458: AND license_plate_number = p_lpn
3459: )

Line 3525: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

3521: , wlc.lot_number
3522: , wlc.inventory_item_id
3523: , wlpn.subinventory_code
3524: , wlpn.locator_id
3525: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
3526: WHERE wlc.organization_id = p_orgid
3527: AND wlc.parent_lpn_id = wlpn.lpn_id
3528: AND wlc.organization_id = wlpn.organization_id
3529: AND wlc.parent_lpn_id IN (SELECT lpn_id

Line 3530: FROM wms_license_plate_numbers

3526: WHERE wlc.organization_id = p_orgid
3527: AND wlc.parent_lpn_id = wlpn.lpn_id
3528: AND wlc.organization_id = wlpn.organization_id
3529: AND wlc.parent_lpn_id IN (SELECT lpn_id
3530: FROM wms_license_plate_numbers
3531: WHERE outermost_lpn_id = p_lpn_id)
3532: AND wlc.inventory_item_id IS NOT NULL
3533: UNION
3534: SELECT DISTINCT serial_number

Line 3542: FROM wms_license_plate_numbers

3538: , current_locator_id
3539: FROM mtl_serial_numbers
3540: WHERE current_organization_id = p_orgid
3541: AND lpn_id IN (SELECT lpn_id
3542: FROM wms_license_plate_numbers
3543: WHERE outermost_lpn_id = p_lpn_id);
3544: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3545: BEGIN
3546: OPEN l_cursor;

Line 4867: FROM wms_license_plate_numbers

4863: SELECT DISTINCT wlc.inventory_item_id
4864: , msi.restrict_subinventories_code
4865: FROM wms_lpn_contents wlc, mtl_system_items msi
4866: WHERE wlc.parent_lpn_id IN(SELECT lpn_id
4867: FROM wms_license_plate_numbers
4868: WHERE outermost_lpn_id = p_lpn_id)
4869: AND wlc.inventory_item_id IS NOT NULL
4870: AND wlc.inventory_item_id = msi.inventory_item_id
4871: AND msi.organization_id = p_organization_id;

Line 5046: FROM wms_license_plate_numbers

5042: CURSOR l_item_cursor IS
5043: SELECT DISTINCT wlc.inventory_item_id, msi.restrict_locators_code
5044: FROM wms_lpn_contents wlc, mtl_system_items msi
5045: WHERE wlc.parent_lpn_id IN (SELECT lpn_id
5046: FROM wms_license_plate_numbers
5047: WHERE outermost_lpn_id = p_lpn_id)
5048: AND wlc.inventory_item_id IS NOT NULL
5049: AND wlc.inventory_item_id = msi.inventory_item_id
5050: AND msi.organization_id = p_organization_id;