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 MTL_ITEM_LOCATIONS

Line 59: FROM mtl_item_locations

55: -- Bug 9572628: determine locator type based on physical locator
56: BEGIN
57: SELECT physical_location_id
58: INTO l_physical_loc_id
59: FROM mtl_item_locations
60: WHERE organization_id = p_org_id
61: AND inventory_location_id = p_locator_id;
62: EXCEPTION
63: WHEN OTHERS THEN

Line 79: FROM mtl_item_locations_kfv

75: SELECT inventory_location_type
76: , concatenated_segments
77: INTO l_loc_type
78: , l_phys_loc_segs
79: FROM mtl_item_locations_kfv
80: WHERE organization_id = p_org_id
81: AND inventory_location_id = l_physical_loc_id;
82: EXCEPTION
83: WHEN OTHERS THEN

Line 154: UPDATE mtl_item_locations

150:
151: --Bug 8649041, stamping the WHO columns correctly.
152: --Bug 7143077 The creation date and created by should not be null for dynamic locators
153:
154: UPDATE mtl_item_locations
155: SET created_by = NVL(created_by, fnd_global.user_id)
156: , creation_date = NVL(creation_date, SYSDATE)
157: , last_updated_by = fnd_global.user_id
158: , last_update_login = fnd_global.login_id

Line 1274: UPDATE mtl_item_locations

1270: x_exist_or_create := '';
1271: RETURN;
1272: END IF;
1273:
1274: UPDATE mtl_item_locations
1275: SET subinventory_code = p_sub_code
1276: , status_id = l_sub_default_status
1277: , inventory_location_type = l_loc_type
1278: WHERE organization_id = p_org_id

Line 1288: FROM mtl_item_locations_kfv

1284: SELECT 'failed'
1285: INTO l_validity_check
1286: FROM DUAL
1287: WHERE EXISTS( SELECT subinventory_code
1288: FROM mtl_item_locations_kfv
1289: WHERE concatenated_segments = p_concat_segs
1290: AND p_sub_code <> subinventory_code
1291: AND organization_id = p_org_id);
1292: EXCEPTION

Line 1354: FROM mtl_item_locations

1350:
1351: BEGIN
1352: SELECT 1
1353: INTO l_temp
1354: FROM mtl_item_locations
1355: WHERE organization_id = p_org_id
1356: AND inventory_location_id = p_inventory_location_id;
1357: EXCEPTION
1358: WHEN NO_DATA_FOUND THEN

Line 1532: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.

1528: AND NVL(mil.task_id, -9999) = NVL(p_task_id, -9999);
1529: END get_mo_toloc_lov;
1530:
1531: /* PJM-WMS Integration:Return only the the physical locators.
1532: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
1533: * Use the function INV_PROJECT.get_locsegs() to retrieve the
1534: * concatenated segments.Filter the locators based on the Project
1535: * and Task passed to the procedure.
1536: */

Line 2032: FROM mtl_item_locations

2028: SELECT 1
2029: INTO loc_exists
2030: FROM DUAL
2031: WHERE exists (select 1
2032: FROM mtl_item_locations
2033: WHERE organization_id = p_organization_id
2034: AND subinventory_code = p_subinventory_code);
2035: */
2036:

Line 2105: FROM wms_dock_appointments_b wda, mtl_item_locations milk, wsh_trip_stops pickup_stop

2101: FROM mtl_secondary_inventories msub
2102: WHERE msub.organization_id = p_organization_id
2103: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2104: AND EXISTS( SELECT wda.staging_lane_id
2105: FROM wms_dock_appointments_b wda, mtl_item_locations milk, wsh_trip_stops pickup_stop
2106: WHERE milk.inventory_location_id(+) = wda.staging_lane_id
2107: AND milk.organization_id(+) = wda.organization_id
2108: AND milk.organization_id = p_organization_id
2109: AND milk.subinventory_code = msub.secondary_inventory_name

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 3640: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.

3636: -- Functions: This API returns the valid locators associated with a
3637: -- cycle count
3638: --
3639: /* PJM-WMS Integration:Return only the the physical locators.
3640: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
3641: * Use the function INV_PROJECT.get_locsegs() to retrieve the
3642: * concatenated segments.
3643: */
3644: PROCEDURE get_cgupdate_locs(x_locators OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_subinventory_code IN VARCHAR2, p_concatenated_segments IN VARCHAR2, p_inventory_item_id IN NUMBER, p_revision IN VARCHAR2) IS

Line 3889: FROM mtl_item_locations

3885: , task_id
3886: INTO l_sub_code
3887: , l_project_id
3888: , l_task_id
3889: FROM mtl_item_locations
3890: WHERE inventory_location_id = p_locator_id
3891: AND organization_id = p_org_id;
3892:
3893: --

Line 3919: -- Now that we have a complete valid row in MTL_ITEM_LOCATIONS

3915: --
3916:
3917: x_exist_or_create := 'CREATE';
3918: --
3919: -- Now that we have a complete valid row in MTL_ITEM_LOCATIONS
3920: -- we call the PJM Locator API to create the physical locator.
3921: -- This happens only if the physical locator does not already
3922: -- exist.
3923: --

Line 3927: UPDATE MTL_ITEM_LOCATIONS

3923: --
3924:
3925: -- Added below update for the bug 14849583
3926: BEGIN
3927: UPDATE MTL_ITEM_LOCATIONS
3928: SET SUBINVENTORY_CODE = P_SUB_CODE
3929: WHERE ORGANIZATiON_ID = P_ORG_ID
3930: AND INVENTORY_LOCATION_ID = P_LOCATOR_ID;
3931: EXCEPTION

Line 6721: -- that is also filtered by mtl_item_locations.inventory_location_type

6717: --
6718: ----------------------------------
6719: -- Name: GET_LOCATION_TYPE_LOCATORS
6720: -- To query locators of a sub and org without status check
6721: -- that is also filtered by mtl_item_locations.inventory_location_type
6722: -- Input Parameter:
6723: -- p_organization_id: Organization ID
6724: -- p_subinventory_code Sub
6725: -- p_inventory_location_type Location Type: Dock Door, Staging, Storage

Line 7142: l_stmt := l_stmt || 'SELECT COUNT(*) from mtl_item_locations where organization_id = '||P_ORG_ID||' and nvl(subinventory_code,''@@@'') <> '''|| P_SUBINV ||''' and '|| L_WHERE_CLAUSE ;

7138: end if;
7139:
7140: END LOOP;
7141:
7142: l_stmt := l_stmt || 'SELECT COUNT(*) from mtl_item_locations where organization_id = '||P_ORG_ID||' and nvl(subinventory_code,''@@@'') <> '''|| P_SUBINV ||''' and '|| L_WHERE_CLAUSE ;
7143:
7144: --dbms_output.put_line('l_stmt: '||l_stmt);
7145:
7146: c := dbms_sql.open_cursor;