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.CRP_FORM_PK dependencies on BOM_DEPARTMENTS

Line 134: bom_departments depts2,

130: resources.resource_type,
131: 2
132: FROM mtl_parameters mtl,
133: mfg_lookups lkps,
134: bom_departments depts2,
135: bom_department_resources dept_res,
136: bom_resources resources,
137: bom_departments depts1
138: WHERE resources.resource_id = dept_res.resource_id

Line 137: bom_departments depts1

133: mfg_lookups lkps,
134: bom_departments depts2,
135: bom_department_resources dept_res,
136: bom_resources resources,
137: bom_departments depts1
138: WHERE resources.resource_id = dept_res.resource_id
139: AND resources.organization_id = depts1.organization_id
140: AND dept_res.department_id = depts1.department_id
141: AND depts2.department_id =

Line 473: from bom_departments

469: BEGIN
470: update crp_capacity_plans plan
471: set department_class =
472: (select department_class_code
473: from bom_departments
474: where department_id = plan.department_id),
475: resource_type =
476: (select meaning
477: from mfg_lookups,