WIP Shop Floor Statuses

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Shop Floor Statuses Report
Application: Work in Process
Source: Shop Floor Statuses Report (XML)
Short Name: WIPSUSTA_XML
DB package: WIP_WIPSUSTA_XMLP_PKG
select C.shop_floor_status_code,
       C.description,
       M.meaning,
       C.disable_date
from wip_shop_floor_status_codes C,
     mfg_lookups M
where C.organization_id = :P_Organization_Id
  and C.status_move_flag = lookup_code
  and lookup_type = 'SYS_YES_NO'
order by C.shop_floor_status_code
Download
Related Blitz Reports
CAC WIP Jobs With Complete Status Which Are Ready for Close CAC WIP Jobs With Complete Status But Not Ready for Close WIP Parameters CAC Purchase Price Variance CAC Interface Error Summary ECC Discrete Manufacturing, Operations CAC PO Price vs. Costing Method Comparison ECC Discrete Manufacturing, Work Orders CAC WIP Resource Efficiency
Blitz Report™