HR Per All People F Diagnostic Listing
Description
Diagnostic Listing of per_all_people_f table
Run
HR Per All People F Diagnostic Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
select papf.full_name, papf.person_id, papf.effective_start_date, papf.effective_end_date, nvl2(pa.agent_id,'Y','N') is_buyer_yn from hr.per_all_people_f papf, po_agents pa where 1=1 and papf.person_id = pa.agent_id (+) order by nvl2(pa.agent_id,'Y','N') desc, papf.full_name, papf.effective_start_date |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Effective Date |
|
Date |