Thursday 2 May 2013

Display DFF value set values depending on form filed value


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