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.CST_OVHD_RATE_IMPORT_INTERFACE dependencies on CST_ACTIVITIES

Line 292: AND NOT EXISTS(select 1 from cst_activities ca where

288: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_ACTIVITY'),1,240)
289: where group_id = SEQ_NEXTVAL
290: AND (cdoi.activity_id is not null OR cdoi.activity is not null)
291: AND error_flag is null
292: AND NOT EXISTS(select 1 from cst_activities ca where
293: NVL(cdoi.activity_id,ca.activity_id) = ca.activity_id
294: AND NVL(cdoi.activity,ca.activity) = ca.activity
295: AND cdoi.organization_id = NVL(ca.organization_id,cdoi.organization_id)
296: AND NVL(ca.disable_date,sysdate + 1) > sysdate

Line 300: cdoi.activity_id = (select ca.activity_id from cst_activities ca

296: AND NVL(ca.disable_date,sysdate + 1) > sysdate
297: );
298:
299: Update CST_DEPT_OVERHEADS_INTERFACE cdoi set
300: cdoi.activity_id = (select ca.activity_id from cst_activities ca
301: where ca.activity = cdoi.activity
302: AND NVL(ca.organization_id,cdoi.organization_id) = cdoi.organization_id
303: )
304: where cdoi.activity_id is null