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

Is there any way to show supplier and employee names except contact names in single DFF

We have a requirement to show supplier and employee names except contact names in single DFF. We created a table value set on DFF but it has limitation on From clause (240 characters) and due to which our below query is not working. Please suggest any other solution.

SELECT UPPER(SUBSTR(PARTY_NAME,1,150))
FROM (
SELECT UPPER(PPNF.FULL_NAME) AS PARTY_NAME
FROM PER_ALL_PEOPLE_F PAPF,
PER_PERSON_NAMES_F PPNF
WHERE PAPF.PERSON_ID=PPNF.PERSON_ID
AND PPNF.NAME_TYPE='GLOBAL'
AND SYSDATE BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE
AND NOT EXISTS (SELECT 1 FROM PER_CONTACT_RELSHIPS_F PCRF

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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