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_PHYSICAL_INVENTORY_TAGS

Line 1146: -- Select only LPN's that exist in table MTL_PHYSICAL_INVENTORY_TAGS

1142: )
1143: AND license_plate_number LIKE (p_lpn)
1144: ORDER BY license_plate_number;
1145: ELSE -- Dynamic entries are not allowed
1146: -- Select only LPN's that exist in table MTL_PHYSICAL_INVENTORY_TAGS
1147: OPEN x_lpn_lov FOR
1148: SELECT UNIQUE wlpn.license_plate_number,
1149: wlpn.lpn_id,
1150: wlpn.inventory_item_id,

Line 1167: mtl_physical_inventory_tags mpit

1163: wlpn.lpn_context -- Added for resolution of Bug# 4349304. The LPN Context is required by the LOVs called
1164: -- by the Cycle Count and Physical Count pages to validate whether the LPN belongs to same
1165: --organization, whether the LPN is "Issued out of Stores".
1166: FROM wms_license_plate_numbers wlpn,
1167: mtl_physical_inventory_tags mpit
1168: WHERE wlpn.organization_id = p_organization_id
1169: AND wlpn.subinventory_code = p_subinventory_code
1170: -- Bug# 1609449
1171: --AND Nvl(wlpn.locator_id, -99999) = Nvl(p_locator_id, -99999)

Line 1253: -- Select only LPN's that exist in table MTL_PHYSICAL_INVENTORY_TAGS

1249: AND license_plate_number LIKE (p_lpn)
1250: AND parent_lpn_id = p_parent_lpn_id
1251: ORDER BY license_plate_number;
1252: ELSE -- Dynamic entries are not allowed
1253: -- Select only LPN's that exist in table MTL_PHYSICAL_INVENTORY_TAGS
1254: OPEN x_lpn_lov FOR
1255: SELECT UNIQUE wlpn.license_plate_number,
1256: wlpn.lpn_id,
1257: wlpn.inventory_item_id,

Line 1274: mtl_physical_inventory_tags mpit

1270: wlpn.lpn_context -- Added for resolution of Bug# 4349304. The LPN Context is required by the LOVs called
1271: -- by the Cycle Count and Physical Count pages to validate whether the LPN belongs to same
1272: --organization, whether the LPN is "Issued out of Stores".
1273: FROM wms_license_plate_numbers wlpn,
1274: mtl_physical_inventory_tags mpit
1275: WHERE wlpn.organization_id = p_organization_id
1276: AND wlpn.subinventory_code = p_subinventory_code
1277: -- Bug# 1609449
1278: -- AND Nvl(wlpn.locator_id, -99999) = Nvl(p_locator_id, -99999)

Line 2445: -- Select only LPN's that exist in table MTL_PHYSICAL_INVENTORY_TAGS

2441: x_result := 2;
2442: END IF;
2443:
2444: ELSE -- Dynamic entries are not allowed
2445: -- Select only LPN's that exist in table MTL_PHYSICAL_INVENTORY_TAGS
2446: SELECT COUNT(*)
2447: INTO l_count
2448: FROM wms_license_plate_numbers wlpn,
2449: mtl_physical_inventory_tags mpit

Line 2449: mtl_physical_inventory_tags mpit

2445: -- Select only LPN's that exist in table MTL_PHYSICAL_INVENTORY_TAGS
2446: SELECT COUNT(*)
2447: INTO l_count
2448: FROM wms_license_plate_numbers wlpn,
2449: mtl_physical_inventory_tags mpit
2450: WHERE wlpn.organization_id = p_organization_id
2451: AND wlpn.subinventory_code = p_subinventory_code
2452: AND Nvl(wlpn.locator_id, -99999) = Nvl(p_locator_id, -99999)
2453: AND wlpn.license_plate_number LIKE (p_lpn)