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_ADD_TRAINING_SS dependencies on HZ_PARTIES

Line 2178: HZ_PARTIES party,

2174: substrb( PARTY.person_last_name,1,50) || ',' ||
2175: substrb( PARTY.person_first_name,1,40) || ' ' ||
2176: party.person_pre_name_adjunct
2177: from HZ_CUST_ACCOUNT_ROLES acct_role,
2178: HZ_PARTIES party,
2179: HZ_RELATIONSHIPS rel,
2180: HZ_ORG_CONTACTS org_cont,
2181: HZ_PARTIES rel_party,
2182: HZ_CUST_ACCOUNTS role_acct

Line 2181: HZ_PARTIES rel_party,

2177: from HZ_CUST_ACCOUNT_ROLES acct_role,
2178: HZ_PARTIES party,
2179: HZ_RELATIONSHIPS rel,
2180: HZ_ORG_CONTACTS org_cont,
2181: HZ_PARTIES rel_party,
2182: HZ_CUST_ACCOUNTS role_acct
2183: where acct_role.party_id = rel.party_id
2184: and acct_role.role_type = 'CONTACT'
2185: and org_cont.party_relationship_id = rel.relationship_id

Line 2188: and rel.subject_table_name = 'HZ_PARTIES'

2184: and acct_role.role_type = 'CONTACT'
2185: and org_cont.party_relationship_id = rel.relationship_id
2186: and rel.subject_id = party.party_id
2187: and rel.party_id = rel_party.party_id
2188: and rel.subject_table_name = 'HZ_PARTIES'
2189: and rel.object_table_name = 'HZ_PARTIES'
2190: and acct_role.cust_account_id = role_acct.cust_account_id
2191: and role_acct.party_id = rel.object_id
2192: and acct_role.cust_account_role_id = p_person_id;

Line 2189: and rel.object_table_name = 'HZ_PARTIES'

2185: and org_cont.party_relationship_id = rel.relationship_id
2186: and rel.subject_id = party.party_id
2187: and rel.party_id = rel_party.party_id
2188: and rel.subject_table_name = 'HZ_PARTIES'
2189: and rel.object_table_name = 'HZ_PARTIES'
2190: and acct_role.cust_account_id = role_acct.cust_account_id
2191: and role_acct.party_id = rel.object_id
2192: and acct_role.cust_account_role_id = p_person_id;
2193:

Line 2238: HZ_PARTIES party,

2234: CURSOR c_get_customer_name IS
2235: SELECT
2236: substrb(PARTY.party_name,1,50)
2237: FROM
2238: HZ_PARTIES party,
2239: HZ_CUST_ACCOUNTS cust_acct
2240: WHERE
2241: CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
2242: AND CUST_ACCT.CUST_ACCOUNT_ID = p_customer_id;