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 3241: from hz_parties

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

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

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

Line 3283: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 3284: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 3292: hz_parties p,hz_relationships rel

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

Line 3299: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 3300: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 3306: from hz_parties p, hz_relationships rel

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

Line 3310: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 3311: and rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

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

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

Line 3406: and rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 3407: AND rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

Line 3413: hz_parties p, hz_relationships rel

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

Line 3420: and rel.subject_table_name = 'HZ_PARTIES'

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

Line 3421: and rel.object_table_name = 'HZ_PARTIES'

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

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

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

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

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

Line 3454: and rel.object_table_name = 'HZ_PARTIES'

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

Line 3455: and rel.subject_table_name = 'HZ_PARTIES'

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

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

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

Line 3474: and rel.object_table_name = 'HZ_PARTIES'

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

Line 3475: and rel.subject_table_name = 'HZ_PARTIES'

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