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 2203: from hz_parties p

2199:
2200: CURSOR c_customer_fullname IS
2201: select
2202: p.party_name person_name
2203: from hz_parties p
2204: where
2205: p.party_id = p_user_id;
2206:
2207: l_proc VARCHAR2(72) := g_package|| 'get_user_fullname';

Line 2274: HZ_PARTIES PARTY,

2270: SUBSTRB( PARTY.PERSON_FIRST_NAME,1,40) || ' ' ||
2271: HR_GENERAL.DECODE_AR_LOOKUP('CONTACT_TITLE',nvl(PARTY.PERSON_PRE_NAME_ADJUNCT,PARTY.PERSON_TITLE)) LEARNER_NAME
2272: FROM
2273: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
2274: HZ_PARTIES PARTY,
2275: HZ_RELATIONSHIPS REL,
2276: HZ_CUST_ACCOUNTS ROLE_ACCT
2277: WHERE
2278: ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 2281: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2277: WHERE
2278: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
2279: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
2280: AND REL.SUBJECT_ID = PARTY.PARTY_ID
2281: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2282: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2283: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
2284: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
2285: AND ACCT_ROLE.CUST_ACCOUNT_ID = l_customer_id

Line 2282: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2278: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
2279: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
2280: AND REL.SUBJECT_ID = PARTY.PARTY_ID
2281: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2282: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2283: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
2284: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
2285: AND ACCT_ROLE.CUST_ACCOUNT_ID = l_customer_id
2286: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id;

Line 2330: HZ_PARTIES party,

2326:
2327: CURSOR c_customer_id IS
2328: select ACCT_ROLE.cust_account_id CUSTOMER_ID
2329: from HZ_CUST_ACCOUNT_ROLES acct_role,
2330: HZ_PARTIES party,
2331: HZ_RELATIONSHIPS rel,
2332: HZ_ORG_CONTACTS org_cont,
2333: HZ_PARTIES rel_party,
2334: HZ_CUST_ACCOUNTS role_acct

Line 2333: HZ_PARTIES rel_party,

2329: from HZ_CUST_ACCOUNT_ROLES acct_role,
2330: HZ_PARTIES party,
2331: HZ_RELATIONSHIPS rel,
2332: HZ_ORG_CONTACTS org_cont,
2333: HZ_PARTIES rel_party,
2334: HZ_CUST_ACCOUNTS role_acct
2335: where acct_role.party_id = rel.party_id
2336: and acct_role.role_type = 'CONTACT'
2337: and org_cont.party_relationship_id = rel.relationship_id

Line 2340: and rel.subject_table_name = 'HZ_PARTIES'

2336: and acct_role.role_type = 'CONTACT'
2337: and org_cont.party_relationship_id = rel.relationship_id
2338: and rel.subject_id = party.party_id
2339: and rel.party_id = rel_party.party_id
2340: and rel.subject_table_name = 'HZ_PARTIES'
2341: and rel.object_table_name = 'HZ_PARTIES'
2342: and acct_role.cust_account_id = role_acct.cust_account_id
2343: and role_acct.party_id = rel.object_id
2344: and ACCT_ROLE.cust_account_role_id = p_contact_id;

Line 2341: and rel.object_table_name = 'HZ_PARTIES'

2337: and org_cont.party_relationship_id = rel.relationship_id
2338: and rel.subject_id = party.party_id
2339: and rel.party_id = rel_party.party_id
2340: and rel.subject_table_name = 'HZ_PARTIES'
2341: and rel.object_table_name = 'HZ_PARTIES'
2342: and acct_role.cust_account_id = role_acct.cust_account_id
2343: and role_acct.party_id = rel.object_id
2344: and ACCT_ROLE.cust_account_role_id = p_contact_id;
2345:

Line 2371: from hz_parties party

2367: where language = userenv('LANG') and organization_id = p_organization_id;
2368:
2369: CURSOR c_customer_name(l_customer_id IN ota_delegate_bookings.customer_id%TYPE) IS
2370: select substrb(party.party_name,1,50)
2371: from hz_parties party
2372: ,hz_cust_accounts cust_acct
2373: where
2374: cust_acct.party_id = party.party_id
2375: and cust_acct.cust_account_id = l_customer_id;

Line 2686: HZ_PARTIES party,

2682:
2683: Cursor get_ext_lrn_party_id is
2684: select party.party_id
2685: from HZ_CUST_ACCOUNT_ROLES acct_role,
2686: HZ_PARTIES party,
2687: HZ_RELATIONSHIPS rel,
2688: HZ_ORG_CONTACTS org_cont,
2689: HZ_PARTIES rel_party,
2690: HZ_CUST_ACCOUNTS role_acct

Line 2689: HZ_PARTIES rel_party,

2685: from HZ_CUST_ACCOUNT_ROLES acct_role,
2686: HZ_PARTIES party,
2687: HZ_RELATIONSHIPS rel,
2688: HZ_ORG_CONTACTS org_cont,
2689: HZ_PARTIES rel_party,
2690: HZ_CUST_ACCOUNTS role_acct
2691: where acct_role.party_id = rel.party_id
2692: and acct_role.role_type = 'CONTACT'
2693: and org_cont.party_relationship_id = rel.relationship_id

Line 2696: and rel.subject_table_name = 'HZ_PARTIES'

2692: and acct_role.role_type = 'CONTACT'
2693: and org_cont.party_relationship_id = rel.relationship_id
2694: and rel.subject_id = party.party_id
2695: and rel.party_id = rel_party.party_id
2696: and rel.subject_table_name = 'HZ_PARTIES'
2697: and rel.object_table_name = 'HZ_PARTIES'
2698: and acct_role.cust_account_id = role_acct.cust_account_id
2699: and role_acct.party_id = rel.object_id
2700: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;

Line 2697: and rel.object_table_name = 'HZ_PARTIES'

2693: and org_cont.party_relationship_id = rel.relationship_id
2694: and rel.subject_id = party.party_id
2695: and rel.party_id = rel_party.party_id
2696: and rel.subject_table_name = 'HZ_PARTIES'
2697: and rel.object_table_name = 'HZ_PARTIES'
2698: and acct_role.cust_account_id = role_acct.cust_account_id
2699: and role_acct.party_id = rel.object_id
2700: and ACCT_ROLE.cust_account_role_id = p_delegate_contact_id;
2701: