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

Line 831: IS SELECT lookup_code FROM fnd_lookup_values

827: l_return_status VARCHAR2(1);
828: l_tmp_str VARCHAR2(30);
829:
830: CURSOR c3(l_c_status_code IN VARCHAR2)
831: IS SELECT lookup_code FROM fnd_lookup_values
832: WHERE lookup_type = 'JTF_SECTION_STATUS' AND
833: lookup_code = l_c_status_code AND
834: language = USERENV('LANG');
835:

Line 1007: SELECT lookup_code INTO l_tmp_str FROM fnd_lookup_values

1003:
1004: -- section type code
1005: -- note that p_section_type_code won't be NULL due to previous checks
1006: BEGIN
1007: SELECT lookup_code INTO l_tmp_str FROM fnd_lookup_values
1008: WHERE lookup_type = 'JTF_SECTION_TYPE' AND
1009: lookup_code = p_section_type_code AND
1010: language = USERENV('LANG');
1011: EXCEPTION

Line 1124: IS SELECT lookup_code FROM fnd_lookup_values

1120: l_tmp_str VARCHAR2(30);
1121: l_return_status VARCHAR2(1);
1122:
1123: CURSOR c3(l_c_status_code IN VARCHAR2)
1124: IS SELECT lookup_code FROM fnd_lookup_values
1125: WHERE lookup_type = 'JTF_SECTION_STATUS' AND
1126: lookup_code = l_c_status_code AND
1127: language = USERENV('LANG');
1128:

Line 1298: SELECT lookup_code INTO l_tmp_str FROM fnd_lookup_values

1294: -- section type code
1295: -- note that p_section_type_code won't be NULL due to previous checks
1296: IF (p_section_type_code <> FND_API.G_MISS_CHAR) THEN
1297: BEGIN
1298: SELECT lookup_code INTO l_tmp_str FROM fnd_lookup_values
1299: WHERE lookup_type = 'JTF_SECTION_TYPE' AND
1300: lookup_code = p_section_type_code AND
1301: language = USERENV('LANG');
1302: EXCEPTION