APPS.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTF_TERR_ALL

Line 218: jtf_terr_all terr

214: AND NOT EXISTS
215: (SELECT 1
216: FROM jtf_terr_values_all qv,
217: jtf_terr_qual_all jtq,
218: jtf_terr_all terr
219: WHERE hzg.geography_name = qv.low_value_char
220: AND jtq.terr_qual_id = qv.terr_qual_id
221: AND jtq.org_id = p_org_id
222: AND jtq.terr_id = terr.terr_id

Line 1431: jtf_terr_all terr,

1427: terr.attribute14,
1428: terr.attribute15
1429: FROM hr_operating_units hr,
1430: jtf_terr_types_all terr_type,
1431: jtf_terr_all terr,
1432: (SELECT MAX(sys_connect_by_path(REVERSE(terr.name), '/')) hierarchy
1433: FROM jtf_terr_all terr
1434: WHERE terr.org_id = v_org_id START WITH terr.terr_id = v_terr_id CONNECT BY PRIOR terr.parent_territory_id = terr.terr_id
1435: AND terr.terr_id <> 1)

Line 1433: FROM jtf_terr_all terr

1429: FROM hr_operating_units hr,
1430: jtf_terr_types_all terr_type,
1431: jtf_terr_all terr,
1432: (SELECT MAX(sys_connect_by_path(REVERSE(terr.name), '/')) hierarchy
1433: FROM jtf_terr_all terr
1434: WHERE terr.org_id = v_org_id START WITH terr.terr_id = v_terr_id CONNECT BY PRIOR terr.parent_territory_id = terr.terr_id
1435: AND terr.terr_id <> 1)
1436: sub
1437: WHERE terr.org_id = hr.organization_id

Line 1498: FROM jtf_terr_all terr

1494: terr.attribute12,
1495: terr.attribute13,
1496: terr.attribute14,
1497: terr.attribute15
1498: FROM jtf_terr_all terr
1499: WHERE terr.org_id = v_org_id
1500: AND nvl(terr.terr_group_flag, 'N') = 'N'
1501: AND nvl(terr.enable_self_service, 'N') = 'N'
1502: AND(v_active BETWEEN terr.start_date_active

Line 1566: FROM jtf_terr_all terr

1562: terr.attribute12,
1563: terr.attribute13,
1564: terr.attribute14,
1565: terr.attribute15
1566: FROM jtf_terr_all terr
1567: WHERE terr.org_id = v_org_id
1568: AND LEVEL < 3
1569: AND nvl(terr.terr_group_flag, 'N') = 'N'
1570: AND nvl(terr.enable_self_service, 'N') = 'N'

Line 1635: FROM jtf_terr_all terr

1631: terr.attribute12,
1632: terr.attribute13,
1633: terr.attribute14,
1634: terr.attribute15
1635: FROM jtf_terr_all terr
1636: WHERE terr.org_id = v_org_id
1637: AND nvl(terr.terr_group_flag, 'N') = 'N'
1638: AND nvl(terr.enable_self_service, 'N') = 'N'
1639: AND(v_active BETWEEN terr.start_date_active

Line 1693: FROM jtf_terr_all terr,

1689: THEN
1690: --Added for bug 7639213
1691: SELECT RTRIM(REPLACE(sub.hierarchy,'/','->'),terr.name) hierarchy
1692: INTO l_parent_terr_hierarchy
1693: FROM jtf_terr_all terr,
1694: (SELECT REVERSE(SUBSTR(MAX(sys_connect_by_path(REVERSE(terr.name),'/')),2)) hierarchy
1695: FROM jtf_terr_all terr
1696: WHERE terr.org_id = p_org_id START WITH terr.terr_id = p_terr_id CONNECT BY PRIOR terr.parent_territory_id = terr.terr_id
1697: AND terr.terr_id <> 1

Line 1695: FROM jtf_terr_all terr

1691: SELECT RTRIM(REPLACE(sub.hierarchy,'/','->'),terr.name) hierarchy
1692: INTO l_parent_terr_hierarchy
1693: FROM jtf_terr_all terr,
1694: (SELECT REVERSE(SUBSTR(MAX(sys_connect_by_path(REVERSE(terr.name),'/')),2)) hierarchy
1695: FROM jtf_terr_all terr
1696: WHERE terr.org_id = p_org_id START WITH terr.terr_id = p_terr_id CONNECT BY PRIOR terr.parent_territory_id = terr.terr_id
1697: AND terr.terr_id <> 1
1698: ) sub
1699: WHERE terr.org_id = p_org_id