How to pass values in lexical parameters in BIP seeded report

1/ First open the SQL Query 

 2/ If your query is like 

 Select abc, def, ghi 

from ap_invoice 

 &FROM_clause 

Where &WHERE_Clause 

p=q 

and m=t 

&ORDERBY_Clause 

 so while running the BI report in fusion please pass on below parameter: 

 &FROM_CLAUSE value will be ,ap_invoices_all or value can be any valid table name exist in entire query. 

 &WHERE_Clause value will be 1=1 and

&ORDERBY_Clause  value will be order by 1

In same fashion we can pass on lexical parameters and see how our query is and after passing parameters how it should look like in real . 

One more example :

SELECT gcc.CODE_COMBINATION_ID,
GCC.ATTRIBUTE_CATEGORY,
gcc.segment1 seg1,
gcc.segment2 seg2,
gcc.segment3 seg3,
gcc.segment4 seg4,
gcc.segment5 seg5,
&VSH_SELECT account
FROM GL_CODE_COMBINATIONS GCC
WHERE gcc.CHART_OF_ACCOUNTS_ID = 9090
AND &VSH_WHERE

&VSH_SELECT value will be null

&VSH_WHERE value will be 1=1