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.

[Home] [Help]

APPS.INV_VALIDATE dependencies on HR_LOCATIONS

Line 2792: --from both HR_LOCATIONS and HZ_LOCATIONS tables, hence added an exception in the

2788: return T;
2789: END IF;
2790:
2791: --Bug 6270813, the ship to location LOV on the move orders form fetches locations
2792: --from both HR_LOCATIONS and HZ_LOCATIONS tables, hence added an exception in the
2793: --HR_LOCATIONS query and have put another query for checking the location in HZ_LOCATIONS.
2794:
2795: BEGIN
2796:

Line 2793: --HR_LOCATIONS query and have put another query for checking the location in HZ_LOCATIONS.

2789: END IF;
2790:
2791: --Bug 6270813, the ship to location LOV on the move orders form fetches locations
2792: --from both HR_LOCATIONS and HZ_LOCATIONS tables, hence added an exception in the
2793: --HR_LOCATIONS query and have put another query for checking the location in HZ_LOCATIONS.
2794:
2795: BEGIN
2796:
2797: SELECT 'valid'

Line 2799: FROM HR_LOCATIONS

2795: BEGIN
2796:
2797: SELECT 'valid'
2798: INTO l_dummy
2799: FROM HR_LOCATIONS
2800: WHERE LOCATION_ID = p_hr_location;
2801:
2802: EXCEPTION
2803: WHEN NO_DATA_FOUND THEN