Additional Queries › Procedure Steps › Query for Procedure Step Listing

Query for Procedure Step Listing

SELECT M.NAME, M.CR_DATE, M.CR_TIME, B.NAME, B.DSPLY_1ST,
 B.NON_SCREENED, B.STEP_TYPE, D.TEXT
 FROM
 MODEL M,
 BUS_PROC_STEP B,
 DESCRIPTION D
 WHERE
 M.NAME='my model name'
 AND M.ID=B.MODEL_ID
 AND B.ID=D.ID
ORDER BY M.NAME, B.NAME;