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.PER_RI_CONFIG_TECH_SUMMARY dependencies on FND_TERRITORIES_VL

Line 103: l_bg_postjoin_sql := ' ) X ,FND_TERRITORIES_VL terr ,fnd_lookup_values lookup1, '

99: end if;
100: hr_utility.set_location('Leaving BG Loop',20);
101: dbms_lob.trim(l_bg_clob,length(l_bg_clob)-5);
102:
103: l_bg_postjoin_sql := ' ) X ,FND_TERRITORIES_VL terr ,fnd_lookup_values lookup1, '
104: ||' fnd_lookup_values lookup2,fnd_lookup_values lookup3 , '
105: ||' fnd_currencies_vl curr '
106: ||' where terr.TERRITORY_CODE = X.Legislation_code '
107: ||' and lookup1.lookup_code= app_gen_method '

Line 544: from fnd_territories_vl terr

540: and application_column_name = cp_app_col_name;
541:
542: cursor csr_get_style(cp_style in varchar2) IS
543: select terr.territory_short_name Address_Style
544: from fnd_territories_vl terr
545: where terr.territory_code = cp_style;
546:
547: BEGIN
548: hr_utility.set_location('Entering ' || l_proc,10);

Line 554: l_postjoin_sql := ') A, fnd_territories_vl terr where terr.territory_code(+) = A.style ';

550: dbms_lob.createtemporary(l_location_clob,TRUE);
551:
552: l_prejoin_sql := ' select decode(A.style,''GENERIC'',''Generic'',terr.territory_short_name) Address_Style '
553: ||' from ( ';
554: l_postjoin_sql := ') A, fnd_territories_vl terr where terr.territory_code(+) = A.style ';
555: l_orderby := ' order by style desc ,location_code desc ';
556:
557: if p_location_tab.count > 0 THEN
558: for i in p_location_tab.first ..

Line 3079: l_postjoin_sql := ' )A , FND_TERRITORIES_VL terr ,fnd_currencies_vl curr,hr_lookups lookup '

3075: l_prejoin_sql := ' select terr.TERRITORY_SHORT_NAME Legislation , curr.name Currency, A.Tax_Start_Date, '
3076: ||' lookup.meaning Install_Tax_Unit_Val '
3077: ||' from ( ';
3078:
3079: l_postjoin_sql := ' )A , FND_TERRITORIES_VL terr ,fnd_currencies_vl curr,hr_lookups lookup '
3080: ||' where terr.TERRITORY_CODE = A.legislation_code '
3081: ||' and curr.currency_code = A.currency_code '
3082: ||' and lookup.lookup_code = A.install_tax_unit '
3083: ||' and lookup.lookup_type=''YES_NO'' and lookup.application_id=800 '

Line 3386: l_postjoin_sql := ' )A , FND_TERRITORIES_VL terr ,fnd_application_vl fapp '

3382: l_prejoin_sql := ' select decode(A.legislation_code,''BF'',''International'',terr.TERRITORY_SHORT_NAME) Legislation , '
3383: ||' fapp.application_name '
3384: ||' from ( ';
3385:
3386: l_postjoin_sql := ' )A , FND_TERRITORIES_VL terr ,fnd_application_vl fapp '
3387: ||' where terr.TERRITORY_CODE = A.legislation_code '
3388: ||' and fapp.application_short_name = A.application_short_name '
3389: ||' order by Legislation desc , fapp.application_name desc';
3390: