subquery

[ramoji9314]

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.

[RADSr]

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   

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

[Prince]

@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.