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 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 956: csf_lf_places'||l_dataset_profile_value||' clp

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)
960: AND UPPER (cln.NAME) = UPPER ('''||p_task_rec.city||''')';

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

959: AND clp.place_parent_level NOT IN (-1, 0)
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

Line 975: FROM csf_lf_places'||l_dataset_profile_value||'

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 (
978: SELECT pn.place_id
979: FROM csf_lf_names'||l_dataset_profile_value||' n,

Line 1096: FROM csf_lf_places'||l_dataset_profile_value||'

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
1099: START WITH place_id IN (
1100: SELECT pn.place_id

Line 1172: FROM csf_lf_places'||l_dataset_profile_value||'

1168: AND pn.name_id = n.name_id
1169: AND pc.postal_code = '''||p_task_rec.postal_code||'''
1170: AND EXISTS (
1171: SELECT 1
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

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 1575: csf_lf_places'||l_dataset_profile_value||' clp

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)
1579: AND UPPER (cln.NAME) = UPPER ('''||p_city||''')';

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

1578: AND clp.place_parent_level NOT IN (-1, 0)
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

Line 1594: FROM csf_lf_places'||l_dataset_profile_value||'

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 (
1597: SELECT pn.place_id
1598: FROM csf_lf_names'||l_dataset_profile_value||' n,

Line 1717: FROM csf_lf_places'||l_dataset_profile_value||'

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
1720: START WITH place_id IN (
1721: SELECT pn.place_id

Line 1793: FROM csf_lf_places'||l_dataset_profile_value||'

1789: AND pn.name_id = n.name_id
1790: AND pc.postal_code = '''||p_postal_code||'''
1791: AND EXISTS (
1792: SELECT 1
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

Line 2573: FROM csf_lf_places'||l_data_set_name||

2569: l_data_set_name := '';
2570: END IF;
2571:
2572: sql_stmt_str := 'SELECT DISTINCT place_id
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