I am using Automation Designer to create the actions to export the data using the query and taking the value of filters automatically from the variable that i created in earlier action items.
The query i am using is like the way.
SELECT a.cycle_count,
s.stocktake_date,
a.location,
a.dept,
a.class,
x.lot_num,
x.line_num,
x.store_item_sku_num,
c.item_desc,
a.item,
A.SNAPSHOT_UNIT_RETAIL,
SUM (a.SNAPSHOT_ON_HAND_QTY),
FROM stake_sku_loc a
, stake_head s
, jcp_orin_legacy_item_xref x, item_master c
WHERE a.cycle_count = s.cycle_count
AND s.stocktake_date BETWEEN '01-jul-2018' AND '31-Jul-2018' and
a.item = x.item and a.item = c.item
and x.status_code = 'A'
and c.status = 'A'
AND a.location = &&TEST_VAR /* Value from Variable*/
I am confused if i am using the correct syntax but if i use : in variable defination it bind variable error goes off but it does not use the value from the variable that i have created.