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.PV_OPPORTUNITY_VHUK dependencies on HZ_RELATIONSHIPS

Line 580: from hz_relationships porg,

576:
577: cursor lc_get_vendor_org(pc_partner_id NUMBER)
578: is
579: select hp.party_name
580: from hz_relationships porg,
581: hz_parties hp,
582: hz_organization_profiles hzop,
583: pv_partner_profiles pvpp
584: where porg.party_id = pc_partner_id

Line 1748: hz_relationships PCONTACT,

1744:
1745: CURSOR lc_get_pt_ven_name(pc_party_id NUMBER) IS
1746: SELECT VENDOR.party_name
1747: FROM hz_parties VENDOR,
1748: hz_relationships PCONTACT,
1749: pv_partner_profiles PVPP
1750: WHERE PCONTACT.party_id = pc_party_id
1751: AND PCONTACT.subject_table_name = 'HZ_PARTIES'
1752: AND PCONTACT.object_table_name = 'HZ_PARTIES'

Line 2567: hz_relationships CONTACT,

2563: CURSOR lc_get_rel_type(pc_party_id number) is
2564: SELECT 'PARTNER_OF', PVPP.partner_id, PARTNER.party_name, peav.attr_value
2565: FROM
2566: hz_parties PARTNER,
2567: hz_relationships CONTACT,
2568: pv_partner_profiles PVPP,
2569: pv_enty_attr_values peav
2570: WHERE CONTACT.party_id = pc_party_id
2571: AND CONTACT.subject_table_name = 'HZ_PARTIES'