APPS.OKS_EXTWARPRGM_OSO_PVT dependencies on HZ_RELATIONSHIPS

Line 1123: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts with OKS_RA_HCONTACTS_V

1119: , hzr.party_id
1120: --NPALEPU
1121: --18-JUN-2005,08-AUG-2005
1122: --TCA Project
1123: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts with OKS_RA_HCONTACTS_V
1124: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
1125: /* From
1126: ra_hcontacts rah,
1127: hz_party_relationships hzr

Line 1132: hz_relationships hzr

1128: Where rah.contact_id = p_contact_id
1129: and rah.party_relationship_id = hzr.party_relationship_id;*/
1130: From
1131: OKS_RA_HCONTACTS_V rah,
1132: hz_relationships hzr
1133: Where rah.contact_id = p_contact_id
1134: and rah.party_relationship_id = hzr.relationship_id
1135: AND hzr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1136: AND hzr.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

2185: , hzr.party_id
2186: --NPALEPU
2187: --18-JUN-2005
2188: --TCA Project
2189: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V
2190: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
2191: /* From
2192: ra_hcontacts rah,
2193: hz_party_relationships hzr

Line 2197: hz_relationships hzr

2193: hz_party_relationships hzr
2194: Where rah.contact_id = p_contact_id
2195: and rah.party_relationship_id = hzr.party_relationship_id;*/
2196: From OKS_RA_HCONTACTS_V rah,
2197: hz_relationships hzr
2198: WHERE rah.contact_id = p_contact_id
2199: and rah.party_relationship_id = hzr.relationship_id
2200: AND hzr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2201: AND hzr.OBJECT_TABLE_NAME = 'HZ_PARTIES'