SELECT /* REGULAR ATTRIBUTES */ SH.SHOP_FLOOR_STATUS_CODE , SH.ORGANIZATION_ID , SH.DISABLE_DATE , SH.DESCRIPTION , LO.MEANING /* RESOLVED FOREIGN KEYS */ , PA.ORGANIZATION_CODE , AL.NAME , '_DF:WIP:WIP_SHOP_FLOOR_STATUS_CODES:SH' /* WHO */ , SH.CREATION_DATE , SH.CREATED_BY , SH.LAST_UPDATE_DATE , SH.LAST_UPDATED_BY FROM MFG_LOOKUPS LO , HR_ALL_ORGANIZATION_UNITS AL , MTL_PARAMETERS PA , WIP_SHOP_FLOOR_STATUS_CODES SH WHERE SH.ORGANIZATION_ID = PA.ORGANIZATION_ID AND SH.ORGANIZATION_ID = AL.ORGANIZATION_ID AND LO.LOOKUP_CODE = SH.STATUS_MOVE_FLAG AND LO.LOOKUP_TYPE = 'SYS_YES_NO' AND '_SEC:SH.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY