PO Closeout Checklist Template

➜ Back to Library
Description
Categories: BI Publisher
Application: Purchasing
Source:
Short Name: POCLOSEOUTCT
DB package:
Run PO Closeout Checklist Template and other Oracle EBS reports with Blitz Report™ on our demo environment
 select (select ppl.full_name from per_all_people_f ppl
		  where ppl.person_id = cld.check_list_signer_id and 
		  ppl.effective_start_date < sysdate AND ppl.effective_end_date > sysdate) full_name,
		 cld.checklist_signed_date, 
		 fnd_message.get_string('PO', 'PO_KO_SIGN_MSG') signtxt,   
                 (select max(hst.action_date) from po_action_history hst, po_headers_all hdr
                  where hst.object_type_code = 'PO' AND hst.object_sub_type_code = hdr.type_lookup_code AND hst.object_id = hdr.po_header_id
                  AND hst.action_code like '%PHY%' AND hdr.po_header_id = cld.reference_doc_id) phdate,
                 (select ext.PEI_INFORMATION1 from PER_PEOPLE_EXTRA_INFO ext, per_all_people_f ppl
                  where ext.INFORMATION_TYPE = 'CLM_CONTACT_TITLE' AND ext.person_id = ppl.person_id AND
                  ppl.person_id = cld.check_list_signer_id AND ppl.effective_start_date < sysdate AND ppl.effective_end_date > sysdate) PEI_INFORMATION1
                 from po_closeout_details cld 
                 where cld.reference_doc_id = nvl(:POHeaderID, cld.reference_doc_id)
                 AND cld.closeout_doc_type = 'INDIVIDUAL'
Download
Related Blitz Reports
PO Closeout Contract Completion Statement PON Solicitation data template ECC Sourcing, Negotiations, SQL1 FA Asset Book Details PO Requisition Upload PO Purchase Price Variance PO Cancelled Purchase Orders ECC Project Manufacturing, Procurement Activities, SQL2 PO View Award Changes Data Definition
Blitz Report™

Blitz Report™ provides multiple benefits: