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 2506: -- Select only LPN's that exist in table MTL_CYCLE_COUNT_ENTRIES

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

Line 2510: mtl_cycle_count_entries mcce

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

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

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

Line 3492: mtl_cycle_count_entries mcce

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

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

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

Line 3606: mtl_cycle_count_entries mcce

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