Revenue and Invoice AutoAccounting function not allowing Service type parameter

Hi Experts,

For Unbilled receivable and unearned revenue i want to derive one segment value based on Task Service type but while defining rule if i select Task Service Type that rule is not showing in LOV because of for revenue and invoice function will allow only project level parameters. but i want to derive one segment value based on Task Service type how we can do this.

can you please provide one sample sql statement which is not depend on parameter.

i want to write sql statement without parameters is it possible. If possible please provide one sample sql statement.