Form personalization(default_where) not working in Oracle Receivables Account Details screen
I want to restrict the result to a specific Transaction type , which(transaction type) is hidden in the form .
For that i use DEFAULT_WHERE IN TARGET OBJECT CQIT_PS .
below is the query .
TYPE_NAME in (SELECT NAME FROM RA_CUST_TRX_TYPES_ALL R WHERE R.ATTRIBUTE2 = 'xxxxxxxx')
Please help . It is not working .