Stage and state on sc_req_item

[ritaaudi]

Hi: If I create a new workflow on sc_req_item table and look at the Stages in the workflow properties, I see the following: Request Approved, Waiting for Approval, Fulfillment, Delivery, Request Cancelled, Completed. I read that these come from the Stage choices on sc_req_item and wf_stage_default. I don't see 'Request Approved' in either of those tables. Where is that coming from? Also how does the state field on sc_req_item get populated. I can't seem to find the right business rule. Thank you for your help!

[supriya29]

1. add a new stage by Stage Sets -> Requested Item -> New

2. To add to a workflow.First checkout and go to Edit Stages. and Import Stage set which adds the New stages. 

3. Add the new stage to the workflow core activities.