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_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 954: FROM csf_lf_names'||l_dataset_profile_value||' cln,

950: l_dataset_profile_value := '';
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

Line 965: csf_lf_names'||l_dataset_profile_value||' n

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

Line 972: FROM csf_lf_names'||l_dataset_profile_value||' n,

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

Line 979: FROM csf_lf_names'||l_dataset_profile_value||' n,

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,
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

Line 1093: FROM csf_lf_names'||l_dataset_profile_value||' n,

1089: l_flag := NULL;
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)

Line 1101: FROM csf_lf_names'||l_dataset_profile_value||' n,

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
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

Line 1165: csf_lf_names'||l_dataset_profile_value||' n

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
1169: AND pc.postal_code = '''||p_task_rec.postal_code||'''

Line 1175: FROM csf_lf_names'||l_dataset_profile_value||' cln,

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
1177: WHERE cln.NAME = '''||l_place||'''
1178: AND cln.name_id = clpn.name_id)
1179: CONNECT BY place_id = PRIOR parent_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 1573: FROM csf_lf_names'||l_dataset_profile_value||' cln,

1569: l_dataset_profile_value := '';
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

Line 1584: csf_lf_names'||l_dataset_profile_value||' n

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

Line 1591: FROM csf_lf_names'||l_dataset_profile_value||' n,

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

Line 1598: FROM csf_lf_names'||l_dataset_profile_value||' n,

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,
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

Line 1714: FROM csf_lf_names'||l_dataset_profile_value||' n,

1710: l_flag := NULL;
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)

Line 1722: FROM csf_lf_names'||l_dataset_profile_value||' n,

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
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

Line 1786: csf_lf_names'||l_dataset_profile_value||' n

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
1790: AND pc.postal_code = '''||p_postal_code||'''

Line 1796: FROM csf_lf_names'||l_dataset_profile_value||' cln,

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
1798: WHERE cln.NAME = UPPER('''||l_place||''')
1799: AND cln.name_id = clpn.name_id)
1800: CONNECT BY place_id = PRIOR parent_place_id

Line 2576: FROM csf_lf_names'||l_data_set_name|| ' n,

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
2578: WHERE n.name_id = pn.name_id
2579: AND n.name = ''' || upper(p_city)|| ''' )
2580: CONNECT BY PRIOR parent_place_id = place_id';