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 896: FROM csf_lf_places p, csf_lf_names n, csf_lf_place_names pn

892:
893: CURSOR l_place_csr (l_place_name VARCHAR2, l_parent_level NUMBER)
894: IS
895: SELECT NAME
896: FROM csf_lf_places p, csf_lf_names n, csf_lf_place_names pn
897: WHERE n.name_id = pn.name_id
898: AND pn.place_id = p.place_id
899: AND NAME = l_place_name
900: AND p.place_parent_level = l_parent_level;

Line 955: csf_lf_place_names'||l_dataset_profile_value||' clpn,

951: END IF;
952:
953: l_uk_city :=' SELECT cln.NAME
954: FROM csf_lf_names'||l_dataset_profile_value||' cln,
955: csf_lf_place_names'||l_dataset_profile_value||' clpn,
956: csf_lf_places'||l_dataset_profile_value||' clp
957: WHERE cln.name_id = clpn.name_id
958: AND clpn.place_id = clp.place_id
959: AND clp.place_parent_level NOT IN (-1, 0)

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

960: AND UPPER (cln.NAME) = UPPER ('''||p_task_rec.city||''')';
961:
962: l_place_country :=' SELECT n.NAME
963: FROM csf_lf_places'||l_dataset_profile_value||' p,
964: csf_lf_place_names'||l_dataset_profile_value||' pn,
965: csf_lf_names'||l_dataset_profile_value||' n
966: WHERE n.NAME = UPPER ('''||l_country||''')
967: AND pn.name_id = n.name_id
968: AND p.place_id = pn.place_id

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

969: AND p.place_parent_level = -1';
970:
971: l_place_state :=' SELECT n.NAME
972: FROM csf_lf_names'||l_dataset_profile_value||' n,
973: csf_lf_place_names'||l_dataset_profile_value||' pn,
974: (SELECT place_id
975: FROM csf_lf_places'||l_dataset_profile_value||'
976: CONNECT BY PRIOR place_id = parent_place_id
977: START WITH place_id IN (

Line 980: csf_lf_place_names'||l_dataset_profile_value||' pn

976: CONNECT BY PRIOR place_id = parent_place_id
977: START WITH place_id IN (
978: SELECT pn.place_id
979: FROM csf_lf_names'||l_dataset_profile_value||' n,
980: csf_lf_place_names'||l_dataset_profile_value||' pn
981: WHERE n.NAME = UPPER ('''|| l_country||''')
982: AND pn.name_id = n.name_id)) p
983: WHERE pn.place_id = p.place_id
984: AND n.name_id = pn.name_id

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

1090: END IF;
1091:
1092: l_place_city :=' SELECT n.NAME
1093: FROM csf_lf_names'||l_dataset_profile_value||' n,
1094: csf_lf_place_names'||l_dataset_profile_value||' pn,
1095: (SELECT place_id
1096: FROM csf_lf_places'||l_dataset_profile_value||'
1097: WHERE place_parent_level IN (1, 8)
1098: CONNECT BY PRIOR place_id = parent_place_id

Line 1102: csf_lf_place_names'||l_dataset_profile_value||' pn

1098: CONNECT BY PRIOR place_id = parent_place_id
1099: START WITH place_id IN (
1100: SELECT pn.place_id
1101: FROM csf_lf_names'||l_dataset_profile_value||' n,
1102: csf_lf_place_names'||l_dataset_profile_value||' pn
1103: WHERE n.NAME = UPPER ('''||l_place||''')
1104: AND pn.name_id = n.name_id)) p
1105: WHERE pn.place_id = p.place_id
1106: AND n.name_id = pn.name_id

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

1160:
1161: l_place_zip := 'SELECT pc.postal_code
1162: FROM csf_lf_postcodes'||l_dataset_profile_value||' pc,
1163: csf_lf_place_postcs'||l_dataset_profile_value||' ppc,
1164: csf_lf_place_names'||l_dataset_profile_value||' pn,
1165: csf_lf_names'||l_dataset_profile_value||' n
1166: WHERE pc.postal_code_id = ppc.postal_code_id
1167: AND ppc.place_id = pn.place_id
1168: AND pn.name_id = n.name_id

Line 1176: csf_lf_place_names'||l_dataset_profile_value||' clpn

1172: FROM csf_lf_places'||l_dataset_profile_value||'
1173: WHERE place_id IN (
1174: SELECT clpn.place_id
1175: FROM csf_lf_names'||l_dataset_profile_value||' cln,
1176: csf_lf_place_names'||l_dataset_profile_value||' clpn
1177: WHERE cln.NAME = '''||l_place||'''
1178: AND cln.name_id = clpn.name_id)
1179: CONNECT BY place_id = PRIOR parent_place_id
1180: START WITH place_id = pn.place_id)';

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

1514:
1515: CURSOR l_place_csr (l_place_name VARCHAR2, l_parent_level NUMBER)
1516: IS
1517: SELECT NAME
1518: FROM csf_lf_places p, csf_lf_names n, csf_lf_place_names pn
1519: WHERE n.name_id = pn.name_id
1520: AND pn.place_id = p.place_id
1521: AND NAME = l_place_name
1522: AND p.place_parent_level = l_parent_level;

Line 1574: csf_lf_place_names'||l_dataset_profile_value||' clpn,

1570: END IF;
1571:
1572: l_uk_city :=' SELECT cln.NAME
1573: FROM csf_lf_names'||l_dataset_profile_value||' cln,
1574: csf_lf_place_names'||l_dataset_profile_value||' clpn,
1575: csf_lf_places'||l_dataset_profile_value||' clp
1576: WHERE cln.name_id = clpn.name_id
1577: AND clpn.place_id = clp.place_id
1578: AND clp.place_parent_level NOT IN (-1, 0)

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

1579: AND UPPER (cln.NAME) = UPPER ('''||p_city||''')';
1580:
1581: l_place_country :=' SELECT n.NAME
1582: FROM csf_lf_places'||l_dataset_profile_value||' p,
1583: csf_lf_place_names'||l_dataset_profile_value||' pn,
1584: csf_lf_names'||l_dataset_profile_value||' n
1585: WHERE n.NAME = UPPER ('''||l_country||''')
1586: AND pn.name_id = n.name_id
1587: AND p.place_id = pn.place_id

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

1588: AND p.place_parent_level = -1';
1589:
1590: l_place_state :=' SELECT n.NAME
1591: FROM csf_lf_names'||l_dataset_profile_value||' n,
1592: csf_lf_place_names'||l_dataset_profile_value||' pn,
1593: (SELECT place_id
1594: FROM csf_lf_places'||l_dataset_profile_value||'
1595: CONNECT BY PRIOR place_id = parent_place_id
1596: START WITH place_id IN (

Line 1599: csf_lf_place_names'||l_dataset_profile_value||' pn

1595: CONNECT BY PRIOR place_id = parent_place_id
1596: START WITH place_id IN (
1597: SELECT pn.place_id
1598: FROM csf_lf_names'||l_dataset_profile_value||' n,
1599: csf_lf_place_names'||l_dataset_profile_value||' pn
1600: WHERE n.NAME = UPPER ('''|| l_country||''')
1601: AND pn.name_id = n.name_id)) p
1602: WHERE pn.place_id = p.place_id
1603: AND n.name_id = pn.name_id

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

1711: END IF;
1712:
1713: l_place_city := ' SELECT n.NAME
1714: FROM csf_lf_names'||l_dataset_profile_value||' n,
1715: csf_lf_place_names'||l_dataset_profile_value||' pn,
1716: (SELECT place_id
1717: FROM csf_lf_places'||l_dataset_profile_value||'
1718: WHERE place_parent_level IN (1, 8)
1719: CONNECT BY PRIOR place_id = parent_place_id

Line 1723: csf_lf_place_names'||l_dataset_profile_value||' pn

1719: CONNECT BY PRIOR place_id = parent_place_id
1720: START WITH place_id IN (
1721: SELECT pn.place_id
1722: FROM csf_lf_names'||l_dataset_profile_value||' n,
1723: csf_lf_place_names'||l_dataset_profile_value||' pn
1724: WHERE n.NAME = UPPER ('''||l_place||''')
1725: AND pn.name_id = n.name_id)) p
1726: WHERE pn.place_id = p.place_id
1727: AND n.name_id = pn.name_id

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

1781:
1782: l_place_zip := 'SELECT pc.postal_code
1783: FROM csf_lf_postcodes'||l_dataset_profile_value||' pc,
1784: csf_lf_place_postcs'||l_dataset_profile_value||' ppc,
1785: csf_lf_place_names'||l_dataset_profile_value||' pn,
1786: csf_lf_names'||l_dataset_profile_value||' n
1787: WHERE pc.postal_code_id = ppc.postal_code_id
1788: AND ppc.place_id = pn.place_id
1789: AND pn.name_id = n.name_id

Line 1797: csf_lf_place_names'||l_dataset_profile_value||' clpn

1793: FROM csf_lf_places'||l_dataset_profile_value||'
1794: WHERE place_id IN (
1795: SELECT clpn.place_id
1796: FROM csf_lf_names'||l_dataset_profile_value||' cln,
1797: csf_lf_place_names'||l_dataset_profile_value||' clpn
1798: WHERE cln.NAME = UPPER('''||l_place||''')
1799: AND cln.name_id = clpn.name_id)
1800: CONNECT BY place_id = PRIOR parent_place_id
1801: START WITH place_id = pn.place_id)';

Line 2577: csf_lf_place_names'||l_data_set_name||' pn

2573: FROM csf_lf_places'||l_data_set_name||
2574: ' WHERE place_parent_level = -1 START WITH place_id IN
2575: (SELECT pn.place_id
2576: FROM csf_lf_names'||l_data_set_name|| ' n,
2577: csf_lf_place_names'||l_data_set_name||' pn
2578: WHERE n.name_id = pn.name_id
2579: AND n.name = ''' || upper(p_city)|| ''' )
2580: CONNECT BY PRIOR parent_place_id = place_id';
2581: OPEN c_countryfromcity FOR sql_stmt_str;