WIP Shop Floor Statuses

Description
Categories: BI Publisher, Manufacturing
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
Parameter Name SQL text Validation
Org_id
 
Number
Ask a question