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 3729: else it updates the mtl item locations table with the

3725: DESCRIPTION : This procedure takes in the inventory location id (locator id),
3726: subinventory and org for the delivery detail and validates if
3727: the locator id exists for the given organization and location.
3728: If it can find it then it raises a duplicate locator exception,
3729: else it updates the mtl item locations table with the
3730: input subinventory for the given locator id and organization.
3731: -----------------------------------------------------------------------------
3732: */
3733:

Line 3743: FROM Mtl_Item_Locations

3739:
3740:
3741: CURSOR Check_Dup_Loc IS
3742: SELECT 'Exist'
3743: FROM Mtl_Item_Locations
3744: WHERE organization_id = p_organization_id
3745: AND inventory_location_id = p_locator_id
3746: AND subinventory_code IS NOT NULL
3747: AND subinventory_code <> p_subinventory;

Line 3817: UPDATE Mtl_Item_Locations

3813: IF (Check_Dup_Loc%ISOPEN) THEN
3814: CLOSE Check_Dup_Loc;
3815: END IF;
3816:
3817: UPDATE Mtl_Item_Locations
3818: SET subinventory_code = p_subinventory
3819: WHERE organization_id = p_organization_id
3820: AND inventory_location_id = p_locator_id;
3821: