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.CSF_TASK_ADDRESS_PVT dependencies on CSF_LF_PLACES

Line 1259: FROM csf_lf_places p, csf_lf_names n, csf_lf_place_names pn

1255:
1256: CURSOR l_place_csr (l_place_name VARCHAR2, l_parent_level NUMBER)
1257: IS
1258: SELECT NAME
1259: FROM csf_lf_places p, csf_lf_names n, csf_lf_place_names pn
1260: WHERE n.name_id = pn.name_id
1261: AND pn.place_id = p.place_id
1262: AND NAME = l_place_name
1263: AND p.place_parent_level = l_parent_level;

Line 1321: csf_lf_places'||l_dataset_profile_value||' clp

1317:
1318: l_uk_city :=' SELECT cln.NAME
1319: FROM csf_lf_names'||l_dataset_profile_value||' cln,
1320: csf_lf_place_names'||l_dataset_profile_value||' clpn,
1321: csf_lf_places'||l_dataset_profile_value||' clp
1322: WHERE cln.name_id = clpn.name_id
1323: AND clpn.place_id = clp.place_id
1324: AND clp.place_parent_level NOT IN (-1, 0)
1325: AND UPPER (cln.NAME) = UPPER ('''||p_task_rec.city||''')';

Line 1328: FROM csf_lf_places'||l_dataset_profile_value||' p,

1324: AND clp.place_parent_level NOT IN (-1, 0)
1325: AND UPPER (cln.NAME) = UPPER ('''||p_task_rec.city||''')';
1326:
1327: l_place_country :=' SELECT n.NAME
1328: FROM csf_lf_places'||l_dataset_profile_value||' p,
1329: csf_lf_place_names'||l_dataset_profile_value||' pn,
1330: csf_lf_names'||l_dataset_profile_value||' n
1331: WHERE n.NAME = UPPER ('''||l_country||''')
1332: AND pn.name_id = n.name_id

Line 1340: FROM csf_lf_places'||l_dataset_profile_value||'

1336: l_place_state :=' SELECT n.NAME
1337: FROM csf_lf_names'||l_dataset_profile_value||' n,
1338: csf_lf_place_names'||l_dataset_profile_value||' pn,
1339: (SELECT place_id
1340: FROM csf_lf_places'||l_dataset_profile_value||'
1341: CONNECT BY PRIOR place_id = parent_place_id
1342: START WITH place_id IN (
1343: SELECT pn.place_id
1344: FROM csf_lf_names'||l_dataset_profile_value||' n,

Line 1461: FROM csf_lf_places'||l_dataset_profile_value||'

1457: l_place_city :=' SELECT n.NAME
1458: FROM csf_lf_names'||l_dataset_profile_value||' n,
1459: csf_lf_place_names'||l_dataset_profile_value||' pn,
1460: (SELECT place_id
1461: FROM csf_lf_places'||l_dataset_profile_value||'
1462: WHERE place_parent_level IN (1, 8)
1463: CONNECT BY PRIOR place_id = parent_place_id
1464: START WITH place_id IN (
1465: SELECT pn.place_id

Line 1537: FROM csf_lf_places'||l_dataset_profile_value||'

1533: AND pn.name_id = n.name_id
1534: AND pc.postal_code = '''||p_task_rec.postal_code||'''
1535: AND EXISTS (
1536: SELECT 1
1537: FROM csf_lf_places'||l_dataset_profile_value||'
1538: WHERE place_id IN (
1539: SELECT clpn.place_id
1540: FROM csf_lf_names'||l_dataset_profile_value||' cln,
1541: csf_lf_place_names'||l_dataset_profile_value||' clpn

Line 1962: FROM csf_lf_places p, csf_lf_names n, csf_lf_place_names pn

1958:
1959: CURSOR l_place_csr (l_place_name VARCHAR2, l_parent_level NUMBER)
1960: IS
1961: SELECT NAME
1962: FROM csf_lf_places p, csf_lf_names n, csf_lf_place_names pn
1963: WHERE n.name_id = pn.name_id
1964: AND pn.place_id = p.place_id
1965: AND NAME = l_place_name
1966: AND p.place_parent_level = l_parent_level;

Line 2021: csf_lf_places'||l_dataset_profile_value||' clp

2017:
2018: l_uk_city :=' SELECT cln.NAME
2019: FROM csf_lf_names'||l_dataset_profile_value||' cln,
2020: csf_lf_place_names'||l_dataset_profile_value||' clpn,
2021: csf_lf_places'||l_dataset_profile_value||' clp
2022: WHERE cln.name_id = clpn.name_id
2023: AND clpn.place_id = clp.place_id
2024: AND clp.place_parent_level NOT IN (-1, 0)
2025: AND UPPER (cln.NAME) = UPPER ('''||p_city||''')';

Line 2028: FROM csf_lf_places'||l_dataset_profile_value||' p,

2024: AND clp.place_parent_level NOT IN (-1, 0)
2025: AND UPPER (cln.NAME) = UPPER ('''||p_city||''')';
2026:
2027: l_place_country :=' SELECT n.NAME
2028: FROM csf_lf_places'||l_dataset_profile_value||' p,
2029: csf_lf_place_names'||l_dataset_profile_value||' pn,
2030: csf_lf_names'||l_dataset_profile_value||' n
2031: WHERE n.NAME = UPPER ('''||l_country||''')
2032: AND pn.name_id = n.name_id

Line 2040: FROM csf_lf_places'||l_dataset_profile_value||'

2036: l_place_state :=' SELECT n.NAME
2037: FROM csf_lf_names'||l_dataset_profile_value||' n,
2038: csf_lf_place_names'||l_dataset_profile_value||' pn,
2039: (SELECT place_id
2040: FROM csf_lf_places'||l_dataset_profile_value||'
2041: CONNECT BY PRIOR place_id = parent_place_id
2042: START WITH place_id IN (
2043: SELECT pn.place_id
2044: FROM csf_lf_names'||l_dataset_profile_value||' n,

Line 2163: FROM csf_lf_places'||l_dataset_profile_value||'

2159: l_place_city := ' SELECT n.NAME
2160: FROM csf_lf_names'||l_dataset_profile_value||' n,
2161: csf_lf_place_names'||l_dataset_profile_value||' pn,
2162: (SELECT place_id
2163: FROM csf_lf_places'||l_dataset_profile_value||'
2164: WHERE place_parent_level IN (1, 8)
2165: CONNECT BY PRIOR place_id = parent_place_id
2166: START WITH place_id IN (
2167: SELECT pn.place_id

Line 2239: FROM csf_lf_places'||l_dataset_profile_value||'

2235: AND pn.name_id = n.name_id
2236: AND pc.postal_code = '''||p_postal_code||'''
2237: AND EXISTS (
2238: SELECT 1
2239: FROM csf_lf_places'||l_dataset_profile_value||'
2240: WHERE place_id IN (
2241: SELECT clpn.place_id
2242: FROM csf_lf_names'||l_dataset_profile_value||' cln,
2243: csf_lf_place_names'||l_dataset_profile_value||' clpn

Line 3171: FROM csf_lf_places'||l_data_set_name||

3167: END;
3168: END IF;
3169:
3170: sql_stmt_str := 'SELECT DISTINCT place_id
3171: FROM csf_lf_places'||l_data_set_name||
3172: ' WHERE place_parent_level = -1 START WITH place_id IN
3173: (SELECT pn.place_id
3174: FROM csf_lf_names'||l_data_set_name|| ' n,
3175: csf_lf_place_names'||l_data_set_name||' pn