ORA-00998 with '' in CREATE VIEW .. SELECT ..
Here is the Query ..
I get an error as indicated below ...
SELECT A.EMPLID || ',' ||
A.LAST_NAME || ',' ||
(select N.LAST_NAME from PS_NAMES N where A.EMPLID = N.EMPLID AND N.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_NAMES A_ED WHERE N.EMPLID = A_ED.EMPLID AND N.NAME_TYPE = A_ED.NAME_TYPE AND A_ED.EFFDT <= SYSDATE) AND N.NAME_TYPE = 'PRF') || ',' ||
A.FIRST_NAME || ',' ||
(select N.FIRST_NAME from PS_NAMES N where A.EMPLID = N.EMPLID AND N.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_NAMES A_ED WHERE N.EMPLID = A_ED.EMPLID AND N.NAME_TYPE = A_ED.NAME_TYPE AND A_ED.EFFDT <= SYSDATE) AND N.NAME_TYPE = 'PRF') || ',' ||
trim(A.MIDDLE_NAME) || ',' ||
A.PER_STATUS || ',' ||
A.REG_TEMP || ',' ||
A.EMPL_STATUS || ',' ||
replace(B.ADDRESS1,',','') || ',' ||
B.CITY || ',' ||
B.POSTAL || ',' ||
A.WORK_PHONE || ',' ||
D.EMAIL_ADDR || ',' ||
E.GROUP_ID || ',' ||
A.BUSINESS_UNIT || ',' ||
A.DEPTID || ',' ||
E.SD_DIVISION_ID *|| '' -------------> Here is where I get the error at the quotes
FROM PS_EMPLOYEES A, PS_LOCATION_TBL B, PS_PAYROLL_DATA C,
PS_EMAIL_ADDRESSES D, PS_SD_HR_DEPTFLAT E
WHERE A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_EMPLOYEES A_ED
WHERE A.EMPLID = A_ED.EMPLID
AND A.EMPL_RCD = A_ED.EMPL_RCD
AND A_ED.EFFDT <= SYSDATE)
AND A.EFFSEQ =
(SELECT MAX(A_ES.EFFSEQ) FROM PS_EMPLOYEES A_ES
WHERE A.EMPLID = A_ES.EMPLID
AND A.EMPL_RCD = A_ES.EMPL_RCD
AND A.EFFDT = A_ES.EFFDT)
AND B.LOCATION = A.LOCATION
AND A.EMPL_RCD = 0
AND B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_LOCATION_TBL B_ED
WHERE B.SETID = B_ED.SETID
AND B.LOCATION = B_ED.LOCATION
AND B_ED.EFFDT <= SYSDATE)
AND A.EMPLID = C.EMPLID
AND C.COMPANY = A.COMPANY
AND A.EMPLID = D.EMPLID
AND D.E_ADDR_TYPE = 'BUSN'
AND A.BUSINESS_UNIT not in ('A4730','A4980','A3780','A4120')
AND E.BUSINESS_UNIT = A.BUSINESS_UNIT
AND E.DEPTID = A.DEPTID
ORDER BY 1