BOM Standard Operation

Description

Imported from BI Publisher
Description: Standard Operation Report
Application: Bills of Material
Source: Standard Operation Report (XML)
Short Name: BOMRDRSO_XML
DB package: BOM_BOMRDRSO_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

select 
       bsor.standard_operation_id standard_operation_id,
       br.resource_code resource_code,
       br.description resource_desc,
       ca.activity activity,
       bsor.resource_seq_num resource_seq_num,
       round(bsor.usage_rate_or_amount, :P_QTY_PRECISION) usage_rate_or_amount,
       round(bsor.usage_rate_or_amount_inverse, :P_QTY_PRECISION) usage_rate_or_amount_inverse,
       lu1.meaning basis,
       lu2.meaning autocharge,
       lu3.meaning standard_rate,
       round(bsor.assigned_units, :P_QTY_PRECISION) assigned_units,
       lu4.meaning schedule,
       lu5.meaning available_24_hours,
       br.unit_of_measure uom,
       bdr.department_id
from 
     bom_std_op_resources bsor,
     bom_department_resources bdr,
     bom_resources br,
     cst_activities ca,
     mfg_lookups lu1,
     mfg_lookups lu2,
     mfg_lookups lu3,
     mfg_lookups lu4,
     mfg_lookups lu5
where 
          br.resource_id = bsor.resource_id
  and ca.activity_id (+) = bsor.activity_id
  and bsor.resource_id = bdr.resource_id
  and lu1.lookup_type = 'CST_BASIS'
  and lu1.lookup_code = bsor.basis_type
  and lu2.lookup_type = 'BOM_AUTOCHARGE_TYPE'
  and lu2.lookup_code = bsor.autocharge_type 
  and lu3.lookup_type = 'SYS_YES_NO'
  and lu3.lookup_code = bsor.standard_rate_flag
  and lu4.lookup_type = 'BOM_RESOURCE_SCHEDULE_TYPE'
  and lu4.lookup_code = bsor.schedule_flag
  and lu5.lookup_type = 'SYS_YES_NO'
  and lu5.lookup_code = bdr.available_24_hours_flag 
 and bsor.standard_operation_id=:standard_operation_id_dtl
 and bdr.department_id=:department_id1
order by bsor.resource_seq_num