Help with my SQL Code
Summary
Help with my SQL CodeContent
I am trying to create a BIP Report to show Document Payslips pdf uploaded for each employee (with HDL) which covers the Tables like HR_DOCUMENTS_OF_RECORD, FND_DOCUMENTS_TL, ,FND_ATTACHED_DOCUMENTS and per_all_people_f with related to person_id.
Problem is my BIP report with below query keeps erroring. The SQL is valid but the SQL query pulls back too many records. How can I get this to work ?
select "PER_ALL_PEOPLE_F"."PERSON_ID" as "PERSON_ID",
"PER_ALL_PEOPLE_F"."PERSON_NUMBER" as "PERSON_NUMBER",
1