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_ACCESS_PVT dependencies on AS_RPT_ADMINS_V

Line 231: from as_rpt_admins_v rm

227: select 'x'
228: from as_accesses_all a
229: where a.sales_lead_id = p_sales_lead_id
230: and EXISTS (select 'x'
231: from as_rpt_admins_v rm
232: where a.salesforce_id = rm.salesforce_id
233: and rm.parent_sales_group_id = p_admin_group_id
234: and ((rm.salesforce_id = p_identity_salesforce_id
235: and a.owner_flag ='Y')

Line 244: from as_rpt_admins_v rm

240: from as_accesses_all a
241: where a.sales_lead_id = p_sales_lead_id
242: and a.owner_flag = 'Y'
243: and EXISTS (select 'x'
244: from as_rpt_admins_v rm
245: where a.salesforce_id = rm.salesforce_id
246: and rm.parent_sales_group_id = p_admin_group_id);
247:
248: cursor am_mgr_access_csr(p_resource_id number) is

Line 259: from as_sales_leads lead, as_accesses_all a, as_rpt_admins_v rm

255: and lead.sales_lead_id = p_sales_lead_id;
256:
257: cursor am_admin_access_csr is
258: select 'x'
259: from as_sales_leads lead, as_accesses_all a, as_rpt_admins_v rm
260: where lead.customer_id = a.customer_id
261: and a.salesforce_id = rm.salesforce_id
262: and a.salesforce_role_code = 'AM'
263: and rm.parent_sales_group_id = p_admin_group_id

Line 544: from as_rpt_admins_v rm

540: select 'x'
541: from as_accesses_all a
542: where a.lead_id = p_lead_id
543: and EXISTS (select 'x'
544: from as_rpt_admins_v rm
545: where a.salesforce_id = rm.salesforce_id
546: and rm.parent_sales_group_id = p_admin_group_id
547: and ((rm.salesforce_id = p_identity_salesforce_id
548: and a.owner_flag ='Y')

Line 557: from as_rpt_admins_v rm

553: from as_accesses_all a
554: where a.lead_id = p_lead_id
555: and a.owner_flag = 'Y'
556: and EXISTS (select 'x'
557: from as_rpt_admins_v rm
558: where a.salesforce_id = rm.salesforce_id
559: and rm.parent_sales_group_id = p_admin_group_id);
560:
561: cursor am_admin_access_csr is

Line 563: from as_leads_all lead, as_accesses_all a, as_rpt_admins_v rm

559: and rm.parent_sales_group_id = p_admin_group_id);
560:
561: cursor am_admin_access_csr is
562: select 'x'
563: from as_leads_all lead, as_accesses_all a, as_rpt_admins_v rm
564: where lead.customer_id = a.customer_id
565: and a.salesforce_id = rm.salesforce_id
566: and a.salesforce_role_code = 'AM'
567: and rm.parent_sales_group_id = p_admin_group_id

Line 3312: and exists (select 1 from as_accesses_all a ,as_rpt_admins_v rm

3308: and p.party_type in ('ORGANIZATION','PERSON')
3309: and rel.subject_id = p_customer_id
3310: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3311: and rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3312: and exists (select 1 from as_accesses_all a ,as_rpt_admins_v rm
3313: where a.salesforce_id = rm.salesforce_id
3314: and a.customer_id = rel.object_id
3315: and rm.parent_sales_group_id = p_admin_group_id)
3316: and rownum = 1;

Line 3457: from as_rpt_admins_v rm

3453: and a.sales_lead_id is null
3454: and rel.object_table_name = 'HZ_PARTIES'
3455: and rel.subject_table_name = 'HZ_PARTIES'
3456: and EXISTS (select 'x'
3457: from as_rpt_admins_v rm
3458: where a.salesforce_id = rm.salesforce_id
3459: and rm.parent_sales_group_id = p_admin_group_id
3460: and ((rm.salesforce_id = p_identity_salesforce_id
3461: and a.team_leader_flag = 'Y')

Line 3477: from as_rpt_admins_v rm

3473: and a.team_leader_flag = 'Y'
3474: and rel.object_table_name = 'HZ_PARTIES'
3475: and rel.subject_table_name = 'HZ_PARTIES'
3476: and EXISTS (select 'x'
3477: from as_rpt_admins_v rm
3478: where a.salesforce_id = rm.salesforce_id
3479: and rm.parent_sales_group_id = p_admin_group_id);
3480:
3481: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 3605: from as_rpt_admins_v rm

3601: select 'X'
3602: from as_accesses_all a
3603: where customer_id = p_customer_id
3604: and EXISTS (select 'x'
3605: from as_rpt_admins_v rm
3606: where a.salesforce_id = rm.salesforce_id
3607: and rm.parent_sales_group_id = p_admin_group_id);
3608: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
3609: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.has_viewCustomerAccess';

Line 3849: from as_rpt_admins_v rm

3845: where customer_id = p_customer_id
3846: and lead_id is null
3847: and sales_lead_id is null
3848: and EXISTS (select 'x'
3849: from as_rpt_admins_v rm
3850: where a.salesforce_id = rm.salesforce_id
3851: and rm.parent_sales_group_id = p_admin_group_id
3852: and ((rm.salesforce_id = p_identity_salesforce_id
3853: and a.team_leader_flag = 'Y')

Line 3864: from as_rpt_admins_v rm

3860: and lead_id is null
3861: and sales_lead_id is null
3862: and a.team_leader_flag = 'Y'
3863: and EXISTS (select 'x'
3864: from as_rpt_admins_v rm
3865: where a.salesforce_id = rm.salesforce_id
3866: and rm.parent_sales_group_id = p_admin_group_id);
3867:
3868: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 4130: from as_rpt_admins_v rm

4126: select 'x'
4127: from as_accesses_all a
4128: where a.sales_lead_id = p_sales_lead_id
4129: and EXISTS (select 'x'
4130: from as_rpt_admins_v rm
4131: where a.salesforce_id = rm.salesforce_id
4132: and rm.parent_sales_group_id = p_admin_group_id
4133: and (rm.salesforce_id = p_identity_salesforce_id
4134: and (a.team_leader_flag = 'Y' or a.owner_flag = 'Y')

Line 4143: from as_rpt_admins_v rm

4139: from as_accesses_all a
4140: where a.sales_lead_id = p_sales_lead_id
4141: and (a.team_leader_flag = 'Y' or a.owner_flag = 'Y')
4142: and EXISTS (select 'x'
4143: from as_rpt_admins_v rm
4144: where a.salesforce_id = rm.salesforce_id
4145: and rm.parent_sales_group_id = p_admin_group_id);
4146:
4147: cursor am_mgr_access_csr(p_resource_id number) is

Line 4158: from as_sales_leads lead, as_accesses_all a, as_rpt_admins_v rm

4154: and lead.sales_lead_id = p_sales_lead_id;
4155:
4156: cursor am_admin_access_csr is
4157: select 'x'
4158: from as_sales_leads lead, as_accesses_all a, as_rpt_admins_v rm
4159: where lead.customer_id = a.customer_id
4160: and a.salesforce_id = rm.salesforce_id
4161: and a.salesforce_role_code = 'AM'
4162: and rm.parent_sales_group_id = p_admin_group_id

Line 4417: from as_rpt_admins_v rm

4413: select 'x'
4414: from as_accesses_all a
4415: where a.sales_lead_id = p_sales_lead_id
4416: and EXISTS (select 'x'
4417: from as_rpt_admins_v rm
4418: where a.salesforce_id = rm.salesforce_id
4419: and rm.parent_sales_group_id = p_admin_group_id);
4420:
4421: cursor am_mgr_access_csr(p_resource_id number) is

Line 4432: from as_sales_leads lead, as_accesses_all a, as_rpt_admins_v rm

4428: and lead.sales_lead_id = p_sales_lead_id;
4429:
4430: cursor am_admin_access_csr is
4431: select 'x'
4432: from as_sales_leads lead, as_accesses_all a, as_rpt_admins_v rm
4433: where lead.customer_id = a.customer_id
4434: and a.salesforce_id = rm.salesforce_id
4435: and a.salesforce_role_code = 'AM'
4436: and rm.parent_sales_group_id = p_admin_group_id

Line 4671: from as_rpt_admins_v rm

4667: select 'x'
4668: from as_accesses_all a
4669: where a.lead_id = p_opportunity_id
4670: and EXISTS (select 'x'
4671: from as_rpt_admins_v rm
4672: where a.salesforce_id = rm.salesforce_id
4673: and rm.parent_sales_group_id = p_admin_group_id
4674: and ((rm.salesforce_id = p_identity_salesforce_id
4675: and a.team_leader_flag = 'Y')

Line 4684: from as_rpt_admins_v rm

4680: from as_accesses_all a
4681: where a.lead_id = p_opportunity_id
4682: and a.team_leader_flag = 'Y'
4683: and EXISTS (select 'x'
4684: from as_rpt_admins_v rm
4685: where a.salesforce_id = rm.salesforce_id
4686: and rm.parent_sales_group_id = p_admin_group_id);
4687:
4688: cursor am_mgr_access_csr(p_resource_id number) is

Line 4700: from as_leads opp, as_accesses_all a, as_rpt_admins_v rm

4696: and sysdate between rm.start_date_active and nvl(rm.end_date_active, sysdate);
4697:
4698: cursor am_admin_access_csr is
4699: select 'x'
4700: from as_leads opp, as_accesses_all a, as_rpt_admins_v rm
4701: where opp.customer_id = a.customer_id
4702: and a.salesforce_id = rm.salesforce_id
4703: and a.salesforce_role_code = 'AM'
4704: and rm.parent_sales_group_id = p_admin_group_id

Line 5006: from as_rpt_admins_v rm

5002: select 'x'
5003: from as_accesses_all a
5004: where a.lead_id = p_opportunity_id
5005: and EXISTS (select 'x'
5006: from as_rpt_admins_v rm
5007: where a.salesforce_id = rm.salesforce_id
5008: and rm.parent_sales_group_id = p_admin_group_id);
5009:
5010:

Line 5023: from as_leads opp, as_accesses_all a, as_rpt_admins_v rm

5019: and sysdate between rm.start_date_active and nvl(rm.end_date_active, sysdate);
5020:
5021: cursor am_admin_access_csr is
5022: select 'x'
5023: from as_leads opp, as_accesses_all a, as_rpt_admins_v rm
5024: where opp.customer_id = a.customer_id
5025: and a.salesforce_id = rm.salesforce_id
5026: and a.salesforce_role_code = 'AM'
5027: and rm.parent_sales_group_id = p_admin_group_id