DBA Data[Home] [Help]

APPS.CRP_FORM_PK dependencies on BOM_DEPARTMENT_RESOURCES

Line 135: bom_department_resources dept_res,

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
139: AND resources.organization_id = depts1.organization_id

Line 484: from bom_department_resources

480: and lookup_code = resource_type
481: and resource_id = plan.resource_id),
482: resource_group_name =
483: (select resource_group_name
484: from bom_department_resources
485: where department_id = plan.department_id
486: and resource_id = plan.resource_id)
487: where query_id = arg_query_id;
488: