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_PLACE_NAMES

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 1320: csf_lf_place_names'||l_dataset_profile_value||' clpn,

1316: END IF;
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)

Line 1329: csf_lf_place_names'||l_dataset_profile_value||' pn,

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
1333: AND p.place_id = pn.place_id

Line 1338: csf_lf_place_names'||l_dataset_profile_value||' pn,

1334: AND p.place_parent_level = -1';
1335:
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 (

Line 1345: csf_lf_place_names'||l_dataset_profile_value||' pn

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,
1345: csf_lf_place_names'||l_dataset_profile_value||' pn
1346: WHERE n.NAME = UPPER ('''|| l_country||''')
1347: AND pn.name_id = n.name_id)) p
1348: WHERE pn.place_id = p.place_id
1349: AND n.name_id = pn.name_id

Line 1459: csf_lf_place_names'||l_dataset_profile_value||' pn,

1455: END IF;
1456:
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

Line 1467: csf_lf_place_names'||l_dataset_profile_value||' pn

1463: CONNECT BY PRIOR place_id = parent_place_id
1464: START WITH place_id IN (
1465: SELECT pn.place_id
1466: FROM csf_lf_names'||l_dataset_profile_value||' n,
1467: csf_lf_place_names'||l_dataset_profile_value||' pn
1468: WHERE n.NAME = UPPER ('''||l_place||''')
1469: AND pn.name_id = n.name_id)) p
1470: WHERE pn.place_id = p.place_id
1471: AND n.name_id = pn.name_id

Line 1529: csf_lf_place_names'||l_dataset_profile_value||' pn,

1525:
1526: l_place_zip := 'SELECT pc.postal_code
1527: FROM csf_lf_postcodes'||l_dataset_profile_value||' pc,
1528: csf_lf_place_postcs'||l_dataset_profile_value||' ppc,
1529: csf_lf_place_names'||l_dataset_profile_value||' pn,
1530: csf_lf_names'||l_dataset_profile_value||' n
1531: WHERE pc.postal_code_id = ppc.postal_code_id
1532: AND ppc.place_id = pn.place_id
1533: AND pn.name_id = n.name_id

Line 1541: csf_lf_place_names'||l_dataset_profile_value||' clpn

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
1542: WHERE cln.NAME = '''||l_place||'''
1543: AND cln.name_id = clpn.name_id)
1544: CONNECT BY place_id = PRIOR parent_place_id
1545: START WITH place_id = pn.place_id)';

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 2020: csf_lf_place_names'||l_dataset_profile_value||' clpn,

2016: END IF;
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)

Line 2029: csf_lf_place_names'||l_dataset_profile_value||' pn,

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
2033: AND p.place_id = pn.place_id

Line 2038: csf_lf_place_names'||l_dataset_profile_value||' pn,

2034: AND p.place_parent_level = -1';
2035:
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 (

Line 2045: csf_lf_place_names'||l_dataset_profile_value||' pn

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,
2045: csf_lf_place_names'||l_dataset_profile_value||' pn
2046: WHERE n.NAME = UPPER ('''|| l_country||''')
2047: AND pn.name_id = n.name_id)) p
2048: WHERE pn.place_id = p.place_id
2049: AND n.name_id = pn.name_id

Line 2161: csf_lf_place_names'||l_dataset_profile_value||' pn,

2157: END IF;
2158:
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

Line 2169: csf_lf_place_names'||l_dataset_profile_value||' pn

2165: CONNECT BY PRIOR place_id = parent_place_id
2166: START WITH place_id IN (
2167: SELECT pn.place_id
2168: FROM csf_lf_names'||l_dataset_profile_value||' n,
2169: csf_lf_place_names'||l_dataset_profile_value||' pn
2170: WHERE n.NAME = UPPER ('''||l_place||''')
2171: AND pn.name_id = n.name_id)) p
2172: WHERE pn.place_id = p.place_id
2173: AND n.name_id = pn.name_id

Line 2231: csf_lf_place_names'||l_dataset_profile_value||' pn,

2227:
2228: l_place_zip := 'SELECT pc.postal_code
2229: FROM csf_lf_postcodes'||l_dataset_profile_value||' pc,
2230: csf_lf_place_postcs'||l_dataset_profile_value||' ppc,
2231: csf_lf_place_names'||l_dataset_profile_value||' pn,
2232: csf_lf_names'||l_dataset_profile_value||' n
2233: WHERE pc.postal_code_id = ppc.postal_code_id
2234: AND ppc.place_id = pn.place_id
2235: AND pn.name_id = n.name_id

Line 2243: csf_lf_place_names'||l_dataset_profile_value||' clpn

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
2244: WHERE cln.NAME = UPPER('''||l_place||''')
2245: AND cln.name_id = clpn.name_id)
2246: CONNECT BY place_id = PRIOR parent_place_id
2247: START WITH place_id = pn.place_id)';

Line 3175: csf_lf_place_names'||l_data_set_name||' pn

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
3176: WHERE n.name_id = pn.name_id
3177: AND n.name = ''' || upper(p_city)|| ''' )
3178: CONNECT BY PRIOR parent_place_id = place_id';
3179: OPEN c_countryfromcity FOR sql_stmt_str;