Home » Applications » Oracle Fusion Apps & E-Business Suite » OAF Field Ref in ValueSet Table Where Clause (Oracle Fusion R11)
OAF Field Ref in ValueSet Table Where Clause [message #662258] Fri, 21 April 2017 12:45
OraFus_J
Messages: 1
Registered: April 2017
Junior Member
I am trying to reference a field on an html page in order to limit my ValueSet Lookup. Is it possible to do this? I have been able to locate the Fusion tables and columns in order to lock down what I need to the column and table but the list shows values for all records in the table.

I really want to just have the ValueSet look at the current row/record that is up in the html page.

Is this possible?

Below is the current setup in my ValueSet:

FROM Clause: PJF_PROJECTS_ALL_B Pro, POR_REQ_DISTRIBUTIONS_ALL Req, POR_REQUISITION_LINES_ALL LIN

Value Column Name: Pro.Attribute10

Description Column Name: to_char(LIN.LINE_NUMBER)

ID Column Name:

WHERE Clause: Req.REQUISITION_LINE_ID = LIN.REQUISITION_LINE_ID AND Req.PJC_PROJECT_ID = Pro.Project_ID
Previous Topic: Can we send Workflow Notification emails to distribution list email address
Next Topic: Arabic report for EBS 11.5 ,develop reports in Arabic,how to?
Goto Forum:
  


Current Time: Fri Dec 15 21:26:03 CST 2017

Total time taken to generate the page: 0.01860 seconds