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

Line 342: from hz_parties relation

338:
339: --bug#4145213
340: CURSOR getRelationId IS
341: select relation.party_id party_id
342: from hz_parties relation
343: ,hz_parties person
344: ,hz_relationships hz
345: where relation.party_id = hz.party_id
346: and person.party_id = hz.subject_id

Line 343: ,hz_parties person

339: --bug#4145213
340: CURSOR getRelationId IS
341: select relation.party_id party_id
342: from hz_parties relation
343: ,hz_parties person
344: ,hz_relationships hz
345: where relation.party_id = hz.party_id
346: and person.party_id = hz.subject_id
347: and hz.subject_type = 'PERSON'

Line 349: and hz.subject_table_name ='HZ_PARTIES'

345: where relation.party_id = hz.party_id
346: and person.party_id = hz.subject_id
347: and hz.subject_type = 'PERSON'
348: and hz.object_type = 'ORGANIZATION'
349: and hz.subject_table_name ='HZ_PARTIES'
350: and hz.object_table_name ='HZ_PARTIES'
351: and person.party_id = p_external_contact;
352:
353: CURSOR ext_user_email(x NUMBER) IS

Line 350: and hz.object_table_name ='HZ_PARTIES'

346: and person.party_id = hz.subject_id
347: and hz.subject_type = 'PERSON'
348: and hz.object_type = 'ORGANIZATION'
349: and hz.subject_table_name ='HZ_PARTIES'
350: and hz.object_table_name ='HZ_PARTIES'
351: and person.party_id = p_external_contact;
352:
353: CURSOR ext_user_email(x NUMBER) IS
354: SELECT hc.email_address

Line 356: WHERE hc.owner_table_name = 'HZ_PARTIES'

352:
353: CURSOR ext_user_email(x NUMBER) IS
354: SELECT hc.email_address
355: FROM hz_contact_points hc
356: WHERE hc.owner_table_name = 'HZ_PARTIES'
357: AND hc.primary_flag = 'Y'
358: AND hc.contact_point_type = 'EMAIL'
359: AND hc.owner_table_id = x;
360:

Line 363: from hz_parties

359: AND hc.owner_table_id = x;
360:
361: /*cursor ext_user_email is
362: select email_address
363: from hz_parties
364: where party_id=p_external_contact;*/
365:
366: l_int_role_display_name wf_roles.display_name%TYPE;
367: l_req_role_display_name wf_roles.display_name%TYPE;