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_PTR_MEMBER_TYPE_PVT dependencies on HZ_RELATIONSHIPS

Line 63: FROM hz_relationships rel

59: IS
60:
61: cursor is_global_cur(p_ptr_id NUMBER) IS
62: SELECT 'Y'
63: FROM hz_relationships rel
64: , pv_partner_profiles prof
65: WHERE rel.status='A'
66: AND prof.partner_id=p_ptr_id
67: AND relationship_type = 'PARTNER_HIERARCHY'

Line 290: , hz_relationships rel

286: , rel.start_date
287: FROM pv_partner_profiles subs_prof
288: , pv_partner_profiles global_prof
289: , pv_enty_attr_values subs_enty_val
290: , hz_relationships rel
291: WHERE
292: global_prof.partner_id = p_ptr_id
293: AND global_prof.partner_party_id = rel.subject_id
294: AND rel.relationship_type = 'PARTNER_HIERARCHY'

Line 321: , hz_relationships rel

317: FROM pv_partner_profiles subs_prof
318: , pv_partner_profiles global_prof
319: , pv_enty_attr_values subs_enty_val
320: , pv_enty_attr_values global_enty_val
321: , hz_relationships rel
322: WHERE global_enty_val.entity = 'PARTNER'
323: AND global_enty_val.entity_id = global_prof.partner_id
324: AND global_enty_val.attribute_id = 6
325: AND global_enty_val.latest_flag = 'Y'

Line 349: , hz_relationships rel

345: , rel.start_date
346: , rel.object_version_number object_version_number
347: , subs_prof.partner_party_id partner_party_id
348: FROM pv_partner_profiles subs_prof
349: , hz_relationships rel
350: WHERE rel.subject_id=subs_prof.partner_party_id
351: AND rel.relationship_code = 'SUBSIDIARY_OF'
352: AND rel.relationship_type = 'PARTNER_HIERARCHY'
353: AND rel.status = 'A'

Line 369: , hz_relationships rel

365: , subs_prof.partner_party_id partner_party_id
366: , subs_enty_val.version version
367: FROM pv_partner_profiles subs_prof
368: , pv_enty_attr_values subs_enty_val
369: , hz_relationships rel
370: WHERE rel.subject_id=subs_prof.partner_party_id
371: AND rel.relationship_code = 'SUBSIDIARY_OF'
372: AND rel.relationship_type = 'PARTNER_HIERARCHY'
373: AND rel.status = 'A'

Line 1297: FROM hz_relationships

1293:
1294: CURSOR rel_status ( id NUMBER) IS
1295: SELECT status
1296: , subject_id
1297: FROM hz_relationships
1298: WHERE relationship_id= id;
1299:
1300: CURSOR c_get_partner_id ( rel_id NUMBER ) IS
1301: SELECT partner_id

Line 1304: , hz_relationships rel

1300: CURSOR c_get_partner_id ( rel_id NUMBER ) IS
1301: SELECT partner_id
1302:
1303: FROM pv_partner_profiles prof
1304: , hz_relationships rel
1305: , pv_enty_attr_values enty
1306: WHERE rel.relationship_id = rel_id
1307: AND rel.relationship_type= 'PARTNER_HIERARCHY'
1308: AND rel.relationship_code= 'SUBSIDIARY_OF'

Line 1321: , hz_relationships rel

1317: , gprof.partner_id global_partner_id
1318: , enty.attr_value attr_value
1319: FROM pv_partner_profiles sprof
1320: , pv_partner_profiles gprof
1321: , hz_relationships rel
1322: , pv_enty_attr_values enty
1323: WHERE rel.relationship_id = rel_id
1324: AND rel.relationship_type= 'PARTNER_HIERARCHY'
1325: AND rel.relationship_code= 'SUBSIDIARY_OF'

Line 1393: FROM HZ_RELATIONSHIPS

1389: );
1390: END IF;
1391: BEGIN
1392: SELECT 1 INTO l_count
1393: FROM HZ_RELATIONSHIPS
1394: WHERE SUBJECT_ID = l_subject_id -- subsidiary partner party id
1395: AND OBJECT_TABLE_NAME = 'HZ_PARTIES'
1396: AND OBJECT_TYPE = 'ORGANIZATION'
1397: AND RELATIONSHIP_TYPE = 'PARTNER_HIERARCHY'