Tips & Techniques: Find the Jobs mapped to ShopFloor Status

Please also refer to for other tips and techniques documents from same Author

Problem Statement

The Work Order steps can be kept on hold or at a status by assigning what is called Shop Floor Status.

If I need to know whether shopfloor status is still assigned to a work order step from which table can I query to confirm on the same?

Solution

Below are the tables which have relation with Shop Floor Status.

Table		Foreign Table	Foreign Key Column
WIP_SHOP_FLOOR_STATUSES		WIP_SHOP_FLOOR_STATUS_CODES	WIP_SHOP_FLOOR_STATUSES.SHOP_FLOOR_STATUS_CODE WIP_SHOP_FLOOR_STATUSES.ORGANIZATION_ID