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

Only issue with one person number of the query

Received Response
11
Views
5
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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