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）限制的操作单元。 C6E085D470EF51A9E05362FB09050512 SELECT LEASEOPP.REFERENCE_NUMBER "LEASEOPP_NUMBER", LQ.REFERENCE_NUMBER "QUOTE_NUMBER", HZP.PARTY_NAME PROSPECT_NAME, CHR.CONTRACT_NUMBER VENDOR_PROGRAM, LEASEOPP.CURRENCY_CODE, TO_CHAR(LEASEOPP.EXPECTED_START_DATE, 'DD-MON-YYYY') "EXPECTED_START_DATE", LQ.TERM, FND_VAL.MEANING "PRICING_METHOD", LKP_QT_STAT.MEANING "QUOTE_STATUS" FROM OKL_LEASE_OPPORTUNITIES_B LEASEOPP, HZ_PARTIES HZP, OKC_K_HEADERS_B CHR, OKL_LEASE_QUOTES_B LQ, FND_LOOKUP_VALUES FND_VAL, FND_LOOKUP_VALUES LKP_QT_STAT WHERE LQ.ID = :P_LQ_ID AND LQ.PARENT_OBJECT_ID = LEASEOPP.ID AND LEASEOPP.PROSPECT_ID = HZP.PARTY_ID AND LEASEOPP.PROGRAM_AGREEMENT_ID = CHR.ID (+) AND FND_VAL.LOOKUP_CODE = LQ.PRICING_METHOD AND FND_VAL.LOOKUP_TYPE = 'OKL_QUOTE_PRICING_METHOD' AND FND_VAL.LANGUAGE = USERENV('LANG') AND LKP_QT_STAT.LOOKUP_CODE = LQ.STATUS AND LKP_QT_STAT.LOOKUP_TYPE = 'OKL_LEASE_QUOTE_STATUS' AND LKP_QT_STAT.LANGUAGE = USERENV('LANG') UNION SELECT '' "LEASEOPP_NUMBER", -- for Counter Offer LQ.REFERENCE_NUMBER "QUOTE_NUMBER", HZP.PARTY_NAME PROSPECT_NAME, CHR.CONTRACT_NUMBER VENDOR_PROGRAM, LEASEAPP.CURRENCY_CODE, TO_CHAR(LEASEAPP.VALID_FROM, 'DD-MON-YYYY') "EXPECTED_START_DATE", LQ.TERM, FND_VAL.MEANING "PRICING_METHOD", LKP_QT_STAT.MEANING "QUOTE_STATUS" FROM OKL_LEASE_APPLICATIONS_B LEASEAPP, HZ_PARTIES HZP, OKC_K_HEADERS_B CHR, OKL_LEASE_QUOTES_B LQ, FND_LOOKUP_VALUES FND_VAL, FND_LOOKUP_VALUES LKP_QT_STAT WHERE LQ.ID = :P_LQ_ID AND LQ.PARENT_OBJECT_ID = LEASEAPP.ID AND LEASEAPP.PROSPECT_ID = HZP.PARTY_ID AND LEASEAPP.PROGRAM_AGREEMENT_ID = CHR.ID (+) AND FND_VAL.LOOKUP_CODE = LQ.PRICING_METHOD AND FND_VAL.LOOKUP_TYPE = 'OKL_QUOTE_PRICING_METHOD' AND FND_VAL.LANGUAGE = USERENV('LANG') AND LKP_QT_STAT.LOOKUP_CODE = LQ.STATUS AND LKP_QT_STAT.LOOKUP_TYPE = 'OKL_LEASE_QUOTE_STATUS' AND LKP_QT_STAT.LANGUAGE = USERENV('LANG') Y OKL OKLGENPAYSCHE AR OKL تكوين جدول سداد عرض الأسعار Imported from BI Publisher Application: إدارة الإيجار Source: تكوين جدول سداد عرض الأسعار Short Name: OKLGENPAYSCHE DB package: D OKL Zahlungsplan für Angebote generieren Imported from BI Publisher Application: Lease and Finance Management Source: Zahlungsplan für Angebote generieren Short Name: OKLGENPAYSCHE DB package: E OKL Generar Programa de Pago de Oferta Imported from BI Publisher Description: Genera programas de pago de oferta Application: Leasing and Finance Management Source: Generar Programa de Pago de Oferta Short Name: OKLGENPAYSCHE DB package: F OKL Générer un échéancier de règlement de devis Imported from BI Publisher Application: Lease and Finance Management Source: Générer un échéancier de règlement de devis Short Name: OKLGENPAYSCHE DB package: I OKL Genera programmi di pagamenti preventivo Imported from BI Publisher Description: Genera i programmi di pagamento del preventivo. Application: Leasing and Finance Management Source: Genera programmi di pagamenti preventivo Short Name: OKLGENPAYSCHE DB package: JA OKL 見積支払予定の生成 Imported from BI Publisher Application: リースおよびファイナンス管理 Source: 見積支払予定の生成 Short Name: OKLGENPAYSCHE DB package: KO OKL 견적 지급 스케줄 생성 Imported from BI Publisher Description: 견적 지급 스케줄을 생성합니다. Application: Lease and Finance Management Source: 견적 지급 스케줄 생성 Short Name: OKLGENPAYSCHE DB package: PTB OKL Gerar a Programação de Pagamento da Cota Imported from BI Publisher Description: Gera a Programação de Pagamento da Cota Application: Lease and Finance Management Source: Gerar a Programação de Pagamento da Cota Short Name: OKLGENPAYSCHE DB package: RU OKL Создание графика платежей для котировки Imported from BI Publisher Application: Управление лизингом и финансами Source: Создание графика платежей для котировки Short Name: OKLGENPAYSCHE DB package: S OKL Generera betalningsplan för offert Imported from BI Publisher Description: Genererar betalningsplan för offert Application: Hyres- och ekonomihantering Source: Generera betalningsplan för offert Short Name: OKLGENPAYSCHE DB package: TR OKL Fiyat Teklifi Ödeme Çizelgesi Oluştur Imported from BI Publisher Description: Teklif Ödeme Çizelgesi Oluşturur Application: Kiralama ve Finans Yönetimi Source: Fiyat Teklifi Ödeme Çizelgesi Oluştur Short Name: OKLGENPAYSCHE DB package: US OKL Generate Quote Payment Schedule Imported from BI Publisher Description: Generates Quote Payment Schedule Application: Lease and Finance Management Source: Generate Quote Payment Schedule Short Name: OKLGENPAYSCHE DB package: ZHS OKL 生成报价付款分摊计划 Imported from BI Publisher Application: Oracle Lease and Finance Management Source: 生成报价付款分摊计划 Short Name: OKLGENPAYSCHE DB package: BI Publisher :operating_unit :p_lq_id 1 -20 :p_leasequo_yn Char SELECT 'Y' FROM DUAL WHERE :$flex$.p_qte_type= 'LEASEQUO' AR p_leasequo_yn المعامل الافتراضي للإشارة إلى ما إذا كان النوع هو عرض أسعار الإيجار D p_leasequo_yn Dummy-Parameter zur Angabe, ob es sich um die Art "Leasingangebot" handelt E p_leasequo_yn Parámetro ficticio para indicar si el tipo es una oferta de leasing F p_leasequo_yn Paramètre fictif indiquant si le type est un devis de crédit-bail I p_leasequo_yn Parametro fittizio per indicare se il tipo è un preventivo di leasing. JA p_leasequo_yn タイプがリース見積であるかどうかを示すダミー・パラメータ KO p_leasequo_yn 유형이 리스 견적인지 여부를 나타내는 Dummy 매개변수 PTB p_leasequo_yn Parâmetros Fictício para indicar se o tipo é cota de leasing RU p_leasequo_yn Фиктивный параметр для указания типа "Котировка лизинга" S p_leasequo_yn Dummy-parameter för att ange om typen är Hyresoffert. TR p_leasequo_yn Tipin kiralama teklifi olup olmadığını belirten Sözde Parametre US p_leasequo_yn Dummy Parameter for indicating if type is lease quote ZHS p_leasequo_yn 用于指明类型是否为租赁报价的虚拟参数 2 -10 :p_leaseapp_yn Char SELECT 'Y' FROM DUAL WHERE :$flex$.p_qte_type= 'LEASEAPP' AR p_leaseapp_yn المعامل الافتراضي للإشارة إلى ما إذا كان النوع هو تطبيق D p_leaseapp_yn Dummy-Parameter zur Angabe, ob es sich um die Art "Leasingantrag" handelt E p_leaseapp_yn Parámetro ficticio para indicar si el tipo es una solicitud de leasing F p_leaseapp_yn Paramètre fictif indiquant si le type est une demande de crédit-bail I p_leaseapp_yn Parametro fittizio per indicare se il tipo è una domanda di leasing. JA p_leaseapp_yn タイプがリース申請であるかどうかを示すダミー・パラメータ KO p_leaseapp_yn 유형이 리스 신청인지 여부를 나타내는 Dummy 매개변수 PTB p_leaseapp_yn Parâmetro Fictício para indicar se o tipo é aplicação de leasing RU p_leaseapp_yn Фиктивный параметр для указания типа "Заявка на лизинг" S p_leaseapp_yn Dummy-parameter för att ange om typen är Hyresansökan. TR p_leaseapp_yn Tipin kiralama başvurusu olup olmadığını belirten Sözde Parametre US p_leaseapp_yn Dummy Parameter for indicating if type is lease application ZHS p_leaseapp_yn 用于指明类型是否为租赁申请的虚拟参数 3 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 4 10 :p_qte_type LOV Oracle OKL_PAYMENT_QUOTE_TYPE Y select lookup_code id, meaning value, null description from fnd_lookup_values where lookup_type='OKL_PAYMENT_QUOTE_TYPE' and language=userenv('LANG') order by value,description AR p_qte_type نوع عرض الأسعار D p_qte_type Angebotsart E p_qte_type Tipo de Oferta F p_qte_type Type de devis I p_qte_type Tipo di preventivo JA p_qte_type 見積タイプ KO p_qte_type 견적 유형 PTB p_qte_type Tipo de Cota RU p_qte_type Тип котировки S p_qte_type Offerttyp TR p_qte_type Teklif Tipi US p_qte_type Quote Type ZHS p_qte_type 报价类型 5 20 :p_lq_id LOV Oracle OKL_LEASE_QUOTES Y select id id, reference_number value, reference_number description from okl_lease_quotes_b where :$flex$.p_leasequo_yn='Y' order by value,description AR رقم عرض أسعار الإيجار رقم عرض أسعار الإيجار D Leasingangebotsnummer Leasingangebotsnummer E Número de Oferta de Leasing Número de Oferta de Leasing F Numéro de devis de crédit-bail Numéro de devis de crédit-bail I Numero preventivo leasing Numero di preventivo leasing JA リース見積番号 リース見積番号 KO 리스 견적 번호 리스 견적 번호 PTB Número da Cota de Leasing Número da Cota de Leasing RU Номер предложения лизинга Номер предложения лизинга S Nummer på hyresoffert Nummer på hyresoffert TR Kiralama Teklif Numarası Kiralama Teklif Numarası US Lease Quote Number Lease Quote Number ZHS 租赁报价编号 租赁报价编号 6 30 :p_la_id LOV Oracle OKL_LEASE_APPLICATIONS Y select id id, reference_number value, reference_number description from okl_lease_applications_b where :$flex$.p_leaseapp_yn='Y' order by value,description AR رقم تطبيق الإيجار رقم تطبيق الإيجار D Leasingantragsnummer Leasingantragsnummer E Número de Solicitud de Leasing Número de Solicitud de Leasing F Numéro de demande de crédit-bail Numéro de demande de crédit-bail I Numero domanda di leasing Numero della domanda di leasing JA リース申請番号 リース申請番号 KO 리스 신청 번호 리스 신청 번호 PTB Número da Aplicação de Leasing Número da Aplicação de Leasing RU Номер заявки на лизинг Номер заявки на лизинг S Nummer på hyresansökan Nummer på hyresansökan TR Kiralama Uygulaması Numarası Kiralama Uygulaması Numarası US Lease Application Number Lease Application Number ZHS 租赁申请编号 租赁申请编号 :$flex$.p_leaseapp_yn p_leaseapp_yn Lease Application Number :$flex$.p_leasequo_yn p_leasequo_yn Lease Quote Number :$flex$.p_qte_type p_qte_type p_leaseapp_yn :$flex$.p_qte_type p_qte_type p_leasequo_yn