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

Line 2124: FROM fnd_lookup_values

2120: IF p_lookup_code IS NOT NULL
2121: THEN
2122: SELECT p_lookup_code||' - '||meaning meaning
2123: INTO l_lookup_meaning
2124: FROM fnd_lookup_values
2125: WHERE lookup_type = p_lookup_type
2126: AND lookup_code = p_lookup_code
2127: AND language = userenv('LANG');
2128: END IF;

Line 3262: from fnd_lookup_values

3258:
3259: if (p_code = 'DFD') then
3260: begin
3261: select meaning into l_ext_cert_val
3262: from fnd_lookup_values
3263: where lookup_type like 'FV_EXTERNAL_CERTIFICATION'
3264: and lookup_code =(select code from fv_ccr_class_codes where duns = p_duns
3265: and codetype like 'External Certification' AND code like 'DFD%'
3266: AND ROWNUM <=1)

Line 3276: from fnd_lookup_values

3272:
3273: elsif (p_code = 'EPL') then
3274: begin
3275: select meaning into l_ext_cert_val
3276: from fnd_lookup_values
3277: where lookup_type like 'FV_EXTERNAL_CERTIFICATION'
3278: and lookup_code =(select code from fv_ccr_class_codes where duns = p_duns
3279: and codetype like 'External Certification' AND code like 'EPL%'
3280: AND ROWNUM <=1)

Line 3315: from fnd_lookup_values

3311:
3312: if(l_flagtype = 'NPD' AND l_flagval = 'Y') then
3313: begin
3314: select meaning into l_flag_code
3315: from fnd_lookup_values
3316: where lookup_type like 'FV_CCR_FLAGS'
3317: and lookup_code = l_flagtype||l_flagval
3318: and language = Userenv('LANG');
3319: exception when no_data_found then

Line 3326: from fnd_lookup_values

3322:
3323: ELSIF (l_flagtype = 'NPD') then
3324: begin
3325: select meaning into l_flag_code
3326: from fnd_lookup_values
3327: where lookup_type like 'FV_CCR_FLAGS'
3328: and lookup_code = l_flagtype
3329: and language = Userenv('LANG');
3330: exception when no_data_found then

Line 3476: from fnd_lookup_values flv

3472: if (substr(p_code, 1, 3) = 'STA') then
3473: begin
3474: select lpad('State :', 33)||substr(p_code,4)||' - '||meaning
3475: into l_dis_code_val
3476: from fnd_lookup_values flv
3477: where flv.lookup_type = 'FV_DIS_CODE_STATE'
3478: and flv.lookup_code = substr(p_code, 4)
3479: and flv.language = userenv('LANG')
3480: and rownum<=1;

Line 3490: from fnd_lookup_values flv

3486: elsif (substr(p_code, 1, 3) = 'CTY') then
3487: begin
3488: select lpad('County :', 33)||substr(p_code,4)||' - '||meaning
3489: into l_dis_code_val
3490: from fnd_lookup_values flv
3491: where flv.lookup_type = 'FV_DIS_CODE_COUNTY'
3492: and flv.lookup_code = substr(p_code, 4)
3493: and flv.language = userenv('LANG')
3494: and rownum<=1;

Line 3504: from fnd_lookup_values flv

3500: elsif (substr(p_code, 1,3) = 'MSA') then
3501: begin
3502: select lpad('Metropolitan Statistical Area :', 33)||substr(p_code,4)||' - '||meaning
3503: into l_dis_code_val
3504: from fnd_lookup_values flv
3505: where flv.lookup_type = 'FV_DIS_CODE_MSA'
3506: and flv.lookup_code = substr(p_code, 4)
3507: and flv.language = userenv('LANG')
3508: and rownum<=1;

Line 3518: from fnd_lookup_values flv

3514: elsif (substr(p_code, 1,3) = 'ANY') then
3515: begin
3516: select substr(p_code,4)||' - '||meaning
3517: into l_dis_code_val
3518: from fnd_lookup_values flv
3519: where flv.lookup_type = 'FV_DIS_CODE_ANY'
3520: and flv.lookup_code = substr(p_code, 4)
3521: and flv.language = userenv('LANG')
3522: and rownum<=1;