BOM Department

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Department Report
Application: Bills of Material
Source: Department Report (XML)
Short Name: BOMRDODP_XML
DB package: BOM_BOMRDODP_XMLP_PKG
Run BOM Department and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT dept_res.department_id               department_id2,
                   dept_res.resource_id                           resource_id1,
                  nvl(dept_res.share_from_dept_id,dept_res.department_id) linking_dept,
                   res.resource_code                                Name,
                   res.description                                      Description,
                   res.unit_of_measure                             UOM,
                   lu1.meaning                                           Allow_Sharing,
                   dept.department_code                         Share_From_Department,
                   ROUND(dept_res.capacity_units, :P_qty_precision)   Capacity_Units,
                   lu3.meaning                                           Available_24_Hours,
                   dept_res.resource_group_name        resource_group_name
            FROM   bom_department_resources dept_res,
                   bom_resources            res,
                   mfg_lookups              lu1,
                   bom_departments          dept,
                   mfg_lookups              lu3
            WHERE  dept_res.resource_id = res.resource_id
              and  dept_res.share_capacity_flag = lu1.lookup_code and
                   lu1.lookup_type = 'SYS_YES_NO'
              and  dept_res.share_from_dept_id = dept.department_id(+)
              and  dept_res.available_24_hours_flag = lu3.lookup_code and
                   lu3.lookup_type = 'SYS_YES_NO'
             and dept_res.department_id = :department_id_01
            ORDER BY res.resource_code
Parameter Name SQL text Validation
Overhead Details 
 
 LOV Oracle
Resource Details 
 
 LOV Oracle
Department Class 
 
 LOV Oracle
Departments From 
 
 LOV Oracle
To 
 
 LOV Oracle
Download
Related Blitz Reports
CRP Bill of Resources CAC Department Overhead Setup Errors WIP Repetitive Value CAC Department Overhead Rates CAC Item Cost & Routing CAC WIP Resource Efficiency with Method and Lot Variances CAC WIP Resource Efficiency CAC WIP Account Summary CAC Resources Associated with Overheads Setup CAC Resources by Department Setup
Blitz Report™

Blitz Report™ provides multiple benefits: