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.JTF_RS_ROLE_RELATE_VUHK dependencies on JTF_RS_SALESREPS

Line 954: from jtf_rs_salesreps

950:
951: -- get the salesrep ID's, org ID's
952: CURSOR get_srp_org_info IS
953: select salesrep_id, org_id
954: from jtf_rs_salesreps
955: where resource_id = p_role_resource_id
956: AND p_role_resource_type = 'RS_INDIVIDUAL'
957: UNION ALL
958: select salesrep_id, org_id

Line 959: from jtf_rs_group_members gm, jtf_rs_salesreps s

955: where resource_id = p_role_resource_id
956: AND p_role_resource_type = 'RS_INDIVIDUAL'
957: UNION ALL
958: select salesrep_id, org_id
959: from jtf_rs_group_members gm, jtf_rs_salesreps s
960: where gm.group_member_id = p_role_resource_id
961: and gm.resource_id = s.resource_id
962: and delete_flag = 'N'
963: AND p_role_resource_type = 'RS_GROUP_MEMBER'

Line 966: from jtf_rs_team_members tm, jtf_rs_salesreps s

962: and delete_flag = 'N'
963: AND p_role_resource_type = 'RS_GROUP_MEMBER'
964: UNION ALL
965: select salesrep_id, org_id
966: from jtf_rs_team_members tm, jtf_rs_salesreps s
967: where tm.team_member_id = p_role_resource_id
968: and tm.team_resource_id = s.resource_id
969: and resource_type = 'INDIVIDUAL'
970: and delete_flag = 'N'

Line 1005: jtf_rs_salesreps sr,

1001: CURSOR team_member_role_relate IS
1002: SELECT t.start_date_active, t.end_date_active, rr.role_id,
1003: sr.salesrep_id, tm.team_id, t.team_name
1004: from jtf_rs_team_members tm,
1005: jtf_rs_salesreps sr,
1006: jtf_rs_team_usages tu,
1007: jtf_rs_role_relations rr,
1008: jtf_rs_roles_b rb,
1009: jtf_rs_teams_vl t

Line 1433: from jtf_rs_salesreps

1429: l_orig_acc_mode VARCHAR2(1);
1430:
1431: CURSOR get_srp_org_info IS
1432: select salesrep_id, org_id
1433: from jtf_rs_salesreps
1434: where resource_id = l_role_resource_id
1435: AND l_role_resource_type = 'RS_INDIVIDUAL'
1436: UNION ALL
1437: select salesrep_id, org_id

Line 1438: from jtf_rs_group_members gm, jtf_rs_salesreps s

1434: where resource_id = l_role_resource_id
1435: AND l_role_resource_type = 'RS_INDIVIDUAL'
1436: UNION ALL
1437: select salesrep_id, org_id
1438: from jtf_rs_group_members gm, jtf_rs_salesreps s
1439: where gm.group_member_id = l_role_resource_id
1440: and gm.resource_id = s.resource_id
1441: and delete_flag = 'N'
1442: AND l_role_resource_type = 'RS_GROUP_MEMBER'

Line 1445: from jtf_rs_team_members tm, jtf_rs_salesreps s

1441: and delete_flag = 'N'
1442: AND l_role_resource_type = 'RS_GROUP_MEMBER'
1443: UNION ALL
1444: select salesrep_id, org_id
1445: from jtf_rs_team_members tm, jtf_rs_salesreps s
1446: where tm.team_member_id = l_role_resource_id
1447: and tm.team_resource_id = s.resource_id
1448: and resource_type = 'INDIVIDUAL'
1449: and delete_flag = 'N'

Line 1839: from jtf_rs_salesreps

1835: l_resource_category VARCHAR2(30);
1836:
1837: CURSOR get_srp_org_info IS
1838: select salesrep_id, org_id
1839: from jtf_rs_salesreps
1840: where resource_id = l_role_resource_id
1841: AND l_role_resource_type = 'RS_INDIVIDUAL'
1842: UNION ALL
1843: select salesrep_id, org_id

Line 1844: from jtf_rs_group_members gm, jtf_rs_salesreps s

1840: where resource_id = l_role_resource_id
1841: AND l_role_resource_type = 'RS_INDIVIDUAL'
1842: UNION ALL
1843: select salesrep_id, org_id
1844: from jtf_rs_group_members gm, jtf_rs_salesreps s
1845: where gm.group_member_id = l_role_resource_id
1846: and gm.resource_id = s.resource_id
1847: and delete_flag = 'N'
1848: AND l_role_resource_type = 'RS_GROUP_MEMBER'

Line 1851: from jtf_rs_team_members tm, jtf_rs_salesreps s

1847: and delete_flag = 'N'
1848: AND l_role_resource_type = 'RS_GROUP_MEMBER'
1849: UNION ALL
1850: select salesrep_id, org_id
1851: from jtf_rs_team_members tm, jtf_rs_salesreps s
1852: where tm.team_member_id = l_role_resource_id
1853: and tm.team_resource_id = s.resource_id
1854: and resource_type = 'INDIVIDUAL'
1855: and delete_flag = 'N'

Line 1863: jtf_rs_salesreps sr,

1859: CURSOR team_member_role_relate IS
1860: SELECT t.start_date_active, t.end_date_active, rr.role_id,
1861: sr.salesrep_id, tm.team_id, t.team_name
1862: from jtf_rs_team_members tm,
1863: jtf_rs_salesreps sr,
1864: jtf_rs_team_usages tu,
1865: jtf_rs_role_relations rr,
1866: jtf_rs_roles_b rb,
1867: jtf_rs_teams_vl t

Line 2182: from jtf_rs_salesreps

2178:
2179: -- get the salesrep ID's, org ID's
2180: CURSOR get_srp_org_info IS
2181: select salesrep_id, org_id
2182: from jtf_rs_salesreps
2183: where resource_id = l_role_resource_id
2184: AND l_role_resource_type = 'RS_INDIVIDUAL'
2185: UNION ALL
2186: select salesrep_id, org_id

Line 2187: from jtf_rs_group_members gm, jtf_rs_salesreps s

2183: where resource_id = l_role_resource_id
2184: AND l_role_resource_type = 'RS_INDIVIDUAL'
2185: UNION ALL
2186: select salesrep_id, org_id
2187: from jtf_rs_group_members gm, jtf_rs_salesreps s
2188: where gm.group_member_id = l_role_resource_id
2189: and gm.resource_id = s.resource_id
2190: and delete_flag = 'N'
2191: AND l_role_resource_type = 'RS_GROUP_MEMBER'

Line 2194: from jtf_rs_team_members tm, jtf_rs_salesreps s

2190: and delete_flag = 'N'
2191: AND l_role_resource_type = 'RS_GROUP_MEMBER'
2192: UNION ALL
2193: select salesrep_id, org_id
2194: from jtf_rs_team_members tm, jtf_rs_salesreps s
2195: where tm.team_member_id = l_role_resource_id
2196: and tm.team_resource_id = s.resource_id
2197: and resource_type = 'INDIVIDUAL'
2198: and delete_flag = 'N'

Line 2205: jtf_rs_salesreps sr,

2201: -- run in single-org context
2202: CURSOR team_member_role_relate IS
2203: SELECT rr.start_date_active, rr.end_date_active, tm.team_id, t.team_name
2204: from jtf_rs_team_members tm,
2205: jtf_rs_salesreps sr,
2206: jtf_rs_team_usages tu,
2207: jtf_rs_role_relations rr,
2208: jtf_rs_roles_b rb,
2209: jtf_rs_teams_vl t