WIP Shop Floor Statuses
Description
Categories: BI Publisher
Columns: Shop Floor Status Code, Description, Meaning, Disable Date ...
Columns: Shop Floor Status Code, Description, Meaning, Disable Date ...
Application: Work in Process
Source: Shop Floor Statuses Report (XML)
Short Name: WIPSUSTA_XML
DB package: WIP_WIPSUSTA_XMLP_PKG
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 |