DBA Data[Home] [Help]

APPS.CRP_FORM_PK dependencies on BOM_RESOURCES

Line 136: bom_resources resources,

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
140: AND dept_res.department_id = depts1.department_id

Line 478: bom_resources

474: where department_id = plan.department_id),
475: resource_type =
476: (select meaning
477: from mfg_lookups,
478: bom_resources
479: where lookup_type = 'BOM_RESOURCE_TYPE'
480: and lookup_code = resource_type
481: and resource_id = plan.resource_id),
482: resource_group_name =