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.POR_VIEW_REQS_PKG dependencies on FND_LOOKUP_VALUES

Line 452: FROM fnd_lookup_values lv

448: p_status_code <> 'PICKED_PARTIAL'
449: THEN
450: SELECT meaning
451: INTO l_flow_meaning
452: FROM fnd_lookup_values lv
453: WHERE lookup_type = 'LINE_FLOW_STATUS'
454: AND lookup_code = p_status_code
455: AND LANGUAGE = userenv('LANG')
456: AND VIEW_APPLICATION_ID = 660

Line 474: FROM fnd_lookup_values lv

470:
471: IF l_released_count = l_total_count THEN
472: SELECT meaning
473: INTO l_flow_meaning
474: FROM fnd_lookup_values lv
475: WHERE lookup_type = 'LINE_FLOW_STATUS'
476: AND lookup_code = 'PICKED'
477: AND LANGUAGE = userenv('LANG')
478: AND VIEW_APPLICATION_ID = 660

Line 486: FROM fnd_lookup_values lv

482:
483: ELSIF l_released_count < l_total_count and l_released_count <> 0 THEN
484: SELECT meaning
485: INTO l_flow_meaning
486: FROM fnd_lookup_values lv
487: WHERE lookup_type = 'LINE_FLOW_STATUS'
488: AND lookup_code = 'PICKED_PARTIAL'
489: AND LANGUAGE = userenv('LANG')
490: AND VIEW_APPLICATION_ID = 660

Line 497: FROM fnd_lookup_values lv

493: lv.view_application_id);
494: ELSE
495: SELECT meaning
496: INTO l_flow_meaning
497: FROM fnd_lookup_values lv
498: WHERE lookup_type = 'LINE_FLOW_STATUS'
499: AND lookup_code = p_status_code
500: AND LANGUAGE = userenv('LANG')
501: AND VIEW_APPLICATION_ID = 660

Line 551: FROM fnd_lookup_values lv

547:
548: IF (l_status_code is not null) THEN
549: SELECT meaning
550: INTO l_flow_meaning
551: FROM fnd_lookup_values lv
552: WHERE lookup_type = 'LINE_FLOW_STATUS'
553: AND lookup_code = l_status_code
554: AND LANGUAGE = userenv('LANG')
555: AND VIEW_APPLICATION_ID = 660