Only issue with one person number of the query
Summary:
HI Team,
for below working fine but coming to one person number not getting the data. below error coming
error:Data_das
Could u please assist on this.@Mandeep Gupta
Thanks.
Ajay
Content (required):
select DISTINCT papf.Person_number,
ppnf.Full_Name,
--pni.NATIONAL_IDENTIFIER_NUMBER,
-- Pn.PASSPORT_NUMBER,
pp.attribute3 as "Business Card Title",
to_char(ppos.ORIGINAL_DATE_OF_HIRE, 'DD-MM-YYYY') Hire_Date,
to_char(CURRENT_DATE,'DD-MM-YYYY'),
(case when pc.LEGISLATION_CODE = 'MY'
then pni.NATIONAL_IDENTIFIER_NUMBER
else Pn.PASSPORT_NUMBER end) nid
from
PER_PERSON_SECURED_LIST_V papf,
PER_PERSON_NAMES_F ppnf,
Tagged:
0