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.WSH_DELIVERY_DETAILS_INV dependencies on MTL_ITEM_LOCATIONS

Line 3399: else it updates the mtl item locations table with the

3395: DESCRIPTION : This procedure takes in the inventory location id (locator id),
3396: subinventory and org for the delivery detail and validates if
3397: the locator id exists for the given organization and location.
3398: If it can find it then it raises a duplicate locator exception,
3399: else it updates the mtl item locations table with the
3400: input subinventory for the given locator id and organization.
3401: -----------------------------------------------------------------------------
3402: */
3403:

Line 3413: FROM Mtl_Item_Locations

3409:
3410:
3411: CURSOR Check_Dup_Loc IS
3412: SELECT 'Exist'
3413: FROM Mtl_Item_Locations
3414: WHERE organization_id = p_organization_id
3415: AND inventory_location_id = p_locator_id
3416: AND subinventory_code IS NOT NULL
3417: AND subinventory_code <> p_subinventory;

Line 3487: UPDATE Mtl_Item_Locations

3483: IF (Check_Dup_Loc%ISOPEN) THEN
3484: CLOSE Check_Dup_Loc;
3485: END IF;
3486:
3487: UPDATE Mtl_Item_Locations
3488: SET subinventory_code = p_subinventory
3489: WHERE organization_id = p_organization_id
3490: AND inventory_location_id = p_locator_id;
3491: