02-09-2024 11:39 AM
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.
02-15-2024 09:06 AM
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
03-14-2024 01:16 AM
@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.