V_INSTALLED_BUSINESSPROCESSCATALOG
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| ALLOWSIMULTANEOUSEXECUTION | bit | ||
| NAME | nvarchar(60) | ||
| DESCRIPTION | nvarchar(1000) | ||
| BUSINESSPROCESSSPECXML | xml | ||
| RECORDTYPEID | uniqueidentifier | ||
| PARAMETERTABLENAME | nvarchar(100) | yes | |
| PARAMETERLABELFIELD | nvarchar(100) | ||
| SECURITYUIFOLDER | nvarchar(255) | ||
| ADDEDBYID | uniqueidentifier | ||
| CHANGEDBYID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TS | timestamp | ||
| TSLONG | bigint | yes | |
| ALLOWENQUEUE | bit |
Definition
Copy
CREATE view dbo.V_INSTALLED_BUSINESSPROCESSCATALOG as
select
BUSINESSPROCESSCATALOG.ID,
BUSINESSPROCESSCATALOG.ALLOWSIMULTANEOUSEXECUTION,
BUSINESSPROCESSCATALOG.NAME,
BUSINESSPROCESSCATALOG.DESCRIPTION,
BUSINESSPROCESSCATALOG.BUSINESSPROCESSSPECXML,
BUSINESSPROCESSCATALOG.RECORDTYPEID,
BUSINESSPROCESSCATALOG.PARAMETERTABLENAME,
BUSINESSPROCESSCATALOG.PARAMETERLABELFIELD,
BUSINESSPROCESSCATALOG.SECURITYUIFOLDER,
BUSINESSPROCESSCATALOG.ADDEDBYID,
BUSINESSPROCESSCATALOG.CHANGEDBYID,
BUSINESSPROCESSCATALOG.DATEADDED,
BUSINESSPROCESSCATALOG.DATECHANGED,
BUSINESSPROCESSCATALOG.TS,
BUSINESSPROCESSCATALOG.TSLONG,
BUSINESSPROCESSCATALOG.ALLOWENQUEUE
from
dbo.BUSINESSPROCESSCATALOG
inner join
FEATUREUNLOCKEDBYPRODUCTFLAGS on FEATURESPECID = BUSINESSPROCESSCATALOG.ID
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.FEATURESPECTYPECODE = 22
and
FEATUREUNLOCKEDBYPRODUCTFLAGS.UNLOCKED = 1;