SQL query to get the costing details at the element entry level.

Summary:

Hi ,

I have a requirement where I need to fetch the costing details at the element entry level. I have developed the code ( PFA) but not able to get the costing data. I am exactly not sure about the significance of source_type of costing table but I tried by using EL and EE but still data does not come.

Thanks.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

select

  papf.Person_number "EMPLOYEE NUMBER"

,(SELECT NATIONAL_IDENTIFIER_NUMBER 

    FROM PER_NATIONAL_IDENTIFIERS PNI