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.

[Home] [Help]

APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_RSC_ALL

Line 880: FROM jtf_terr_rsc_all jtr,

876: AND inlv.qual_type_id = cl_qual_type_id
877: AND jtqa.qual_usg_id <> -1102 -- eliminate CNRG
878: AND EXISTS
879: (SELECT 1
880: FROM jtf_terr_rsc_all jtr,
881: jtf_terr_rsc_access_all jtra,
882: jtf_qual_types_all jqta
883: WHERE jtr.terr_id = jta.terr_id
884: AND jtr.end_date_active >= sysdate

Line 941: FROM jtf_terr_rsc_all jtr,

937: AND cnrg.cnr_group_id = jtva.low_value_char_id
938: AND cnrg.cnr_group_id = cnrgv.cnr_group_id
939: AND EXISTS
940: (SELECT 1
941: FROM jtf_terr_rsc_all jtr,
942: jtf_terr_rsc_access_all jtra,
943: jtf_qual_types_all jqta
944: WHERE jtr.terr_id = jta.terr_id
945: AND jtr.end_date_active >= sysdate

Line 999: FROM jtf_terr_rsc_all jtr,

995: AND inlv.qual_type_id = cl_qual_type_id
996: AND jtqa.qual_usg_id <> -1102 -- eliminate CNRG
997: AND EXISTS
998: (SELECT 1
999: FROM jtf_terr_rsc_all jtr,
1000: jtf_terr_rsc_access_all jtra,
1001: jtf_qual_types_all jqta
1002: WHERE jtr.terr_id = jta.terr_id
1003: AND jtr.resource_type <> 'RS_ROLE'

Line 1057: FROM jtf_terr_rsc_all jtr,

1053: AND cnrg.cnr_group_id = jtva.low_value_char_id
1054: AND cnrg.cnr_group_id = cnrgv.cnr_group_id
1055: AND EXISTS
1056: (SELECT 1
1057: FROM jtf_terr_rsc_all jtr,
1058: jtf_terr_rsc_access_all jtra,
1059: jtf_qual_types_all jqta
1060: WHERE jtr.terr_id = jta.terr_id
1061: AND jtr.resource_type <> 'RS_ROLE'