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 HZ_PARTIES

Line 1210: FROM HZ_PARTIES

1206: l_return_status VARCHAR2(1);
1207:
1208: CURSOR C_Party_Exists (X_Party_Id NUMBER) IS
1209: SELECT 1
1210: FROM HZ_PARTIES
1211: WHERE party_id = X_Party_Id;
1212:
1213: BEGIN
1214:

Line 3242: from hz_parties

3238: function is_party_person (p_customer_id in number)
3239: RETURN BOOLEAN IS
3240: cursor get_party_person_csr is
3241: select 'x'
3242: from hz_parties
3243: where party_id = p_customer_id
3244: and party_type = 'PERSON';
3245: l_tmp varchar2(1);
3246: begin

Line 3278: from as_accesses_all a, hz_parties p,hz_relationships rel

3274:
3275: cursor resource_access_csr is
3276:
3277: select 'X'
3278: from as_accesses_all a, hz_parties p,hz_relationships rel
3279: where a.customer_id = rel.object_id
3280: and rel.object_id = p.party_id
3281: and p.party_type in ('ORGANIZATION','PERSON')
3282: and rel.subject_id = p_customer_id

Line 3284: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

3280: and rel.object_id = p.party_id
3281: and p.party_type in ('ORGANIZATION','PERSON')
3282: and rel.subject_id = p_customer_id
3283: and a.salesforce_id = p_identity_salesforce_id
3284: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3285: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3286: and rownum = 1;
3287:
3288:

Line 3285: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

3281: and p.party_type in ('ORGANIZATION','PERSON')
3282: and rel.subject_id = p_customer_id
3283: and a.salesforce_id = p_identity_salesforce_id
3284: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3285: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3286: and rownum = 1;
3287:
3288:
3289: cursor manager_access_csr(p_resource_id number) is

Line 3293: hz_parties p,hz_relationships rel

3289: cursor manager_access_csr(p_resource_id number) is
3290:
3291: select 'X'
3292: from as_accesses_all a, as_rpt_managers_v rm,
3293: hz_parties p,hz_relationships rel
3294: where a.customer_id = rel.object_id
3295: and rel.object_id = p.party_id
3296: and p.party_type in ('ORGANIZATION','PERSON')
3297: and a.salesforce_id = rm.resource_id

Line 3300: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

3296: and p.party_type in ('ORGANIZATION','PERSON')
3297: and a.salesforce_id = rm.resource_id
3298: and rel.subject_id = p_customer_id
3299: and rm.parent_resource_id = p_resource_id
3300: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3301: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3302: and rownum = 1;
3303:
3304: cursor admin_access_csr is

Line 3301: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

3297: and a.salesforce_id = rm.resource_id
3298: and rel.subject_id = p_customer_id
3299: and rm.parent_resource_id = p_resource_id
3300: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3301: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3302: and rownum = 1;
3303:
3304: cursor admin_access_csr is
3305:

Line 3307: from hz_parties p, hz_relationships rel

3303:
3304: cursor admin_access_csr is
3305:
3306: select 'X'
3307: from hz_parties p, hz_relationships rel
3308: where rel.object_id = p.party_id
3309: and p.party_type in ('ORGANIZATION','PERSON')
3310: and rel.subject_id = p_customer_id
3311: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 3311: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

3307: from hz_parties p, hz_relationships rel
3308: where rel.object_id = p.party_id
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

Line 3312: and rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

3308: where rel.object_id = p.party_id
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)

Line 3398: from as_accesses_all a, hz_parties p,hz_relationships rel

3394:
3395: cursor resource_access_csr is
3396:
3397: select 'X'
3398: from as_accesses_all a, hz_parties p,hz_relationships rel
3399: where a.customer_id = rel.object_id
3400: and rel.object_id = p.party_id
3401: and p.party_type in ('ORGANIZATION','PERSON')
3402: and rel.subject_id = p_customer_id

Line 3407: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

3403: and a.salesforce_id = p_identity_salesforce_id
3404: and a.lead_id is null
3405: and a.sales_lead_id is null
3406: and a.team_leader_flag = 'Y'
3407: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3408: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3409: and rownum = 1;
3410:
3411: cursor manager_access_csr(p_resource_id number) is

Line 3408: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

3404: and a.lead_id is null
3405: and a.sales_lead_id is null
3406: and a.team_leader_flag = 'Y'
3407: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3408: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3409: and rownum = 1;
3410:
3411: cursor manager_access_csr(p_resource_id number) is
3412: select 'X'

Line 3414: hz_parties p, hz_relationships rel

3410:
3411: cursor manager_access_csr(p_resource_id number) is
3412: select 'X'
3413: from as_accesses_all a,
3414: hz_parties p, hz_relationships rel
3415: where a.customer_id = rel.object_id
3416: and rel.object_id = p.party_id
3417: and p.party_type in ('ORGANIZATION','PERSON')
3418: and rel.subject_id = p_customer_id

Line 3421: and rel.subject_table_name = 'HZ_PARTIES'

3417: and p.party_type in ('ORGANIZATION','PERSON')
3418: and rel.subject_id = p_customer_id
3419: and a.lead_id is null
3420: and a.sales_lead_id is null
3421: and rel.subject_table_name = 'HZ_PARTIES'
3422: and rel.object_table_name = 'HZ_PARTIES'
3423: and (EXISTS (select 'X'
3424: from as_rpt_managers_v rm
3425: where a.salesforce_id = rm.resource_id

Line 3422: and rel.object_table_name = 'HZ_PARTIES'

3418: and rel.subject_id = p_customer_id
3419: and a.lead_id is null
3420: and a.sales_lead_id is null
3421: and rel.subject_table_name = 'HZ_PARTIES'
3422: and rel.object_table_name = 'HZ_PARTIES'
3423: and (EXISTS (select 'X'
3424: from as_rpt_managers_v rm
3425: where a.salesforce_id = rm.resource_id
3426: and rm.parent_resource_id = p_resource_id

Line 3433: from as_accesses_all a, hz_parties p, hz_relationships rel

3429: or (rm.parent_resource_id <> rm.resource_id))));
3430:
3431: cursor mgr_i_access_csr(p_resource_id number) is
3432: select 'X'
3433: from as_accesses_all a, hz_parties p, hz_relationships rel
3434: where a.customer_id = rel.object_id
3435: and rel.object_id = p.party_id
3436: and p.party_type in ('ORGANIZATION','PERSON')
3437: and rel.subject_id = p_customer_id

Line 3448: from as_accesses_all a, hz_parties p, hz_relationships rel

3444: and rm.parent_resource_id = p_resource_id));
3445:
3446: cursor admin_access_csr is
3447: select 'X'
3448: from as_accesses_all a, hz_parties p, hz_relationships rel
3449: where a.customer_id = rel.object_id
3450: and rel.object_id = p.party_id
3451: and p.party_type in ('ORGANIZATION','PERSON')
3452: and rel.subject_id = p_customer_id

Line 3455: and rel.object_table_name = 'HZ_PARTIES'

3451: and p.party_type in ('ORGANIZATION','PERSON')
3452: and rel.subject_id = p_customer_id
3453: and a.lead_id is null
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

Line 3456: and rel.subject_table_name = 'HZ_PARTIES'

3452: and rel.subject_id = p_customer_id
3453: and a.lead_id is null
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

Line 3467: from as_accesses_all a, hz_parties p, hz_relationships rel

3463: or (rm.salesforce_id <> p_identity_salesforce_id)));
3464:
3465: cursor admin_i_access_csr is
3466: select 'x'
3467: from as_accesses_all a, hz_parties p, hz_relationships rel
3468: where a.customer_id = rel.object_id
3469: and rel.object_id = p.party_id
3470: and p.party_type in ('ORGANIZATION', 'PERSON')
3471: and rel.subject_id = p_customer_id

Line 3475: and rel.object_table_name = 'HZ_PARTIES'

3471: and rel.subject_id = p_customer_id
3472: and a.lead_id is null
3473: and a.sales_lead_id is null
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

Line 3476: and rel.subject_table_name = 'HZ_PARTIES'

3472: and a.lead_id is null
3473: and a.sales_lead_id is null
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);