ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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）限制的操作单元。 C6E085D4723C51A9E05362FB09050512 SELECT lc2.displayed_field C_PRODUCT, DECODE (:p_sort_option,'Type,QuickCode', lc.lookup_type , 'No order column') C_SORT_1, UPPER(lc.lookup_code) C_SORT_2, lc.lookup_code C_LOOKUP_CODE, lc.lookup_type C_LOOKUP_TYPE, lc.displayed_field C_DISPLAYED_FIELD, lc.description C_DESCRIPTION, lc.inactive_date C_INACTIVE_DATE FROM ap_lookup_codes lc, ap_lookup_codes lc2, ap_lookup_types lt WHERE DECODE(Upper(:p_active_type),'ACTIVE', nvl(lc.inactive_date, :lp_effective_date + 1) - :lp_effective_date, 'INACTIVE', :lp_effective_date +1 - nvl(lc.inactive_date, :lp_effective_date + 1), 'BOTH',1, NULL,1) > 0 AND lc2.lookup_type = 'PRODUCT_NAMES' AND lc2.lookup_code = 'AP' AND lc.lookup_type = lt.lookup_type AND lt.user_updatable_flag = 'Y' UNION SELECT lc2.displayed_field C_PRODUCT, DECODE (:p_sort_option,'Type,QuickCode', lc.lookup_type , 'No order column') C_SORT_1, UPPER(lc.lookup_code) C_SORT_2, lc.lookup_code C_LOOKUP_CODE, lc.lookup_type C_LOOKUP_TYPE, lc.displayed_field C_DISPLAYED_FIELD, lc.description C_DESCRIPTION, lc.inactive_date C_INACTIVE_DATE FROM po_lookup_codes lc, ap_lookup_codes lc2, po_lookup_types lt WHERE DECODE(Upper(:p_active_type),'ACTIVE', nvl(lc.inactive_date, :lp_effective_date + 1) - :lp_effective_date, 'INACTIVE', :lp_effective_date +1 - nvl(lc.inactive_date, :lp_effective_date + 1), 'BOTH',1, NULL,1) > 0 AND lc2.lookup_type = 'PRODUCT_NAMES' AND lc2.lookup_code = 'PO' AND lc.lookup_type = lt.lookup_type AND lt.user_updatable_flag = 'U' ORDER BY 1, 2, 3, 4, 5, 6, 7 Y SQLAP APXQCQCL_XML AR AP قائمة اشتقاق المدفوعات (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: قائمة اشتقاق المدفوعات Application: المدفوعات Source: قائمة اشتقاق المدفوعات (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG D AP Liste Kreditoren-Suchbegriffe- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Liste Kreditoren-Suchbegriffe Application: Kreditoren Source: Liste Kreditoren-Suchbegriffe (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG E AP Listado de Valores de Listas de Cuentas a Pagar: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Listado de Valores de Listas de Cuentas a Pagar Application: Payables Source: Listado de Valores de Listas de Cuentas a Pagar (XML): No Admitido, Reservado para Uso Futuro Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG F AP Liste des codes express de Payables- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Liste des codes express d'Oracle Payables Application: Payables Source: Liste des codes express de Payables (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG I AP Elenco ricerca Payables- non supportato: riservato per usi futuri Imported from BI Publisher Description: Elenco ricerca Payables Application: Payables Source: Elenco ricerca Payables (XML) - non supportato: riservato per usi futuri Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG JA AP 買掛/未払金参照リスト- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 買掛/未払金参照リスト Application: Payables Source: 買掛/未払金参照リスト(XML) - 未サポート: 将来の使用のために予約 Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG KO AP 룩업 목록- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: AP 룩업 목록 Application: Payables Source: AP 룩업 목록(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG PTB AP Lista de Pesquisa do Payables- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Listagem da Pesquisa do Payabes Application: Payables Source: Lista de Pesquisa do Payables (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG RU AP Список кодов поиска Кредиторов- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Список кодов поиска Кредиторов Application: Кредиторы Source: Список кодов поиска Кредиторов (XML) - не поддерживается: зарезервировано для будущего использования Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG S AP Snabbkoder i Leverantörsreskontra - lista- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Snabbkoder i Leverantörsreskontra - lista Application: Payables Source: Snabbkoder i Leverantörsreskontra - lista (XML) - Stöds inte: Reserverad för framtida bruk Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG TR AP Borçlar Muhasebesi Arama Listesi- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Borçlar Muhasebesi Arama Listesi Application: Borçlar Muhasebesi Source: Borçlar Muhasebesi Arama Listesi (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG US AP Payables Lookup Listing- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Payables Lookup Listing Application: Payables Source: Payables Lookup Listing (XML) - Not Supported: Reserved For Future Use Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG ZHS AP 应付款代码列表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 应付款代码列表 Application: 应付帐款 Source: 应付款代码列表 (XML) - 不支持：已保留供将来使用 Short Name: APXQCQCL_XML DB package: AP_APXQCQCL_XMLP_PKG BI Publisher :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_nls_active_type :c_nls_all :c_nls_end_of_report :c_nls_no :c_nls_no_data_exists :c_nls_yes :c_report_start_date :lp_effective_date :operating_unit :p_active_type :p_conc_request_id :p_debug_switch :p_effective_date :p_flexdata :p_min_precision :p_set_of_books_id :p_sort_option 1 -20 :p_set_of_books_id Char fnd_profile.value('GL_SET_OF_BKS_ID') Y AR دفتر الأستاذ معرف دفتر الأستاذ D Buch Buchkennung E Libro Mayor Identificador de libro mayor F Livre ID livre I Libro contabile Id del libro contabile JA 元帳 元帳ID KO 원장 원장 ID PTB Razão Id do Razão RU Книга Идентификатор книги S Huvudbok Huvudboks-id TR Defter Defter No US Ledger Ledger Id ZHS 分类帐 分类帐标识 2 0 :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 select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 3 10 :p_sort_option LOV Oracle AP_SRS_QUICKCODE_ORDER Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='QUICKCODE_SORT_OPTIONS' order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'QUICKCODE_SORT_OPTIONS' and lookup_code = 'Type,QuickCode' AR ترتيب الرموز السريعة بواسطة ترتيب الرموز السريعة بواسطة D QuickCodes sortieren nach QuickCodes sortieren nach E Ordenar Listas de Valores por ordenar listas de valores por F Trier codes express par Trier les codes express par I Ordina codici rapidi per Ordina codici rapidi per JA クイック・コードのソート クイック・コードのソート KO 퀵코드 정렬 기준 퀵코드 정렬 기준 PTB Classificar QuickCodes Por classificar quickcodes por RU Сортировка экспресс-кодов Сортировка экспресс-кодов S Sortera snabbkoder efter sortera snabbkoder efter TR QuickCode'ları Sıralayan quickcode'ları sıralayan US Sort QuickCodes By sort quickcodes by ZHS 快速编码排序依据 快速编码排序依据 4 20 :p_active_type LOV Oracle AP_SRS_ACTIVE_OPTION_OPT Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='ACTIVE_OPTIONS' order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'ACTIVE_OPTIONS' and lookup_code = 'Both' AR يتضمن الرموز النشطة/غير النشطة يتضمن الرموز النشطة/غير النشطة D Mit gültigen/ungültigen QuickCodes Mit gültigen/ungültigen QuickCodes E Incluir Códigos Activos/Inactivos incluir códigos activos/inactivos F Inclure codes activés/désactivés Inclure codes activés/désactivés I Includi codici attivi/inattivi Include i codici attivi/inattivi JA 有効/無効コードを含む 有効/無効コードを含む KO 유효/무효 코드 포함 유/무효 코드 포함 PTB Incluir Códigos Ativos/Inativos incluir códigos ativos/inativos RU Включить активные/неактивные коды Включить активные/неактивные коды S Inkludera aktiva/inaktiva koder inkludera aktiva/inaktiva koder TR Etkin/Etkin Olmayan Kodları Dahil Et etkin/etkin olmayan kodları dahil eder US Include Active/Inactive Codes include active/inactive codes ZHS 包括有效/无效代码 包括有效/无效代码 5 30 :p_effective_date Date sysdate Y AR تاريخ الفعالية تاريخ الفعالية D Gültigkeit Gültigkeit E Fecha en Vigor fecha en vigor F Date de validité Date de début de validité I Data validità data validità JA 有効日 有効日 KO 유효 일자 유효 일자 PTB Data Efetivação data de efetivação RU Дата действия дата действия S Giltighetsdatum giltighetsdatum TR Geçerlilik Tarihi geçerlilik tarihi US Effective Date effective date ZHS 有效日期 有效日期