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.

 

1 REPLY 1

RADSr
Partner
Partner

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