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 5927: jtf_rs_group_usages jrgu

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

Line 5931: jtf_rs_group_usages u

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,
5931: jtf_rs_group_usages u
5932: where mgr.parent_resource_id = p_resource_id
5933: and trunc(sysdate) between trunc(mgr.start_date_active)
5934: and trunc(nvl(mgr.end_date_active,sysdate))
5935: and mgr.hierarchy_type = 'MGR_TO_REP'

Line 5983: jtf_rs_group_usages U

5979: select 1 from dual where exists
5980: (
5981: SELECT MGR.group_id
5982: FROM jtf_rs_rep_managers MGR ,
5983: jtf_rs_group_usages U
5984: WHERE U.usage = 'SALES'
5985: AND U.group_id = MGR.group_id
5986: AND trunc(MGR.start_date_active) <= trunc(SYSDATE)
5987: AND trunc(NVL(MGR.end_date_active, SYSDATE)) >= trunc(SYSDATE)

Line 6366: jtf_rs_group_usages U

6362: select 1 from DUAL where exists
6363: (
6364: SELECT MGR.group_id
6365: FROM jtf_rs_rep_managers MGR ,
6366: jtf_rs_group_usages U
6367: WHERE U.usage = 'SALES'
6368: AND U.group_id = MGR.group_id
6369: AND TRUNC(MGR.start_date_active) <= trunc(SYSDATE)
6370: AND TRUNC(NVL(MGR.end_date_active, SYSDATE) )>= trunc(SYSDATE)

Line 6450: jtf_rs_group_usages jrgu

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

Line 6454: jtf_rs_group_usages u

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,
6454: jtf_rs_group_usages u
6455: where mgr.parent_resource_id = p_resource_id
6456: and trunc(sysdate) between trunc(mgr.start_date_active)
6457: and trunc(nvl(mgr.end_date_active,sysdate))
6458: and mgr.hierarchy_type = 'MGR_TO_REP'

Line 6809: jtf_rs_group_usages U

6805: select 1 from dual where exists
6806: (
6807: SELECT MGR.group_id
6808: FROM jtf_rs_rep_managers MGR ,
6809: jtf_rs_group_usages U
6810: WHERE U.usage = 'SALES'
6811: AND U.group_id = MGR.group_id
6812: AND trunc(MGR.start_date_active) <= trunc(SYSDATE)
6813: AND trunc(NVL(MGR.end_date_active, SYSDATE)) >= trunc(SYSDATE)

Line 6971: jtf_rs_group_usages jrgu

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

Line 6975: jtf_rs_group_usages u

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,
6975: jtf_rs_group_usages u
6976: where mgr.parent_resource_id = p_resource_id
6977: and trunc(sysdate) between trunc(mgr.start_date_active)
6978: and trunc(nvl(mgr.end_date_active,sysdate))
6979: and mgr.hierarchy_type = 'MGR_TO_REP'

Line 7688: jtf_rs_group_usages U

7684: select 1 from dual where exists
7685: (
7686: SELECT MGR.group_id
7687: FROM jtf_rs_rep_managers MGR ,
7688: jtf_rs_group_usages U
7689: WHERE U.usage = 'SALES'
7690: AND U.group_id = MGR.group_id
7691: AND trunc(MGR.start_date_active) <= trunc(SYSDATE)
7692: AND trunc(NVL(MGR.end_date_active, SYSDATE)) >= trunc(SYSDATE)

Line 7758: jtf_rs_group_usages jrgu

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

Line 7762: jtf_rs_group_usages u

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,
7762: jtf_rs_group_usages u
7763: where mgr.parent_resource_id = p_resource_id
7764: and trunc(sysdate) between trunc(mgr.start_date_active) and trunc(nvl(mgr.end_date_active,sysdate))
7765: and mgr.hierarchy_type = 'MGR_TO_REP'
7766: and mgr.group_id = u.group_id