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.OTA_UTILITY dependencies on HZ_PARTIES

Line 2267: from hz_parties p

2263:
2264: CURSOR c_customer_fullname IS
2265: select
2266: p.party_name person_name
2267: from hz_parties p
2268: where
2269: p.party_id = p_user_id;
2270:
2271: l_proc VARCHAR2(72) := g_package|| 'get_user_fullname';

Line 2338: HZ_PARTIES PARTY,

2334: SUBSTRB( PARTY.PERSON_FIRST_NAME,1,40) || ' ' ||
2335: HR_GENERAL.DECODE_AR_LOOKUP('CONTACT_TITLE',nvl(PARTY.PERSON_PRE_NAME_ADJUNCT,PARTY.PERSON_TITLE)) LEARNER_NAME
2336: FROM
2337: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2338: HZ_PARTIES PARTY,
2339: HZ_RELATIONSHIPS REL,
2340: HZ_CUST_ACCOUNTS ROLE_ACCT
2341: WHERE
2342: ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 2345: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2341: WHERE
2342: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
2343: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
2344: AND REL.SUBJECT_ID = PARTY.PARTY_ID
2345: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2346: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2347: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
2348: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
2349: AND ACCT_ROLE.CUST_ACCOUNT_ID = l_customer_id

Line 2346: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2342: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
2343: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
2344: AND REL.SUBJECT_ID = PARTY.PARTY_ID
2345: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2346: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2347: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
2348: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
2349: AND ACCT_ROLE.CUST_ACCOUNT_ID = l_customer_id
2350: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id;

Line 2394: HZ_PARTIES party,

2390:
2391: CURSOR c_customer_id IS
2392: select ACCT_ROLE.cust_account_id CUSTOMER_ID
2393: from HZ_CUST_ACCOUNT_ROLES acct_role,
2394: HZ_PARTIES party,
2395: HZ_RELATIONSHIPS rel,
2396: HZ_ORG_CONTACTS org_cont,
2397: HZ_PARTIES rel_party,
2398: HZ_CUST_ACCOUNTS role_acct

Line 2397: HZ_PARTIES rel_party,

2393: from HZ_CUST_ACCOUNT_ROLES acct_role,
2394: HZ_PARTIES party,
2395: HZ_RELATIONSHIPS rel,
2396: HZ_ORG_CONTACTS org_cont,
2397: HZ_PARTIES rel_party,
2398: HZ_CUST_ACCOUNTS role_acct
2399: where acct_role.party_id = rel.party_id
2400: and acct_role.role_type = 'CONTACT'
2401: and org_cont.party_relationship_id = rel.relationship_id

Line 2404: and rel.subject_table_name = 'HZ_PARTIES'

2400: and acct_role.role_type = 'CONTACT'
2401: and org_cont.party_relationship_id = rel.relationship_id
2402: and rel.subject_id = party.party_id
2403: and rel.party_id = rel_party.party_id
2404: and rel.subject_table_name = 'HZ_PARTIES'
2405: and rel.object_table_name = 'HZ_PARTIES'
2406: and acct_role.cust_account_id = role_acct.cust_account_id
2407: and role_acct.party_id = rel.object_id
2408: and ACCT_ROLE.cust_account_role_id = p_contact_id;

Line 2405: and rel.object_table_name = 'HZ_PARTIES'

2401: and org_cont.party_relationship_id = rel.relationship_id
2402: and rel.subject_id = party.party_id
2403: and rel.party_id = rel_party.party_id
2404: and rel.subject_table_name = 'HZ_PARTIES'
2405: and rel.object_table_name = 'HZ_PARTIES'
2406: and acct_role.cust_account_id = role_acct.cust_account_id
2407: and role_acct.party_id = rel.object_id
2408: and ACCT_ROLE.cust_account_role_id = p_contact_id;
2409:

Line 2435: from hz_parties party

2431: where language = userenv('LANG') and organization_id = p_organization_id;
2432:
2433: CURSOR c_customer_name(l_customer_id IN ota_delegate_bookings.customer_id%TYPE) IS
2434: select substrb(party.party_name,1,50)
2435: from hz_parties party
2436: ,hz_cust_accounts cust_acct
2437: where
2438: cust_acct.party_id = party.party_id
2439: and cust_acct.cust_account_id = l_customer_id;

Line 2750: HZ_PARTIES party,

2746:
2747: Cursor get_ext_lrn_party_id is
2748: select party.party_id
2749: from HZ_CUST_ACCOUNT_ROLES acct_role,
2750: HZ_PARTIES party,
2751: HZ_RELATIONSHIPS rel,
2752: HZ_ORG_CONTACTS org_cont,
2753: HZ_PARTIES rel_party,
2754: HZ_CUST_ACCOUNTS role_acct

Line 2753: HZ_PARTIES rel_party,

2749: from HZ_CUST_ACCOUNT_ROLES acct_role,
2750: HZ_PARTIES party,
2751: HZ_RELATIONSHIPS rel,
2752: HZ_ORG_CONTACTS org_cont,
2753: HZ_PARTIES rel_party,
2754: HZ_CUST_ACCOUNTS role_acct
2755: where acct_role.party_id = rel.party_id
2756: and acct_role.role_type = 'CONTACT'
2757: and org_cont.party_relationship_id = rel.relationship_id

Line 2760: and rel.subject_table_name = 'HZ_PARTIES'

2756: and acct_role.role_type = 'CONTACT'
2757: and org_cont.party_relationship_id = rel.relationship_id
2758: and rel.subject_id = party.party_id
2759: and rel.party_id = rel_party.party_id
2760: and rel.subject_table_name = 'HZ_PARTIES'
2761: and rel.object_table_name = 'HZ_PARTIES'
2762: and acct_role.cust_account_id = role_acct.cust_account_id
2763: and role_acct.party_id = rel.object_id
2764: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;

Line 2761: and rel.object_table_name = 'HZ_PARTIES'

2757: and org_cont.party_relationship_id = rel.relationship_id
2758: and rel.subject_id = party.party_id
2759: and rel.party_id = rel_party.party_id
2760: and rel.subject_table_name = 'HZ_PARTIES'
2761: and rel.object_table_name = 'HZ_PARTIES'
2762: and acct_role.cust_account_id = role_acct.cust_account_id
2763: and role_acct.party_id = rel.object_id
2764: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;
2765:

Line 3550: HZ_PARTIES PARTY,

3546:
3547: cursor get_external_email_addresses is
3548: SELECT PARTY.EMAIL_ADDRESS
3549: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
3550: HZ_PARTIES PARTY,
3551: HZ_RELATIONSHIPS REL,
3552: HZ_CUST_ACCOUNTS ROLE_ACCT,
3553: HZ_ROLE_RESPONSIBILITY ROL ,
3554: HZ_ORG_CONTACTS ORG_CONT,

Line 3564: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

3560: WHERE
3561: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3562: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3563: AND REL.SUBJECT_ID = PARTY.PARTY_ID
3564: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3565: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3566: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
3567: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
3568: AND ROL.PRIMARY_FLAG (+) = 'Y'

Line 3565: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

3561: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3562: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
3563: AND REL.SUBJECT_ID = PARTY.PARTY_ID
3564: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3565: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
3566: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
3567: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
3568: AND ROL.PRIMARY_FLAG (+) = 'Y'
3569: AND ROL.CUST_ACCOUNT_ROLE_ID (+) = ACCT_ROLE.CUST_ACCOUNT_ROLE_ID