Work order approval required based on the total estimated cost

Hi,

Scenario:

Work order approval required based on the total estimated cost.

Approval for supervisor upto 2000 USD.

Approval for manager upto 8000 USD.

Approval for general manager above 8000 USD.

Setup did: (AME 12.2.8 version)

1. Enable workflow for work orders in EAM Parameter.

2. Attribute created to get the work order cost

Usage Type as "Dynamic"

Data Type as "Number"

my sql query for Dynamic Attribute, to get the run time value (this is for your reference)

SELECT NVL ( ( (  -SUM (e.actual_mat_cost)

- SUM (e.actual_lab_cost)

- SUM (e.actual_eqp_cost))

+ (  SUM (e.system_estimated_mat_cost)

+ SUM (e.system_estimated_lab_cost)