PO Closeout Checklist Template

Description
Categories: BI Publisher, Procurement
Application: Purchasing
Source:
Short Name: POCLOSEOUTCT
DB package:
 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'