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.JTY_WEBADI_OTH_TERR_DWNL_PKG dependencies on JTF_TERR_TYPES_ALL

Line 1430: jtf_terr_types_all terr_type,

1426: terr.attribute13,
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

Line 1471: jtf_terr_types_all terr_type,

1467: sub.attribute13,
1468: sub.attribute14,
1469: sub.attribute15
1470: FROM hr_operating_units hr,
1471: jtf_terr_types_all terr_type,
1472: (SELECT terr.terr_id terr_id,
1473: terr.name terr_name,
1474: sys_connect_by_path(terr.name, '->') hierarchy,
1475: terr.parent_territory_id parent_terr_id,

Line 1539: jtf_terr_types_all terr_type,

1535: sub.attribute13,
1536: sub.attribute14,
1537: sub.attribute15
1538: FROM hr_operating_units hr,
1539: jtf_terr_types_all terr_type,
1540: (SELECT terr.terr_id terr_id,
1541: terr.name terr_name,
1542: sys_connect_by_path(terr.name, '->') hierarchy,
1543: terr.parent_territory_id parent_terr_id,

Line 1608: jtf_terr_types_all terr_type,

1604: sub.attribute13,
1605: sub.attribute14,
1606: sub.attribute15
1607: FROM hr_operating_units hr,
1608: jtf_terr_types_all terr_type,
1609: (SELECT terr.terr_id terr_id,
1610: terr.name terr_name,
1611: sys_connect_by_path(terr.name, '->') hierarchy,
1612: terr.parent_territory_id parent_terr_id,