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.AS_SALES_LEAD_ASSIGN_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 885: FROM jtf_rs_resource_extns res

881: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id;
882:
883: CURSOR C_Validate_Partner_User(c_resource_id NUMBER) IS
884: SELECT 'Y'
885: FROM jtf_rs_resource_extns res
886: WHERE res.category = 'PARTY'
887: AND res.resource_id = c_resource_id;
888:
889: CURSOR C_Get_CM(c_partner_id NUMBER) IS

Line 903: FROM jtf_rs_resource_extns

899: -- If resource is partner user, source_id is party_id of the
900: -- relationship.
901: CURSOR C_Get_Partner_Cont_Party_id(c_resource_id NUMBER) IS
902: SELECT source_id
903: FROM jtf_rs_resource_extns
904: WHERE resource_id = c_resource_id;
905:
906: CURSOR C_Get_Partner_Org_sf_id(c_referred_by NUMBER) IS
907: SELECT resource_id

Line 908: FROM jtf_rs_resource_extns

904: WHERE resource_id = c_resource_id;
905:
906: CURSOR C_Get_Partner_Org_sf_id(c_referred_by NUMBER) IS
907: SELECT resource_id
908: FROM jtf_rs_resource_extns
909: WHERE source_id = c_referred_by
910: AND category = 'PARTNER';
911:
912: -- Bug 3035251

Line 1021: jtf_rs_roles_b tr, jtf_rs_resource_extns tres,

1017: MIN(t.team_id) team_id, tres.category resource_category,
1018: MIN(TRES.source_id) person_id
1019: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,
1020: jtf_rs_team_usages tu, jtf_rs_role_relations trr,
1021: jtf_rs_roles_b tr, jtf_rs_resource_extns tres,
1022: (
1023: SELECT m.group_id group_id, m.resource_id resource_id
1024: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
1025: jtf_rs_group_usages u, jtf_rs_role_relations rr,

Line 1026: jtf_rs_roles_b r, jtf_rs_resource_extns res

1022: (
1023: SELECT m.group_id group_id, m.resource_id resource_id
1024: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
1025: jtf_rs_group_usages u, jtf_rs_role_relations rr,
1026: jtf_rs_roles_b r, jtf_rs_resource_extns res
1027: WHERE
1028: m.group_id = g.group_id
1029: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
1030: AND NVL(g.end_date_active,SYSDATE)

Line 1072: jtf_rs_roles_b r, jtf_rs_resource_extns res,

1068: MIN(jtm.team_id) team_id, res.category resource_category,
1069: MIN(res.source_id) person_id
1070: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
1071: jtf_rs_group_usages u, jtf_rs_role_relations rr,
1072: jtf_rs_roles_b r, jtf_rs_resource_extns res,
1073: (
1074: Select tm.team_resource_id group_id, t.team_id team_id
1075: From jtf_rs_team_members tm, jtf_rs_teams_b t,
1076: jtf_rs_team_usages tu, jtf_rs_role_relations trr,

Line 1077: jtf_rs_roles_b tr, jtf_rs_resource_extns tres

1073: (
1074: Select tm.team_resource_id group_id, t.team_id team_id
1075: From jtf_rs_team_members tm, jtf_rs_teams_b t,
1076: jtf_rs_team_usages tu, jtf_rs_role_relations trr,
1077: jtf_rs_roles_b tr, jtf_rs_resource_extns tres
1078: Where tm.team_id = t.team_id
1079: and sysdate between nvl(t.start_date_active,sysdate)
1080: and nvl(t.end_date_active,sysdate)
1081: and tu.team_id = t.team_id

Line 1126: jtf_rs_roles_b r, jtf_rs_resource_extns res

1122: res.category resource_category,
1123: MIN(m.group_id) group_id,MIN(res.source_id) person_id
1124: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
1125: jtf_rs_group_usages u, jtf_rs_role_relations rr,
1126: jtf_rs_roles_b r, jtf_rs_resource_extns res
1127: WHERE
1128: m.group_id = g.group_id
1129: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
1130: AND NVL(g.end_date_active,SYSDATE)

Line 1154: jtf_rs_resource_extns res,

1150: c_fieldsales VARCHAR2, c_prm VARCHAR2,
1151: c_n VARCHAR2, c_employee VARCHAR2) IS
1152: SELECT 'Y'
1153: FROM per_all_people_f per,
1154: jtf_rs_resource_extns res,
1155: jtf_rs_role_relations rrel,
1156: jtf_rs_roles_b role
1157: WHERE TRUNC(SYSDATE) BETWEEN per.effective_start_date
1158: AND per.effective_end_date

Line 1170: FROM jtf_rs_resource_extns res

1166: AND res.category = c_employee; --'EMPLOYEE';
1167:
1168: CURSOR C_get_current_resource IS
1169: SELECT res.resource_id
1170: FROM jtf_rs_resource_extns res
1171: WHERE res.category IN ('EMPLOYEE', 'PARTY')
1172: AND res.user_id = fnd_global.user_id;
1173:
1174: CURSOR c_get_group_id (c_resource_id NUMBER, c_rs_group_member VARCHAR2,

Line 2145: jtf_rs_roles_b tr, jtf_rs_resource_extns tres,

2141: MIN(t.team_id) team_id, tres.category resource_category,
2142: MIN(TRES.source_id) person_id
2143: FROM jtf_rs_team_members tm, jtf_rs_teams_b t,
2144: jtf_rs_team_usages tu, jtf_rs_role_relations trr,
2145: jtf_rs_roles_b tr, jtf_rs_resource_extns tres,
2146: (
2147: SELECT m.group_id group_id, m.resource_id resource_id
2148: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
2149: jtf_rs_group_usages u, jtf_rs_role_relations rr,

Line 2150: jtf_rs_roles_b r, jtf_rs_resource_extns res

2146: (
2147: SELECT m.group_id group_id, m.resource_id resource_id
2148: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
2149: jtf_rs_group_usages u, jtf_rs_role_relations rr,
2150: jtf_rs_roles_b r, jtf_rs_resource_extns res
2151: WHERE
2152: m.group_id = g.group_id
2153: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
2154: AND NVL(g.end_date_active,SYSDATE)

Line 2196: jtf_rs_roles_b r, jtf_rs_resource_extns res,

2192: MIN(jtm.team_id) team_id, res.category resource_category,
2193: MIN(res.source_id) person_id
2194: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
2195: jtf_rs_group_usages u, jtf_rs_role_relations rr,
2196: jtf_rs_roles_b r, jtf_rs_resource_extns res,
2197: (
2198: Select tm.team_resource_id group_id, t.team_id team_id
2199: From jtf_rs_team_members tm, jtf_rs_teams_b t,
2200: jtf_rs_team_usages tu, jtf_rs_role_relations trr,

Line 2201: jtf_rs_roles_b tr, jtf_rs_resource_extns tres

2197: (
2198: Select tm.team_resource_id group_id, t.team_id team_id
2199: From jtf_rs_team_members tm, jtf_rs_teams_b t,
2200: jtf_rs_team_usages tu, jtf_rs_role_relations trr,
2201: jtf_rs_roles_b tr, jtf_rs_resource_extns tres
2202: Where tm.team_id = t.team_id
2203: and sysdate between nvl(t.start_date_active,sysdate)
2204: and nvl(t.end_date_active,sysdate)
2205: and tu.team_id = t.team_id

Line 2250: jtf_rs_roles_b r, jtf_rs_resource_extns res

2246: res.category resource_category,
2247: MIN(m.group_id) group_id,MIN(res.source_id) person_id
2248: FROM jtf_rs_group_members m, jtf_rs_groups_b g,
2249: jtf_rs_group_usages u, jtf_rs_role_relations rr,
2250: jtf_rs_roles_b r, jtf_rs_resource_extns res
2251: WHERE
2252: m.group_id = g.group_id
2253: AND SYSDATE BETWEEN NVL(g.start_date_active,SYSDATE)
2254: AND NVL(g.end_date_active,SYSDATE)

Line 2278: jtf_rs_resource_extns res,

2274: c_fieldsales VARCHAR2, c_prm VARCHAR2,
2275: c_n VARCHAR2, c_employee VARCHAR2) IS
2276: SELECT 'Y'
2277: FROM per_all_people_f per,
2278: jtf_rs_resource_extns res,
2279: jtf_rs_role_relations rrel,
2280: jtf_rs_roles_b role
2281: WHERE TRUNC(SYSDATE) BETWEEN per.effective_start_date
2282: AND per.effective_end_date

Line 4007: FROM jtf_rs_resource_extns b

4003: p_request_id,
4004: l_open_status_flag,
4005: l_lead_rank_score,
4006: l_creation_date
4007: FROM jtf_rs_resource_extns b
4008: WHERE b.resource_id = g_i_resource_id(l_i);
4009: END IF;
4010:
4011: IF g_ti_count > 0

Line 4111: FROM jtf_rs_resource_extns res

4107: p_salesgroup_id IN NUMBER)
4108: IS
4109: CURSOR C_get_current_resource IS
4110: SELECT res.resource_id
4111: FROM jtf_rs_resource_extns res
4112: WHERE res.category IN ('EMPLOYEE', 'PARTY')
4113: AND res.user_id = fnd_global.user_id;
4114:
4115: -- A resource may not be in any group. Besides, jtf_rs_group_members

Line 4120: FROM jtf_rs_resource_extns res

4116: -- may not have person_id for all resources. Therefore, get person_id
4117: -- is this cursor.
4118: CURSOR c_get_person_id(c_resource_id NUMBER) IS
4119: SELECT res.source_id
4120: FROM jtf_rs_resource_extns res
4121: WHERE res.resource_id = c_resource_id;
4122:
4123: -- Check whether profile resource or login resource is in the sales
4124: -- team or not. Group_id is not necessary to check here because we don't

Line 4324: FROM jtf_rs_resource_extns res

4320: l_user_id NUMBER; --code added for bug12766399
4321:
4322: CURSOR C_get_current_resource IS
4323: SELECT res.resource_id
4324: FROM jtf_rs_resource_extns res
4325: WHERE res.category IN ('EMPLOYEE', 'PARTY')
4326: AND res.user_id = fnd_global.user_id;
4327:
4328: CURSOR c_get_group_id(c_resource_id NUMBER) IS

Line 4356: FROM jtf_rs_resource_extns res

4352: -- may not have person_id for all resources. Therefore, get person_id
4353: -- in this cursor, instead of in the above cursor.
4354: CURSOR c_get_person_id(c_resource_id NUMBER) IS
4355: SELECT res.source_id
4356: FROM jtf_rs_resource_extns res
4357: WHERE res.resource_id = c_resource_id;
4358:
4359: CURSOR c_access_exist(c_sales_lead_id NUMBER, c_resource_id NUMBER,
4360: c_group_id NUMBER) IS

Line 4386: SELECT user_id from jtf_rs_resource_extns

4382: AND sl.lead_rank_id = rk.rank_id(+);
4383:
4384: --code added for bug12766399
4385: CURSOR c_get_user_id(c_resource_id NUMBER) IS
4386: SELECT user_id from jtf_rs_resource_extns
4387: WHERE resource_id= c_resource_id;
4388: BEGIN
4389: x_return_status := FND_API.G_RET_STS_SUCCESS;
4390: --l_resource_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID'); --code commented for bug12766399

Line 4725: FROM jtf_rs_resource_extns res

4721: l_creation_date DATE;
4722:
4723: CURSOR C_get_current_resource IS
4724: SELECT res.resource_id
4725: FROM jtf_rs_resource_extns res
4726: WHERE res.category IN ('EMPLOYEE', 'PARTY')
4727: AND res.user_id = fnd_global.user_id;
4728:
4729: CURSOR c_get_group_id(c_resource_id NUMBER) IS

Line 5042: FROM jtf_rs_resource_extns res

5038: -- may not have person_id for all resources. Therefore, get person_id
5039: -- in this cursor, instead of in the above cursor.
5040: CURSOR c_get_person_id(c_resource_id NUMBER) IS
5041: SELECT res.source_id
5042: FROM jtf_rs_resource_extns res
5043: WHERE res.resource_id = c_resource_id;
5044:
5045: CURSOR c_get_group_id(c_resource_id NUMBER) IS
5046: SELECT grp.group_id

Line 5348: FROM jtf_rs_resource_extns res

5344: l_rs_id NUMBER := NULL;
5345:
5346: CURSOR C_get_current_resource IS
5347: SELECT res.resource_id
5348: FROM jtf_rs_resource_extns res
5349: WHERE res.category = 'EMPLOYEE'
5350: AND res.user_id = fnd_global.user_id;
5351:
5352: CURSOR c_get_group_id(c_resource_id NUMBER) IS

Line 5380: FROM jtf_rs_resource_extns res

5376: -- may not have person_id for all resources. Therefore, get person_id
5377: -- in this cursor, instead of in the above cursor.
5378: CURSOR c_get_person_id(c_resource_id NUMBER) IS
5379: SELECT res.source_id
5380: FROM jtf_rs_resource_extns res
5381: WHERE res.resource_id = c_resource_id;
5382:
5383: BEGIN
5384: l_rs_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');