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

Line 2768: FROM HZ_PARTIES per,

2764: XLE_CONTACT_GRP.concat_contact_roles
2765: (rel.subject_id,
2766: rel.object_id),
2767: hzpp.person_pre_name_adjunct -- title
2768: FROM HZ_PARTIES per,
2769: xle_entity_profiles xep,
2770: HZ_RELATIONSHIPS rel,
2771: hz_person_profiles hzpp,
2772: HZ_ORG_CONTACTS con

Line 2779: AND rel.subject_table_name = 'HZ_PARTIES'

2775: AND rel.object_id = xep.party_id
2776: AND per.party_id = hzpp.party_id
2777: AND rel.relationship_type = 'CONTACT'
2778: AND rel.directional_flag = 'F'
2779: AND rel.subject_table_name = 'HZ_PARTIES'
2780: AND rel.subject_type = 'PERSON'
2781: AND rel.subject_id = per.party_id
2782: -- AND rel.subject_id = rol.contact_party_id
2783: -- AND rel.object_id = rol.le_etb_party_id

Line 2784: AND rel.object_table_name = 'HZ_PARTIES'

2780: AND rel.subject_type = 'PERSON'
2781: AND rel.subject_id = per.party_id
2782: -- AND rel.subject_id = rol.contact_party_id
2783: -- AND rel.object_id = rol.le_etb_party_id
2784: AND rel.object_table_name = 'HZ_PARTIES'
2785: AND Trunc(Nvl(rel.end_date, SYSDATE)) > TRUNC(SYSDATE)
2786: AND rel.relationship_id = con.party_relationship_id
2787: AND xep.legal_entity_id = c_rep_entity_id
2788: UNION

Line 2796: FROM HZ_PARTIES per,

2792: XLE_CONTACT_GRP.concat_contact_roles
2793: (rel.subject_id,
2794: rel.object_id),
2795: hzpp.person_pre_name_adjunct --title,
2796: FROM HZ_PARTIES per,
2797: xle_etb_profiles etb,
2798: HZ_RELATIONSHIPS rel,
2799: hz_person_profiles hzpp,
2800: HZ_ORG_CONTACTS con

Line 2807: AND rel.subject_table_name = 'HZ_PARTIES'

2803: AND rel.object_id = etb.party_id
2804: AND per.party_id = hzpp.party_id
2805: AND rel.relationship_type = 'CONTACT'
2806: AND rel.directional_flag = 'F'
2807: AND rel.subject_table_name = 'HZ_PARTIES'
2808: AND rel.subject_type = 'PERSON'
2809: AND rel.subject_id = per.party_id
2810: --AND rel.subject_id = rol.contact_party_id
2811: --AND rel.object_id = rol.le_etb_party_id

Line 2812: AND rel.object_table_name = 'HZ_PARTIES'

2808: AND rel.subject_type = 'PERSON'
2809: AND rel.subject_id = per.party_id
2810: --AND rel.subject_id = rol.contact_party_id
2811: --AND rel.object_id = rol.le_etb_party_id
2812: AND rel.object_table_name = 'HZ_PARTIES'
2813: AND Trunc(Nvl(rel.end_date, SYSDATE)) > TRUNC(SYSDATE)
2814: AND rel.relationship_id = con.party_relationship_id
2815: AND etb.establishment_id = c_rep_entity_id ;
2816: