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

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

1096: SELECT hzr.object_id, hzr.party_id
1097: --NPALEPU
1098: --18-JUN-2005,08-AUG-2005
1099: --TCA Project
1100: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V.
1101: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
1102: /* FROM ra_hcontacts rah,hz_party_relationships hzr
1103: WHERE rah.contact_id = p_contact_id
1104: AND rah.party_relationship_id = hzr.party_relationship_id; */

Line 1105: FROM OKS_RA_HCONTACTS_V rah,hz_relationships hzr

1101: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
1102: /* FROM ra_hcontacts rah,hz_party_relationships hzr
1103: WHERE rah.contact_id = p_contact_id
1104: AND rah.party_relationship_id = hzr.party_relationship_id; */
1105: FROM OKS_RA_HCONTACTS_V rah,hz_relationships hzr
1106: WHERE rah.contact_id = p_contact_id
1107: AND rah.party_relationship_id = hzr.relationship_id
1108: AND hzr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1109: AND hzr.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

3449: Select hzr.object_id, hzr.party_id
3450: --NPALEPU
3451: --18-JUN-2005,08-AUG-2005
3452: --TCA Project
3453: --Replaced hz_party_relationships table with hz_relationships table and ra_hcontacts view with OKS_RA_HCONTACTS_V
3454: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
3455: /* From ra_hcontacts rah, hz_party_relationships hzr
3456: Where rah.contact_id = p_contact_id
3457: And rah.party_relationship_id = hzr.party_relationship_id; */

Line 3458: From OKS_RA_HCONTACTS_V rah, hz_relationships hzr

3454: --Replaced hzr.party_relationship_id column with hzr.relationship_id column and added new conditions
3455: /* From ra_hcontacts rah, hz_party_relationships hzr
3456: Where rah.contact_id = p_contact_id
3457: And rah.party_relationship_id = hzr.party_relationship_id; */
3458: From OKS_RA_HCONTACTS_V rah, hz_relationships hzr
3459: Where rah.contact_id = p_contact_id
3460: And rah.party_relationship_id = hzr.relationship_id
3461: AND hzr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
3462: AND hzr.OBJECT_TABLE_NAME = 'HZ_PARTIES'