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 105: UPDATE mtl_item_locations

101: INTO l_picking_order
102: FROM mtl_parameters
103: WHERE organization_id = p_org_id;
104:
105: UPDATE mtl_item_locations
106: SET subinventory_code = p_sub_code
107: , status_id = l_locator_status
108: , inventory_location_type = l_loc_type
109: , picking_order = l_picking_order

Line 937: UPDATE mtl_item_locations

933: x_exist_or_create := '';
934: RETURN;
935: END IF;
936:
937: UPDATE mtl_item_locations
938: SET subinventory_code = p_sub_code
939: , status_id = l_sub_default_status
940: , inventory_location_type = l_loc_type
941: WHERE organization_id = p_org_id

Line 951: FROM mtl_item_locations_kfv

947: SELECT 'failed'
948: INTO l_validity_check
949: FROM DUAL
950: WHERE EXISTS( SELECT subinventory_code
951: FROM mtl_item_locations_kfv
952: WHERE concatenated_segments = p_concat_segs
953: AND p_sub_code <> subinventory_code
954: AND organization_id = p_org_id);
955: EXCEPTION

Line 1017: FROM mtl_item_locations

1013:
1014: BEGIN
1015: SELECT 1
1016: INTO l_temp
1017: FROM mtl_item_locations
1018: WHERE organization_id = p_org_id
1019: AND inventory_location_id = p_inventory_location_id;
1020: EXCEPTION
1021: WHEN NO_DATA_FOUND THEN

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

1153: AND NVL(mil.task_id, -9999) = NVL(p_task_id, -9999);
1154: END;
1155:
1156: /* PJM-WMS Integration:Return only the the physical locators.
1157: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
1158: * Use the function INV_PROJECT.get_locsegs() to retrieve the
1159: * concatenated segments.Filter the locators based on the Project
1160: * and Task passed to the procedure.
1161: */

Line 1657: FROM mtl_item_locations

1653: SELECT 1
1654: INTO loc_exists
1655: FROM DUAL
1656: WHERE exists (select 1
1657: FROM mtl_item_locations
1658: WHERE organization_id = p_organization_id
1659: AND subinventory_code = p_subinventory_code);
1660: */
1661:

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

1726: FROM mtl_secondary_inventories msub
1727: WHERE msub.organization_id = p_organization_id
1728: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1729: AND EXISTS( SELECT wda.staging_lane_id
1730: FROM wms_dock_appointments_b wda, mtl_item_locations milk, wsh_trip_stops pickup_stop
1731: WHERE milk.inventory_location_id(+) = wda.staging_lane_id
1732: AND milk.organization_id(+) = wda.organization_id
1733: AND milk.organization_id = p_organization_id
1734: AND milk.subinventory_code = msub.secondary_inventory_name

Line 1750: FROM mtl_item_locations milk, wms_license_plate_numbers lpn

1746: FROM mtl_secondary_inventories msub
1747: WHERE msub.organization_id = p_organization_id
1748: AND NVL(msub.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
1749: AND EXISTS( SELECT milk.inventory_location_id
1750: FROM mtl_item_locations milk, wms_license_plate_numbers lpn
1751: WHERE milk.inventory_location_id(+) = lpn.locator_id
1752: AND milk.organization_id(+) = lpn.organization_id
1753: AND milk.organization_id = p_organization_id
1754: AND milk.subinventory_code = msub.secondary_inventory_name

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

3239: -- Functions: This API returns the valid locators associated with a
3240: -- cycle count
3241: --
3242: /* PJM-WMS Integration:Return only the the physical locators.
3243: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
3244: * Use the function INV_PROJECT.get_locsegs() to retrieve the
3245: * concatenated segments.
3246: */
3247: 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 3488: FROM mtl_item_locations

3484: , task_id
3485: INTO l_sub_code
3486: , l_project_id
3487: , l_task_id
3488: FROM mtl_item_locations
3489: WHERE inventory_location_id = p_locator_id
3490: AND organization_id = p_org_id;
3491:
3492: --

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

3518: IF (l_debug = 1) THEN
3519: DEBUG('After inserting the default values');
3520: END IF;
3521: --
3522: -- Now that we have a complete valid row in MTL_ITEM_LOCATIONS
3523: -- we call the PJM Locator API to create the physical locator.
3524: -- This happens only if the physical locator does not already
3525: -- exist.
3526: --

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

6232: --
6233: ----------------------------------
6234: -- Name: GET_LOCATION_TYPE_LOCATORS
6235: -- To query locators of a sub and org without status check
6236: -- that is also filtered by mtl_item_locations.inventory_location_type
6237: -- Input Parameter:
6238: -- p_organization_id: Organization ID
6239: -- p_subinventory_code Sub
6240: -- p_inventory_location_type Location Type: Dock Door, Staging, Storage