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 975: jtf_terr_types_all terr_type,

971: terr.attribute13,
972: terr.attribute14,
973: terr.attribute15
974: FROM hr_operating_units hr,
975: jtf_terr_types_all terr_type,
976: jtf_terr_all terr,
977: (SELECT MAX(sys_connect_by_path(REVERSE(terr.name), '/')) hierarchy
978: FROM jtf_terr_all terr
979: 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 1016: jtf_terr_types_all terr_type,

1012: sub.attribute13,
1013: sub.attribute14,
1014: sub.attribute15
1015: FROM hr_operating_units hr,
1016: jtf_terr_types_all terr_type,
1017: (SELECT terr.terr_id terr_id,
1018: terr.name terr_name,
1019: sys_connect_by_path(terr.name, '->') hierarchy,
1020: terr.parent_territory_id parent_terr_id,

Line 1084: jtf_terr_types_all terr_type,

1080: sub.attribute13,
1081: sub.attribute14,
1082: sub.attribute15
1083: FROM hr_operating_units hr,
1084: jtf_terr_types_all terr_type,
1085: (SELECT terr.terr_id terr_id,
1086: terr.name terr_name,
1087: sys_connect_by_path(terr.name, '->') hierarchy,
1088: terr.parent_territory_id parent_terr_id,

Line 1153: jtf_terr_types_all terr_type,

1149: sub.attribute13,
1150: sub.attribute14,
1151: sub.attribute15
1152: FROM hr_operating_units hr,
1153: jtf_terr_types_all terr_type,
1154: (SELECT terr.terr_id terr_id,
1155: terr.name terr_name,
1156: sys_connect_by_path(terr.name, '->') hierarchy,
1157: terr.parent_territory_id parent_terr_id,