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 2231: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V.

2227: hzr.party_id
2228: --NPALEPU
2229: --18-JUN-2005,09-AUG-2005
2230: --TCA Project
2231: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V.
2232: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
2233: /* FROM ra_hcontacts rah, hz_party_relationships hzr
2234: WHERE rah.contact_id = p_contact_id
2235: AND rah.party_relationship_id = hzr.party_relationship_id;*/

Line 2236: FROM oks_ra_hcontacts_v rah, hz_relationships hzr

2232: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
2233: /* FROM ra_hcontacts rah, hz_party_relationships hzr
2234: WHERE rah.contact_id = p_contact_id
2235: AND rah.party_relationship_id = hzr.party_relationship_id;*/
2236: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
2237: WHERE rah.contact_id = p_contact_id
2238: AND rah.party_relationship_id = hzr.relationship_id
2239: AND hzr.subject_table_name = 'HZ_PARTIES'
2240: AND hzr.object_table_name = 'HZ_PARTIES'

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

2274: SELECT hzr.party_id
2275: --NPALEPU
2276: --18-JUN-2005,09-AUG-2005
2277: --TCA Project
2278: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V.
2279: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
2280: /* FROM ra_hcontacts rah,
2281: hz_party_relationships hzr
2282: WHERE rah.contact_id = p_contact_id

Line 2284: FROM oks_ra_hcontacts_v rah, hz_relationships hzr

2280: /* FROM ra_hcontacts rah,
2281: hz_party_relationships hzr
2282: WHERE rah.contact_id = p_contact_id
2283: AND rah.party_relationship_id = hzr.party_relationship_id;*/
2284: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
2285: WHERE rah.contact_id = p_contact_id
2286: AND rah.party_relationship_id = hzr.relationship_id
2287: AND hzr.subject_table_name = 'HZ_PARTIES'
2288: AND hzr.object_table_name = 'HZ_PARTIES'

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

3801: SELECT hzr.object_id, hzr.party_id
3802: --NPALEPU
3803: --18-JUN-2005,09-AUG-2005
3804: --TCA Project
3805: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V.
3806: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
3807: /* FROM ra_hcontacts rah, hz_party_relationships hzr
3808: WHERE rah.contact_id = p_contact_id
3809: AND rah.party_relationship_id = hzr.party_relationship_id; */

Line 3810: FROM oks_ra_hcontacts_v rah, hz_relationships hzr

3806: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
3807: /* FROM ra_hcontacts rah, hz_party_relationships hzr
3808: WHERE rah.contact_id = p_contact_id
3809: AND rah.party_relationship_id = hzr.party_relationship_id; */
3810: FROM oks_ra_hcontacts_v rah, hz_relationships hzr
3811: WHERE rah.contact_id = p_contact_id
3812: AND rah.party_relationship_id = hzr.relationship_id
3813: AND hzr.subject_table_name = 'HZ_PARTIES'
3814: AND hzr.object_table_name = 'HZ_PARTIES'

Line 9265: FROM hz_relationships

9261: p_transfer_date DATE
9262: )
9263: IS
9264: SELECT DISTINCT relationship_type
9265: FROM hz_relationships
9266: WHERE ( ( object_id = p_new_customer
9267: AND subject_id = p_old_customer
9268: )
9269: OR ( object_id = p_old_customer