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

Line 814: FROM fnd_lookup_values lv

810: /*Ending fix for bug 12324648*/
811: THEN
812: SELECT meaning
813: INTO l_flow_meaning
814: FROM fnd_lookup_values lv
815: WHERE lookup_type = 'LINE_FLOW_STATUS'
816: AND lookup_code = l_flow_status_code
817: AND LANGUAGE = userenv('LANG')
818: AND VIEW_APPLICATION_ID = 660

Line 840: FROM fnd_lookup_values lv

836:
837: IF released_count = total_count THEN
838: SELECT meaning
839: INTO l_flow_meaning
840: FROM fnd_lookup_values lv
841: WHERE lookup_type = 'LINE_FLOW_STATUS'
842: AND lookup_code = 'PICKED'
843: AND LANGUAGE = userenv('LANG')
844: AND VIEW_APPLICATION_ID = 660

Line 852: FROM fnd_lookup_values lv

848:
849: ELSIF released_count < total_count and released_count <> 0 THEN
850: SELECT meaning
851: INTO l_flow_meaning
852: FROM fnd_lookup_values lv
853: WHERE lookup_type = 'LINE_FLOW_STATUS'
854: AND lookup_code = 'PICKED_PARTIAL'
855: AND LANGUAGE = userenv('LANG')
856: AND VIEW_APPLICATION_ID = 660

Line 863: FROM fnd_lookup_values lv

859: lv.view_application_id);
860: ELSE
861: SELECT meaning
862: INTO l_flow_meaning
863: FROM fnd_lookup_values lv
864: WHERE lookup_type = 'LINE_FLOW_STATUS'
865: AND lookup_code = l_flow_status_code
866: AND LANGUAGE = userenv('LANG')
867: AND VIEW_APPLICATION_ID = 660