WIP Accounting Classes

Description
Categories: BI Publisher, Manufacturing
Application: Work in Process
Source: WIP Accounting Classes Report (XML)
Short Name: WIPSUCLS_XML
DB package: WIP_WIPSUCLS_XMLP_PKG
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
Ask a question
Parameter Name SQL text Validation
Flex Structure Number
 
Number
Org_Id
 
Number