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.AMS_PARTY_MKT_SEG_LOADER_PVT dependencies on FND_PROFILE

Line 3026: WHERE relationship_code = fnd_profile.VALUE('AMS_PARTY_RELATIONS_TYPE')

3022:
3023: CURSOR c_get_object_ids IS
3024: SELECT subject_id
3025: FROM hz_relationships
3026: WHERE relationship_code = fnd_profile.VALUE('AMS_PARTY_RELATIONS_TYPE')
3027: AND subject_type = 'ORGANIZATION'
3028: AND subject_table_name = 'HZ_PARTIES'
3029: AND object_type = 'ORGANIZATION'
3030: AND object_table_name = 'HZ_PARTIES'

Line 3356: l_rel_profile := fnd_profile.VALUE('AMS_PARTY_RELATIONS_TYPE');

3352: retcode := 0;
3353:
3354: /* yzhao: 08/07/2002 fix bug 2503141 performance issue. Use index on relationship_type */
3355: l_direction_code := NULL;
3356: l_rel_profile := fnd_profile.VALUE('AMS_PARTY_RELATIONS_TYPE');
3357: OPEN c_get_relationship_type(l_rel_profile);
3358: FETCH c_get_relationship_type INTO l_rel_type, l_direction_code;
3359: CLOSE c_get_relationship_type;
3360: