WIP Shop Floor Statuses

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
Run WIP Shop Floor Statuses and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Blitz Report™