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.ASO_VALIDATE_PVT dependencies on JTF_RS_GROUPS_DENORM

Line 5926: FROM jtf_rs_groups_denorm jrgd,

5922: WHERE secu.customer_id = P.party_id
5923: and secu.delete_flag is null
5924: and secu.sales_group_id in (
5925: SELECT jrgd.group_id
5926: FROM jtf_rs_groups_denorm jrgd,
5927: jtf_rs_group_usages jrgu
5928: WHERE jrgd.parent_group_id IN (
5929: select u.group_id
5930: from jtf_rs_rep_managers mgr,

Line 6449: FROM jtf_rs_groups_denorm jrgd,

6445: FROM as_accesses_all secu
6446: WHERE secu.customer_id = P.party_id
6447: AND secu.sales_group_id in (
6448: SELECT jrgd.group_id
6449: FROM jtf_rs_groups_denorm jrgd,
6450: jtf_rs_group_usages jrgu
6451: WHERE jrgd.parent_group_id IN (
6452: select u.group_id
6453: from jtf_rs_rep_managers mgr,

Line 6970: FROM jtf_rs_groups_denorm jrgd,

6966: AND secu.sales_lead_id IS NULL
6967: AND secu.delete_flag is NULL
6968: and secu.sales_group_id in (
6969: SELECT jrgd.group_id
6970: FROM jtf_rs_groups_denorm jrgd,
6971: jtf_rs_group_usages jrgu
6972: WHERE jrgd.parent_group_id IN (
6973: select u.group_id
6974: from jtf_rs_rep_managers mgr,

Line 7757: FROM jtf_rs_groups_denorm jrgd,

7753: AND secu.sales_lead_id IS NULL
7754: AND secu.delete_flag is NULL
7755: AND secu.sales_group_id in (
7756: SELECT jrgd.group_id
7757: FROM jtf_rs_groups_denorm jrgd,
7758: jtf_rs_group_usages jrgu
7759: WHERE jrgd.parent_group_id IN (
7760: select U.group_id
7761: from jtf_rs_rep_managers mgr,