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_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_RSC_ALL

Line 796: FROM jtf_terr_rsc_all jtr,

792: AND inlv.qual_type_id = cl_qual_type_id
793: AND jtqa.qual_usg_id <> -1102 -- eliminate CNRG
794: AND EXISTS
795: (SELECT 1
796: FROM jtf_terr_rsc_all jtr,
797: jtf_terr_rsc_access_all jtra,
798: jtf_qual_types_all jqta
799: WHERE jtr.terr_id = jta.terr_id
800: AND jtr.end_date_active >= sysdate

Line 857: FROM jtf_terr_rsc_all jtr,

853: AND cnrg.cnr_group_id = jtva.low_value_char_id
854: AND cnrg.cnr_group_id = cnrgv.cnr_group_id
855: AND EXISTS
856: (SELECT 1
857: FROM jtf_terr_rsc_all jtr,
858: jtf_terr_rsc_access_all jtra,
859: jtf_qual_types_all jqta
860: WHERE jtr.terr_id = jta.terr_id
861: AND jtr.end_date_active >= sysdate

Line 915: FROM jtf_terr_rsc_all jtr,

911: AND inlv.qual_type_id = cl_qual_type_id
912: AND jtqa.qual_usg_id <> -1102 -- eliminate CNRG
913: AND EXISTS
914: (SELECT 1
915: FROM jtf_terr_rsc_all jtr,
916: jtf_terr_rsc_access_all jtra,
917: jtf_qual_types_all jqta
918: WHERE jtr.terr_id = jta.terr_id
919: AND jtr.resource_type <> 'RS_ROLE'

Line 973: FROM jtf_terr_rsc_all jtr,

969: AND cnrg.cnr_group_id = jtva.low_value_char_id
970: AND cnrg.cnr_group_id = cnrgv.cnr_group_id
971: AND EXISTS
972: (SELECT 1
973: FROM jtf_terr_rsc_all jtr,
974: jtf_terr_rsc_access_all jtra,
975: jtf_qual_types_all jqta
976: WHERE jtr.terr_id = jta.terr_id
977: AND jtr.resource_type <> 'RS_ROLE'