ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3BC3869E053B46B63588994Y SELECT DISTINCT fdvl.category_description Usage , fdvl.description Name , fdvl.START_DATE_ACTIVE Start_date , fdvl.END_DATE_ACTIVE End_date --, fdvl.media_id Media_id , fdvl.media_id Media_id_1 , fdvl.datatype_id Datatype_id FROM fnd_documents_vl fdvl WHERE fdvl.category_application_id = 201 AND (fdvl.datatype_id = 1 or fdvl.datatype_id = 2) AND fdvl.usage_type = 'S' AND fdvl.category_description >= decode(:P_usage_from,'', fdvl.category_description,:P_usage_from) AND fdvl.category_description <= decode(:P_usage_to,'', fdvl.category_description,:P_usage_to) AND fdvl.description >= decode(:P_title_from,'', fdvl.description,:P_title_from) AND fdvl.description <= decode(:P_title_to,'', fdvl.description,:P_title_to) ORDER BY fdvl.category_description, fdvl.description PO POXNOTES_XML AR PO قائمة الإشعارات القياسية (بتنسيق XML) Application: المشتريات Source: قائمة الإشعارات القياسية (بتنسيق XML) Short Name: POXNOTES_XML DB package: PO_POXNOTES_XMLP_PKG D PO Einkauf - Standardnotizen Application: Einkauf Source: Einkauf - Standardnotizen (XML) Short Name: POXNOTES_XML DB package: PO_POXNOTES_XMLP_PKG F PO Liste des notes standard Application: Purchasing Source: Liste des notes standard (XML) Short Name: POXNOTES_XML DB package: PO_POXNOTES_XMLP_PKG US PO Standard Notes Listing Application: Purchasing Source: Standard Notes Listing (XML) Short Name: POXNOTES_XML DB package: PO_POXNOTES_XMLP_PKG ZHS PO 标准附注列表 Application: 采购管理系统 Source: 标准附注列表 (XML) Short Name: POXNOTES_XML DB package: PO_POXNOTES_XMLP_PKG BI Publisher :operating_unit :p_conc_request_id :p_sort_by :p_title :p_title_from :p_title_to :p_usage_from :p_usage_to 1 10 :p_title Char AR عنوان التقرير D Auswertungstitel F Titre de l'état US Report Title ZHS 报表标题 2 20 :p_usage_from LOV Oracle PO_SRS_STANDARD_NOTE_USAGE Y select ftl.user_name id, ftl.user_name value, null description from fnd_document_categories_tl ftl where ftl.language=userenv('LANG') and exists( select category_id from fnd_document_categories fdc where ftl.category_id=fdc.category_id and fdc.application_id=201) order by ftl.user_name AR الاستخدامات من D Von Verwendung F Usage - De US Usages From ZHS 使用自 3 50 :p_title_to LOV Oracle PO_SRS_STANDARD_NOTE_TITLE Y select fvl.description id, fvl.description value, null description from fnd_documents_vl fvl where exists (select document_id from fnd_attached_documents fad where fad.document_id=fvl.document_id and fad.entity_name in ('REQ_HEADERS','REQ_LINES','RCV_LINES', 'RCV_TRANSACTIONS','RCV_TRANSACTIONS_INTERFACE', 'PO_HEADERS','PO_LINES','PO_RELEASES','PO_SHIPMENTS', 'RCV_HEADERS','MTL_SYSTEM_ITEMS','PO_VENDORS') ) and fvl.usage_type='S' order by fvl.description AR إلى D Bis F A US To ZHS 至 4 30 :p_usage_to LOV Oracle PO_SRS_STANDARD_NOTE_USAGE Y select ftl.user_name id, ftl.user_name value, null description from fnd_document_categories_tl ftl where ftl.language=userenv('LANG') and exists( select category_id from fnd_document_categories fdc where ftl.category_id=fdc.category_id and fdc.application_id=201) order by ftl.user_name AR إلى D Bis F A US To ZHS 至 5 40 :p_title_from LOV Oracle PO_SRS_STANDARD_NOTE_TITLE Y select fvl.description id, fvl.description value, null description from fnd_documents_vl fvl where exists (select document_id from fnd_attached_documents fad where fad.document_id=fvl.document_id and fad.entity_name in ('REQ_HEADERS','REQ_LINES','RCV_LINES', 'RCV_TRANSACTIONS','RCV_TRANSACTIONS_INTERFACE', 'PO_HEADERS','PO_LINES','PO_RELEASES','PO_SHIPMENTS', 'RCV_HEADERS','MTL_SYSTEM_ITEMS','PO_VENDORS') ) and fvl.usage_type='S' order by fvl.description AR الأسماء من D Von Bezeichnung F Noms - De US Names From ZHS 名称自