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

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!