WIP Shop Floor Statuses

➜ Back to Library
XLSExcel example XMLXML import file

Description

Categories
BI Publisher
Application
Work in Process
Source
Shop Floor Statuses Report (XML)
Short Name
WIPSUSTA_XML
DB package
WIP_WIPSUSTA_XMLP_PKG
Imported from BI Publisher
Shop Floor Statuses Report

SQL 11 lines

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