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 BOM_DEPARTMENTS

Line 188: AND NOT EXISTS (select 1 from bom_departments bd

184: error_code = 'CST_INVALID_DEPTS',
185: error_explanation = substrb(fnd_message.get_string('BOM','CST_INVALID_DEPTS'),1,240)
186: WHERE cdoi.error_flag is null
187: AND cdoi.group_id = SEQ_NEXTVAL
188: AND NOT EXISTS (select 1 from bom_departments bd
189: WHERE NVL(cdoi.department_id,bd.department_id)=bd.department_id
190: AND NVL(cdoi.department_code,bd.department_code)=bd.department_code
191: AND cdoi.organization_id = bd.organization_id
192: );

Line 200: set cdoi.department_id = (select bd.department_id from bom_departments bd

196:
197: /* Get the department_id from the department_code */
198:
199: Update CST_DEPT_OVERHEADS_INTERFACE cdoi
200: set cdoi.department_id = (select bd.department_id from bom_departments bd
201: WHERE cdoi.department_code = bd.department_code
202: AND bd.organization_id = cdoi.organization_id
203: )
204: Where cdoi.error_flag is null