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

Line 2271: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V.

2267: hzr.party_id
2268: --NPALEPU
2269: --18-JUN-2005,09-AUG-2005
2270: --TCA Project
2271: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V.
2272: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
2273: /* FROM ra_hcontacts rah, hz_party_relationships hzr
2274: WHERE rah.contact_id = p_contact_id
2275: AND rah.party_relationship_id = hzr.party_relationship_id;*/

Line 2276: FROM oks_ra_hcontacts_v rah, hz_relationships hzr

2272: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
2273: /* FROM ra_hcontacts rah, hz_party_relationships hzr
2274: WHERE rah.contact_id = p_contact_id
2275: AND rah.party_relationship_id = hzr.party_relationship_id;*/
2276: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
2277: WHERE rah.contact_id = p_contact_id
2278: AND rah.party_relationship_id = hzr.relationship_id
2279: AND hzr.subject_table_name = 'HZ_PARTIES'
2280: AND hzr.object_table_name = 'HZ_PARTIES'

Line 2327: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V.

2323: SELECT hzr.party_id
2324: --NPALEPU
2325: --18-JUN-2005,09-AUG-2005
2326: --TCA Project
2327: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V.
2328: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
2329: /* FROM ra_hcontacts rah,
2330: hz_party_relationships hzr
2331: WHERE rah.contact_id = p_contact_id

Line 2333: FROM oks_ra_hcontacts_v rah, hz_relationships hzr

2329: /* FROM ra_hcontacts rah,
2330: hz_party_relationships hzr
2331: WHERE rah.contact_id = p_contact_id
2332: AND rah.party_relationship_id = hzr.party_relationship_id;*/
2333: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
2334: WHERE rah.contact_id = p_contact_id
2335: AND rah.party_relationship_id = hzr.relationship_id
2336: AND hzr.subject_table_name = 'HZ_PARTIES'
2337: AND hzr.object_table_name = 'HZ_PARTIES'

Line 3876: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V.

3872: SELECT hzr.object_id, hzr.party_id
3873: --NPALEPU
3874: --18-JUN-2005,09-AUG-2005
3875: --TCA Project
3876: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V.
3877: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
3878: /* FROM ra_hcontacts rah, hz_party_relationships hzr
3879: WHERE rah.contact_id = p_contact_id
3880: AND rah.party_relationship_id = hzr.party_relationship_id; */

Line 3881: FROM oks_ra_hcontacts_v rah, hz_relationships hzr

3877: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
3878: /* FROM ra_hcontacts rah, hz_party_relationships hzr
3879: WHERE rah.contact_id = p_contact_id
3880: AND rah.party_relationship_id = hzr.party_relationship_id; */
3881: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
3882: WHERE rah.contact_id = p_contact_id
3883: AND rah.party_relationship_id = hzr.relationship_id
3884: AND hzr.subject_table_name = 'HZ_PARTIES'
3885: AND hzr.object_table_name = 'HZ_PARTIES'

Line 9496: FROM hz_relationships

9492: p_transfer_date DATE
9493: )
9494: IS
9495: SELECT DISTINCT relationship_type
9496: FROM hz_relationships
9497: WHERE ( ( object_id = p_new_customer
9498: AND subject_id = p_old_customer
9499: )
9500: OR ( object_id = p_old_customer