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 5942: FROM jtf_rs_groups_denorm jrgd,

5938: WHERE secu.customer_id = P.party_id
5939: and secu.delete_flag is null
5940: and secu.sales_group_id in (
5941: SELECT jrgd.group_id
5942: FROM jtf_rs_groups_denorm jrgd,
5943: jtf_rs_group_usages jrgu
5944: WHERE jrgd.parent_group_id IN (
5945: select u.group_id
5946: from jtf_rs_rep_managers mgr,

Line 6465: FROM jtf_rs_groups_denorm jrgd,

6461: FROM as_accesses_all secu
6462: WHERE secu.customer_id = P.party_id
6463: AND secu.sales_group_id in (
6464: SELECT jrgd.group_id
6465: FROM jtf_rs_groups_denorm jrgd,
6466: jtf_rs_group_usages jrgu
6467: WHERE jrgd.parent_group_id IN (
6468: select u.group_id
6469: from jtf_rs_rep_managers mgr,

Line 6986: FROM jtf_rs_groups_denorm jrgd,

6982: AND secu.sales_lead_id IS NULL
6983: AND secu.delete_flag is NULL
6984: and secu.sales_group_id in (
6985: SELECT jrgd.group_id
6986: FROM jtf_rs_groups_denorm jrgd,
6987: jtf_rs_group_usages jrgu
6988: WHERE jrgd.parent_group_id IN (
6989: select u.group_id
6990: from jtf_rs_rep_managers mgr,

Line 7773: FROM jtf_rs_groups_denorm jrgd,

7769: AND secu.sales_lead_id IS NULL
7770: AND secu.delete_flag is NULL
7771: AND secu.sales_group_id in (
7772: SELECT jrgd.group_id
7773: FROM jtf_rs_groups_denorm jrgd,
7774: jtf_rs_group_usages jrgu
7775: WHERE jrgd.parent_group_id IN (
7776: select U.group_id
7777: from jtf_rs_rep_managers mgr,