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_LPN_LOVS dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 2503: -- Select only LPN's that exist in table MTL_CYCLE_COUNT_ENTRIES

2499: x_result := 2;
2500: END IF;
2501:
2502: ELSE -- Unscheduled entries are not allowed
2503: -- Select only LPN's that exist in table MTL_CYCLE_COUNT_ENTRIES
2504: SELECT COUNT(*)
2505: INTO l_count
2506: FROM wms_license_plate_numbers wlpn,
2507: mtl_cycle_count_entries mcce

Line 2507: mtl_cycle_count_entries mcce

2503: -- Select only LPN's that exist in table MTL_CYCLE_COUNT_ENTRIES
2504: SELECT COUNT(*)
2505: INTO l_count
2506: FROM wms_license_plate_numbers wlpn,
2507: mtl_cycle_count_entries mcce
2508: WHERE wlpn.organization_id = p_organization_id
2509: AND wlpn.subinventory_code = p_subinventory_code
2510: AND NVL(wlpn.locator_id, -99999) = NVL(p_locator_id, -99999)
2511: AND wlpn.license_plate_number LIKE (p_lpn)

Line 3472: -- Select only LPN's that exist in table MTL_CYCLE_COUNT_ENTRIES

3468: AND license_plate_number LIKE (p_lpn)
3469: --AND lpn_context not in (4,6) --Bug# 4205672 --bug#4267956.Added 6 --Commented for bug#4886188
3470: ORDER BY license_plate_number;
3471: ELSE -- Unscheduled entries are not allowed
3472: -- Select only LPN's that exist in table MTL_CYCLE_COUNT_ENTRIES
3473: OPEN x_lpn_lov FOR
3474: SELECT UNIQUE wlpn.license_plate_number,
3475: wlpn.lpn_id,
3476: wlpn.inventory_item_id,

Line 3493: mtl_cycle_count_entries mcce

3489: wlpn.lpn_context -- Added for resolution of Bug# 4349304. The LPN Context is required by the LOVs called
3490: -- by the Cycle Count and Physical Count pages to validate whether the LPN belongs to same
3491: --organization, whether the LPN is "Issued out of Stores".
3492: FROM wms_license_plate_numbers wlpn,
3493: mtl_cycle_count_entries mcce
3494: WHERE wlpn.organization_id = p_organization_id
3495: AND (wlpn.subinventory_code = p_subinventory_code OR
3496: l_container_discrepancy_option = 1)
3497: -- Bug# 1609449

Line 3586: -- Select only LPN's that exist in table MTL_CYCLE_COUNT_ENTRIES

3582: AND license_plate_number LIKE (p_lpn)
3583: --AND lpn_context not in (4,6) --Bug# 4205672 --bug#4267956.Added 6 --Commented for bug#4886188
3584: ORDER BY license_plate_number;
3585: ELSE -- Unscheduled entries are not allowed
3586: -- Select only LPN's that exist in table MTL_CYCLE_COUNT_ENTRIES
3587: OPEN x_lpn_lov FOR
3588: SELECT UNIQUE wlpn.license_plate_number,
3589: wlpn.lpn_id,
3590: wlpn.inventory_item_id,

Line 3607: mtl_cycle_count_entries mcce

3603: wlpn.lpn_context -- Added for resolution of Bug# 4349304. The LPN Context is required by the LOVs called
3604: -- by the Cycle Count and Physical Count pages to validate whether the LPN belongs to same
3605: --organization, whether the LPN is "Issued out of Stores".
3606: FROM wms_license_plate_numbers wlpn,
3607: mtl_cycle_count_entries mcce
3608: WHERE wlpn.organization_id = p_organization_id
3609: AND (wlpn.subinventory_code = p_subinventory_code OR
3610: l_container_discrepancy_option = 1)
3611: -- Bug# 1609449