ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3A73869E053B46B63588994Y 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' PO POCLOSEOUTCT AR PO نموذج قائمة اختيار الإقفال Application: المشتريات Source: Short Name: POCLOSEOUTCT DB package: D PO Checklisten-Vorlage für Abschluss Application: Einkauf Source: Short Name: POCLOSEOUTCT DB package: F PO Modèle de liste de contrôle de clôture Application: Purchasing Source: Short Name: POCLOSEOUTCT DB package: US PO Closeout Checklist Template Application: Purchasing Source: Short Name: POCLOSEOUTCT DB package: ZHS PO 关闭核对清单模板 Application: 采购管理系统 Source: Short Name: POCLOSEOUTCT DB package: BI Publisher :poheaderid