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