Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Requisition Header DFF issue — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Requisition Header DFF issue

Received Response
7
Views
2
Comments
edited Sep 6, 2021 2:27PM in Self Service Procurement 2 comments

Summary

Unbale to create DFF with Valdation type "Table"

Content

Hi Experts,

I am creating DFF in Requisition page. The DFF validation type is Table. We are pulling value from PPM area. To pull this we need to put join condition between 3 tables. In from clause system not allowing me to add 3 tables. Here is my query. Can any body check and help on this.

Select PT.CLASS_CODE
From 
PJF_CLASS_CODES_TL PT,
PJF_PROJECT_CLASSES PRC,
PJF_PROJECTS_ALL_B PB
where PT.CLASS_CODE_ID=PRC.CLASS_CODE_ID
AND PRC.class_category_id='300000007280875'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!