WIP Accounting Classes

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: WIP Accounting Classes Report
Application: Work in Process
Source: WIP Accounting Classes Report (XML)
Short Name: WIPSUCLS_XML
DB package: WIP_WIPSUCLS_XMLP_PKG
Run WIP Accounting Classes and other Oracle EBS reports with Blitz Report™ on our demo environment
select C.class_code, M.meaning, C.disable_date, C.description,
       C.material_account, C.material_variance_account,
       C.material_overhead_account, C.resource_account,
       C.resource_variance_account,
       C.outside_processing_account,
       C.outside_proc_variance_account,
       C.overhead_account,
       C.overhead_variance_account,
       C.std_cost_adjustment_account,
       decode(C.COMPLETION_COST_SOURCE,
	       '','',
	       M1.meaning) Completion_Cost_Source,
       decode(C.COST_TYPE_ID, 
	      '', '',
	       M2.description) Cost_Type,
       C.est_scrap_account,
       C.est_scrap_var_account,
       C.class_type
from wip_accounting_classes C,
     mfg_lookups M,
     mfg_lookups M1,
     CST_COST_TYPES M2
where C.organization_id = :P_Organization_Id
  and M.lookup_code = C.class_type           
  and M.lookup_type = 'WIP_CLASS_TYPE'
  and M1.lookup_code = nvl(C.COMPLETION_COST_SOURCE ,1)       
  and M1.lookup_type = 'CST_COMPLETION_COST_SRC'
  and M2.COST_TYPE_ID = nvl(C.COST_TYPE_ID ,1)    
order by C.class_code
Download
 
Related Blitz Reports
CAC Material Account Summary CAC WIP Material Usage Variance CAC ICP PII Material Account Detail CAC Material Account Detail CAC ICP PII WIP Material Usage Variance CAC Purchase Price Variance CAC WIP Resource Efficiency with Method and Lot Variances CAC WIP Material Usage with Configuration and Lot Variances CAC WIP Resource Efficiency
Blitz Report™

Blitz Report™ provides multiple benefits: