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
Tagged:
0