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.INVPVALI dependencies on FND_LOOKUP_VALUES_VL

Line 208: CURSOR c_check_lookup (cp_type fnd_lookup_values_vl.lookup_type%TYPE,

204: AND m.inventory_item_id = cp_item_id;
205:
206:
207: --2806275 : Revision Reason validation
208: CURSOR c_check_lookup (cp_type fnd_lookup_values_vl.lookup_type%TYPE,
209: cp_code fnd_lookup_values_vl.lookup_code%TYPE)
210: IS
211: SELECT 'Y'
212: FROM fnd_lookup_values_vl

Line 209: cp_code fnd_lookup_values_vl.lookup_code%TYPE)

205:
206:
207: --2806275 : Revision Reason validation
208: CURSOR c_check_lookup (cp_type fnd_lookup_values_vl.lookup_type%TYPE,
209: cp_code fnd_lookup_values_vl.lookup_code%TYPE)
210: IS
211: SELECT 'Y'
212: FROM fnd_lookup_values_vl
213: WHERE lookup_type = cp_type

Line 212: FROM fnd_lookup_values_vl

208: CURSOR c_check_lookup (cp_type fnd_lookup_values_vl.lookup_type%TYPE,
209: cp_code fnd_lookup_values_vl.lookup_code%TYPE)
210: IS
211: SELECT 'Y'
212: FROM fnd_lookup_values_vl
213: WHERE lookup_type = cp_type
214: AND lookup_code = cp_code
215: AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) and NVL(end_date_active, SYSDATE)
216: AND enabled_flag = 'Y';