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.AS_VALIDATE_SETUP dependencies on AS_CONTACT_FAMILY

Line 264: FROM AS_CONTACT_FAMILY cf

260: Write_Log(l_module, ' ');
261: Write_Log(l_module, '**** Checking the setup for TCA/Resource module ****');
262: BEGIN
263: SELECT count(*) INTO l_count
264: FROM AS_CONTACT_FAMILY cf
265: WHERE not exists
266: ( select aslkp.lookup_code
267: , arlkp.lookup_code
268: from AS_LOOKUPS aslkp

Line 270: ,AS_CONTACT_FAMILY acf

266: ( select aslkp.lookup_code
267: , arlkp.lookup_code
268: from AS_LOOKUPS aslkp
269: ,AR_LOOKUPS arlkp
270: ,AS_CONTACT_FAMILY acf
271: where aslkp.lookup_type = 'CONTACT_RELATION'
272: and upper(ltrim(rtrim(aslkp.meaning))) =
273: upper(ltrim(rtrim(acf.relation)))
274: and arlkp.lookup_type = 'PARTY_RELATIONS_TYPE'

Line 289: Write_Log(l_module, 'Success: no invalid Contact Relation in AS_CONTACT_FAMILY');

285: Write_Log(l_module, 'Error('||to_char(l_err_total)
286: ||'): Contact Relation is not set in TCA');
287: ELSE
288: Write_Log(l_module, ' ');
289: Write_Log(l_module, 'Success: no invalid Contact Relation in AS_CONTACT_FAMILY');
290: END IF;
291:
292: BEGIN
293: SELECT count(*) INTO l_count FROM RA_SALESREPS_ALL rrep