ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B9847D20A0E4742FE0538931640A6379 AP Supplier Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US 8E2FF36EDF1479D2E0530100007F1FF2 AP Supplier Number Y select aps.segment1 value, aps.vendor_name description from ap_suppliers aps where :$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id) order by aps.segment1, aps.vendor_id US 98567A11CE2765ADE0530100007F6157 AP Supplier Type Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='VENDOR TYPE' and flvv.view_application_id=201 and flvv.security_group_id=0 order by flvv.lookup_code US 8E2FF36EDE8379D2E0530100007F1FF2 Country Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US A24AF8EFCDFF6E06E0530100007F1633 select haouv.name operating_unit, pv.vendor_name supplier, pv.segment1 supplier_number, xxen_util.meaning(pv.vendor_type_lookup_code,'VENDOR TYPE',201) type, pv.type_1099 income_tax_type, pv.num_1099 taxpayer_id, pv.vat_registration_num tax_registration_number, pv0.vendor_name parent_supplier_name, pv0.segment1 parent_supplier_number, pv.customer_num, pv.vat_code, decode(pv.small_business_flag,'Y','Y') small_business_flag, decode(pv.hold_flag,'Y','Y') hold_flag, pv.purchasing_hold_reason, pv.min_order_amount, pv.price_tolerance, pvsa.vendor_site_code site_code, pvsa.address_line1, pvsa.address_line2, pvsa.address_line3, pvsa.address_line4, pvsa.city, pvsa.state, pvsa.zip, pvsa.county, pvsa.province, nvl(ftv.territory_short_name,pvsa.country) country, pvsa.area_code, pvsa.phone, pvsa.fax_area_code, pvsa.fax, pvsa.supplier_notif_method, pvsa.email_address, nvl(pvsa.terms_date_basis,pv.terms_date_basis) terms_date_basis, nvl(pvsa.pay_group_lookup_code,pv.pay_group_lookup_code) pay_group, nvl(att1.name,att0.name) payment_terms, xxen_util.meaning(nvl(pvsa.pay_date_basis_lookup_code,pv.pay_date_basis_lookup_code),'PAY DATE BASIS',201) pay_date_basis, xxen_util.client_time(pv.creation_date) supplier_creation_date, xxen_util.user_name(pv.created_by) supplier_created_by, xxen_util.client_time(pv.last_update_date) supplier_last_update_date, xxen_util.user_name(pv.last_updated_by) supplier_last_updated_by, xxen_util.client_time(pvsa.creation_date) site_creation_date, xxen_util.user_name(pvsa.created_by) site_created_by, xxen_util.client_time(pvsa.last_update_date) site_last_update_date, xxen_util.user_name(pvsa.last_updated_by) site_last_updated_by &contacts_columns from hr_all_organization_units_vl haouv, po_vendors pv, po_vendor_sites_all pvsa, fnd_territories_vl ftv, (select pvc.* from po_vendor_contacts pvc where '&show_contacts'='Y' and nvl(pvc.inactive_date,sysdate)>=sysdate) pvc, po_vendors pv0, ap_terms_tl att0, ap_terms_tl att1 where 1=1 and pv.vendor_id=pvsa.vendor_id(+) and pvsa.org_id=haouv.organization_id(+) and pvsa.country=ftv.territory_code(+) and pvsa.vendor_site_id=pvc.vendor_site_id(+) and pv.parent_vendor_id=pv0.vendor_id(+) and pv.terms_id=att0.term_id(+) and pvsa.terms_id=att1.term_id(+) and att0.language(+)=userenv('lang') and att1.language(+)=userenv('lang') Y 49A8B1A803C008ACE0530100007FEB91 US AP Suppliers 11i AP suppliers (po vendors) including supplier sites and contact information Enginatics &contacts_columns &show_contacts 1=1 1 10 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Y F Unité d'exploitation US Operating Unit 2 20 1=1 pv.vendor_name=:supplier_name LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id F Fournisseur US Supplier 3 30 1=1 pv.segment1=:supplier_number LOV AP Supplier Number 8E2FF36EDF1479D2E0530100007F1FF2 Y select aps.segment1 value, aps.vendor_name description from ap_suppliers aps where :$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id) order by aps.segment1, aps.vendor_id F Numéro de fournisseur US Supplier Number 4 40 1=1 pv.vendor_type_lookup_code=xxen_util.lookup_code(:vendor_type,'VENDOR TYPE',201) LOV AP Supplier Type 98567A11CE2765ADE0530100007F6157 Y select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='VENDOR TYPE' and flvv.view_application_id=201 and flvv.security_group_id=0 order by flvv.lookup_code F Type de fournisseur US Supplier Type 5 50 1=1 ftv.territory_short_name=:country LOV Country 8E2FF36EDE8379D2E0530100007F1FF2 Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name F Pays US Country 6 60 &show_contacts Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les contacts US Show Contacts 7 &contacts_columns , pvc.prefix, pvc.first_name contact_first_name, pvc.middle_name contact_middle_name, pvc.last_name contact_last_name, pvc.title contact_title, pvc.area_code contact_area_code, pvc.phone contact_phone F Afficher les contacts US Show Contacts :$flex$.operating_unit Operating Unit Supplier :$flex$.operating_unit Operating Unit Supplier Number