cancel
Showing results for 
Search instead for 
Did you mean: 

subquery

ramoji9314
Rocketeer

Hi Team,

Glad to see you all.

I need help to get run time values by passing input. in sql query we can call as subquery.

query(
EBS_CS.CS_ESTIMATE_DETAILS.AFTER_WARRANTY_COST,
EBS_CS.CS_ESTIMATE_DETAILS.SOURCE_CODE = 'DR',
EBS_CS.CS_ESTIMATE_DETAILS.LINE_CATEGORY_CODE = 'ORDER',
EBS_CS.CS_ESTIMATE_DETAILS.CHARGE_LINE_TYPE = 'ACTUAL',
EBS_CS.CS_ESTIMATE_DETAILS.SOURCE_ID = ($repairlineid))

I need to pass repair line id as input.

 

Please help on this.

 

2 REPLIES 2

RADSr
Captain
Captain

I'm not clear on exactly what you want - where/how do you want to use this?

If it's an insight, you can create an estimate details view in a business schema and then filter that using inquery   

RADSr_0-1708016698774.png

Or use an Incorta Result Set as the insight data source and filter that   

RADSr_1-1708016768800.png

 

 

-- IncortaOne@PMsquare.com --

Prince
Employee
Employee

@ramoji9314 , I am not also clear about what exactly is required, but there are 2 things, one mentioned by @RADSr , and in other places, you can use variables, according the context, global or presentation variables.