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_GROUP_USAGES

Line 5943: jtf_rs_group_usages jrgu

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,
5947: jtf_rs_group_usages u

Line 5947: jtf_rs_group_usages u

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,
5947: jtf_rs_group_usages u
5948: where mgr.parent_resource_id = p_resource_id
5949: and trunc(sysdate) between trunc(mgr.start_date_active)
5950: and trunc(nvl(mgr.end_date_active,sysdate))
5951: and mgr.hierarchy_type = 'MGR_TO_REP'

Line 5999: jtf_rs_group_usages U

5995: select 1 from dual where exists
5996: (
5997: SELECT MGR.group_id
5998: FROM jtf_rs_rep_managers MGR ,
5999: jtf_rs_group_usages U
6000: WHERE U.usage = 'SALES'
6001: AND U.group_id = MGR.group_id
6002: AND trunc(MGR.start_date_active) <= trunc(SYSDATE)
6003: AND trunc(NVL(MGR.end_date_active, SYSDATE)) >= trunc(SYSDATE)

Line 6382: jtf_rs_group_usages U

6378: select 1 from DUAL where exists
6379: (
6380: SELECT MGR.group_id
6381: FROM jtf_rs_rep_managers MGR ,
6382: jtf_rs_group_usages U
6383: WHERE U.usage = 'SALES'
6384: AND U.group_id = MGR.group_id
6385: AND TRUNC(MGR.start_date_active) <= trunc(SYSDATE)
6386: AND TRUNC(NVL(MGR.end_date_active, SYSDATE) )>= trunc(SYSDATE)

Line 6466: jtf_rs_group_usages jrgu

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,
6470: jtf_rs_group_usages u

Line 6470: jtf_rs_group_usages u

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,
6470: jtf_rs_group_usages u
6471: where mgr.parent_resource_id = p_resource_id
6472: and trunc(sysdate) between trunc(mgr.start_date_active)
6473: and trunc(nvl(mgr.end_date_active,sysdate))
6474: and mgr.hierarchy_type = 'MGR_TO_REP'

Line 6825: jtf_rs_group_usages U

6821: select 1 from dual where exists
6822: (
6823: SELECT MGR.group_id
6824: FROM jtf_rs_rep_managers MGR ,
6825: jtf_rs_group_usages U
6826: WHERE U.usage = 'SALES'
6827: AND U.group_id = MGR.group_id
6828: AND trunc(MGR.start_date_active) <= trunc(SYSDATE)
6829: AND trunc(NVL(MGR.end_date_active, SYSDATE)) >= trunc(SYSDATE)

Line 6987: jtf_rs_group_usages jrgu

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,
6991: jtf_rs_group_usages u

Line 6991: jtf_rs_group_usages u

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,
6991: jtf_rs_group_usages u
6992: where mgr.parent_resource_id = p_resource_id
6993: and trunc(sysdate) between trunc(mgr.start_date_active)
6994: and trunc(nvl(mgr.end_date_active,sysdate))
6995: and mgr.hierarchy_type = 'MGR_TO_REP'

Line 7704: jtf_rs_group_usages U

7700: select 1 from dual where exists
7701: (
7702: SELECT MGR.group_id
7703: FROM jtf_rs_rep_managers MGR ,
7704: jtf_rs_group_usages U
7705: WHERE U.usage = 'SALES'
7706: AND U.group_id = MGR.group_id
7707: AND trunc(MGR.start_date_active) <= trunc(SYSDATE)
7708: AND trunc(NVL(MGR.end_date_active, SYSDATE)) >= trunc(SYSDATE)

Line 7774: jtf_rs_group_usages jrgu

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,
7778: jtf_rs_group_usages u

Line 7778: jtf_rs_group_usages u

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,
7778: jtf_rs_group_usages u
7779: where mgr.parent_resource_id = p_resource_id
7780: and trunc(sysdate) between trunc(mgr.start_date_active) and trunc(nvl(mgr.end_date_active,sysdate))
7781: and mgr.hierarchy_type = 'MGR_TO_REP'
7782: and mgr.group_id = u.group_id