APPS.EDW_BOM_RES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 10

  select  res.resource_code||'-'||dept.department_code||'-'||
                mp.organization_code||'-'||inst.instance_code
      from      mtl_parameters mp,
                bom_departments dept,
                bom_resources res,
                bom_department_resources dept_res,
		edw_local_instance inst
      where     mp.organization_id = dept.organization_id
      and       dept.department_id = nvl(dept_res.share_from_dept_id,
                                         dept_res.department_id)
      and       res.resource_id = dept_res.resource_id
      and       dept_res.department_id = p_dept_line_id
      and       dept_res.resource_id = p_resource_id;

Line: 24

  select  lines.line_code||'-'||mp.organization_code||'-'||inst.instance_code
      from      mtl_parameters mp,
                wip_lines lines,
		edw_local_instance inst
      where     mp.organization_id = lines.organization_id
      and       lines.line_id = p_dept_line_id;