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 3313: and exists (select 1 from as_accesses_all a ,as_rpt_admins_v rm

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

Line 3458: from as_rpt_admins_v rm

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

Line 3478: from as_rpt_admins_v rm

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

Line 3606: from as_rpt_admins_v rm

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

Line 3850: from as_rpt_admins_v rm

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

Line 3865: from as_rpt_admins_v rm

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

Line 4131: from as_rpt_admins_v rm

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

Line 4144: from as_rpt_admins_v rm

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

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

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

Line 4418: from as_rpt_admins_v rm

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

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

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

Line 4672: from as_rpt_admins_v rm

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

Line 4685: from as_rpt_admins_v rm

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

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

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

Line 5007: from as_rpt_admins_v rm

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

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

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