Create a table type value set.
Choose the form filed, from the diagonistics choose the form block name and filed name
In the where condition add the condition like
Where 1=1
and table.column_name= :FORM_BLOCK_NAME.FILED_NAME
example:
SELECT segment1
FROM pa_projects_all
WHERE project_status_code = 'UNAPPROVED'
and attribute1 || '.' || attribute2 || '.' || attribute3=SUBSTR(:LINES.ACCOUNTING_FLEXFIELD,1,11)
Form Folder - LINES
Form filed -- ACCOUNTING_FLEXFIELD
Define Table type value set
Table Name: pa_projects_all
value: segment1
Where:
project_status_code = 'UNAPPROVED'
and attribute1 || '.' || attribute2 || '.' || attribute3=SUBSTR(:LINES.ACCOUNTING_FLEXFIELD,1,11)
No comments:
Post a Comment