HR Per All People F Diagnostic Listing

➜ Back to Library
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 
trunc(:p_eff_date) between papf.effective_start_date and papf.effective_end_date
 Date
Download
Related Blitz Reports
PO Item Summary Listing XXDPF Shortages ECC Discrete Manufacturing, Resources PO Item Detail Listing PO Closeout Checklist Template PO Overdue Vendor Shipments PO RFQ Action Required ECC Procurement, Purchase Orders FA Asset Book Details
Blitz Report™

Blitz Report™ provides multiple benefits: