ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4710B51A9E05362FB09050512Y SELECT OTMT.TP_MEASUREMENT_TYPE_ID MEASUREMENT_TYPE_ID2, OTMT.UNIT UNIT, ' ' BUDGET_ITEM_NAME, LKPS2.MEANING EMP_CATEGORY, SUM(Decode(OTMT.UNIT,'M',hr_currency_pkg.convert_amount( OTPV.BUDGET_CURRENCY, :P_CURRENCY, OTPV.PERIOD_START_DATE, PBVA.VALUE, :C_CURR_CONV_TYPE), PBVA.VALUE) ) BUDGET FROM OTA_TP_MEASUREMENT_TYPES OTMT, FND_COMMON_LOOKUPS LKPS2, PER_BUDGETS PB, PER_BUDGET_VERSIONS PBV, PER_BUDGET_ELEMENTS PBE, PER_BUDGET_VALUES PBVA, OTA_TRAINING_PLANS_V OTPV WHERE :MEASUREMENT_LEVEL = 'PLAN' AND PB.UNIT = OTMT.TP_MEASUREMENT_CODE AND PB.BUSINESS_GROUP_ID = :P_BUSINESS_GROUP_ID AND PB.BUDGET_TYPE_CODE = 'OTA_BUDGET' AND PBV.BUDGET_ID (+) = PB.BUDGET_ID AND PBE.BUDGET_VERSION_ID (+) = PBV.BUDGET_VERSION_ID AND PBE.TRAINING_PLAN_ID = :P_TRAINING_PLAN_ID AND PBE.TRAINING_PLAN_MEMBER_ID IS NULL AND PBE.EVENT_ID IS NULL AND PBVA.BUDGET_ELEMENT_ID (+) = PBE.BUDGET_ELEMENT_ID AND LKPS2.LOOKUP_TYPE (+) = 'FR_EMPLOYEE_CATEGORY' AND LKPS2.APPLICATION_ID (+) = 800 AND LKPS2.LOOKUP_CODE (+) = PBVA.BUDGET_INFORMATION1 AND OTPV.TRAINING_PLAN_ID (+) = :P_TRAINING_PLAN_ID and OTMT.TP_MEASUREMENT_TYPE_ID=:MEASUREMENT_TYPE_ID GROUP BY OTMT.TP_MEASUREMENT_TYPE_ID, OTMT.UNIT, LKPS2.MEANING UNION ( SELECT OTMT.TP_MEASUREMENT_TYPE_ID MEASUREMENT_TYPE_ID2, OTMT.UNIT UNIT, OAD_TL.NAME BUDGET_ITEM_NAME, LKPS2.MEANING EMP_CATEGORY, SUM(Decode(OTMT.UNIT,'M', hr_currency_pkg.convert_amount( OTPV.BUDGET_CURRENCY, :P_CURRENCY, OTPV.PERIOD_START_DATE, PBVA.VALUE, :C_CURR_CONV_TYPE), PBVA.VALUE) ) BUDGET FROM OTA_TP_MEASUREMENT_TYPES OTMT, PER_BUDGETS PB, PER_BUDGET_VERSIONS PBV, PER_BUDGET_ELEMENTS PBE, PER_BUDGET_VALUES PBVA, OTA_TRAINING_PLAN_MEMBERS OTPM, OTA_ACTIVITY_DEFINITIONS OAD, OTA_ACTIVITY_DEFINITIONS_TL OAD_TL, FND_COMMON_LOOKUPS LKPS2, OTA_TRAINING_PLANS_V OTPV WHERE OAD.ACTIVITY_ID = OAD_TL.ACTIVITY_ID(+) AND OAD_TL.LANGUAGE(+) = USERENV('LANG') AND :MEASUREMENT_LEVEL = 'ACTIVITY' AND PB.UNIT = OTMT.TP_MEASUREMENT_CODE AND PB.BUSINESS_GROUP_ID = :P_BUSINESS_GROUP_ID AND PB.BUDGET_TYPE_CODE = 'OTA_BUDGET' AND PBV.BUDGET_ID (+) = PB.BUDGET_ID AND PBE.BUDGET_VERSION_ID (+) = PBV.BUDGET_VERSION_ID AND PBE.TRAINING_PLAN_ID = :P_TRAINING_PLAN_ID AND PBE.TRAINING_PLAN_MEMBER_ID IS NOT NULL AND PBE.EVENT_ID IS NULL AND OTPM.TRAINING_PLAN_MEMBER_ID (+) = PBE.TRAINING_PLAN_MEMBER_ID AND OTPM.MEMBER_STATUS_TYPE_ID <> 'CANCELLED' AND OTPM.ACTIVITY_VERSION_ID IS NULL AND OTPM.ACTIVITY_DEFINITION_ID IS NOT NULL AND OAD.ACTIVITY_ID (+) = OTPM.ACTIVITY_DEFINITION_ID AND PBVA.BUDGET_ELEMENT_ID (+) = PBE.BUDGET_ELEMENT_ID AND LKPS2.LOOKUP_TYPE (+) = 'FR_EMPLOYEE_CATEGORY' AND LKPS2.APPLICATION_ID (+) = 800 AND LKPS2.LOOKUP_CODE (+) = PBVA.BUDGET_INFORMATION1 AND OTPV.TRAINING_PLAN_ID = :P_TRAINING_PLAN_ID GROUP BY OTMT.TP_MEASUREMENT_TYPE_ID, OTMT.UNIT, OAD_TL.NAME, LKPS2.MEANING UNION SELECT OTMT.TP_MEASUREMENT_TYPE_ID MEASUREMENT_TYPE_ID2, OTMT.UNIT UNIT, OAV_TL.VERSION_NAME BUDGET_ITEM_NAME, LKPS2.MEANING EMP_CATEGORY, SUM(Decode(OTMT.UNIT,'M', hr_currency_pkg.convert_amount( OTPV.BUDGET_CURRENCY, :P_CURRENCY, OTPV.PERIOD_START_DATE, PBVA.VALUE, :C_CURR_CONV_TYPE), PBVA.VALUE) ) BUDGET FROM OTA_TP_MEASUREMENT_TYPES OTMT, PER_BUDGETS PB, PER_BUDGET_VERSIONS PBV, PER_BUDGET_ELEMENTS PBE, OTA_TRAINING_PLAN_MEMBERS OTPM, OTA_ACTIVITY_VERSIONS OAV, OTA_ACTIVITY_VERSIONS_TL OAV_TL, PER_BUDGET_VALUES PBVA, FND_COMMON_LOOKUPS LKPS2, OTA_TRAINING_PLANS_V OTPV WHERE OAV.ACTIVITY_VERSION_ID = OAV_TL.ACTIVITY_VERSION_ID(+) AND OAV_TL.LANGUAGE(+) = USERENV('LANG') AND :MEASUREMENT_LEVEL = 'ACTIVITY' AND PB.UNIT = OTMT.TP_MEASUREMENT_CODE AND PB.BUSINESS_GROUP_ID = :P_BUSINESS_GROUP_ID AND PB.BUDGET_TYPE_CODE = 'OTA_BUDGET' AND PBV.BUDGET_ID (+) = PB.BUDGET_ID AND PBE.BUDGET_VERSION_ID (+) = PBV.BUDGET_VERSION_ID AND PBE.TRAINING_PLAN_ID = :P_TRAINING_PLAN_ID AND PBE.TRAINING_PLAN_MEMBER_ID IS NOT NULL AND PBE.EVENT_ID IS NULL AND OTPM.TRAINING_PLAN_MEMBER_ID (+) = PBE.TRAINING_PLAN_MEMBER_ID AND OTPM.MEMBER_STATUS_TYPE_ID <> 'CANCELLED' AND OTPM.ACTIVITY_VERSION_ID IS NOT NULL AND OTPM.ACTIVITY_DEFINITION_ID IS NULL AND OAV.ACTIVITY_VERSION_ID (+) = OTPM.ACTIVITY_VERSION_ID AND PBVA.BUDGET_ELEMENT_ID (+) = PBE.BUDGET_ELEMENT_ID AND LKPS2.LOOKUP_TYPE (+) = 'FR_EMPLOYEE_CATEGORY' AND LKPS2.APPLICATION_ID (+) = 800 AND LKPS2.LOOKUP_CODE (+) = PBVA.BUDGET_INFORMATION1 AND OTPV.TRAINING_PLAN_ID = :P_TRAINING_PLAN_ID GROUP BY OTMT.TP_MEASUREMENT_TYPE_ID, OTMT.UNIT, OAV_TL.VERSION_NAME, LKPS2.MEANING ) UNION ( SELECT OTMT.TP_MEASUREMENT_TYPE_ID MEASUREMENT_TYPE_ID2, OTMT.UNIT UNIT, OE_TL.TITLE BUDGET_ITEM_NAME, LKPS2.MEANING EMP_CATEGORY, SUM(Decode(OTMT.UNIT,'M', hr_currency_pkg.convert_amount( OTPV.BUDGET_CURRENCY, :P_CURRENCY, OTPV.PERIOD_START_DATE, PBVA.VALUE, :C_CURR_CONV_TYPE), PBVA.VALUE) ) BUDGET FROM OTA_TP_MEASUREMENT_TYPES OTMT, PER_BUDGETS PB, PER_BUDGET_VERSIONS PBV, PER_BUDGET_ELEMENTS PBE, OTA_EVENTS OE, OTA_EVENTS_TL OE_TL, OTA_TRAINING_PLAN_MEMBERS OTPM, PER_BUDGET_VALUES PBVA, FND_COMMON_LOOKUPS LKPS2, OTA_TRAINING_PLANS_V OTPV WHERE OE.EVENT_ID = OE_TL.EVENT_ID(+) AND OE_TL.LANGUAGE(+) = USERENV('LANG') AND :MEASUREMENT_LEVEL = 'EVENT' AND PB.UNIT = OTMT.TP_MEASUREMENT_CODE AND PB.BUSINESS_GROUP_ID = :P_BUSINESS_GROUP_ID AND PB.BUDGET_TYPE_CODE = 'OTA_BUDGET' AND PBV.BUDGET_ID = PB.BUDGET_ID AND PBE.BUDGET_VERSION_ID = PBV.BUDGET_VERSION_ID AND PBE.TRAINING_PLAN_ID = :P_TRAINING_PLAN_ID AND PBE.TRAINING_PLAN_MEMBER_ID IS NOT NULL AND PBE.EVENT_ID IS NOT NULL AND OTPM.TRAINING_PLAN_MEMBER_ID (+) = PBE.TRAINING_PLAN_MEMBER_ID AND OTPM.MEMBER_STATUS_TYPE_ID <> 'CANCELLED' AND OE.EVENT_ID = PBE.EVENT_ID AND PBVA.BUDGET_ELEMENT_ID (+) = PBE.BUDGET_ELEMENT_ID AND LKPS2.LOOKUP_TYPE (+) = 'FR_EMPLOYEE_CATEGORY' AND LKPS2.APPLICATION_ID (+) = 800 AND LKPS2.LOOKUP_CODE (+) = PBVA.BUDGET_INFORMATION1 AND OTPV.TRAINING_PLAN_ID = :P_TRAINING_PLAN_ID GROUP BY OTMT.TP_MEASUREMENT_TYPE_ID, OTMT.UNIT, OE_TL.TITLE, LKPS2.MEANING ) OTA OTAFRBCR_XML AR OTA تقرير تسوية الموازنة والتكاليف (بتنسيق XML) Imported from BI Publisher Description: تقرير تسوية الموازنة والتكاليف Application: إدارة التعليم Source: تقرير تسوية الموازنة والتكاليف (بتنسيق XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG D OTA Budgets und Kosten abstimmen Imported from BI Publisher Description: Auswertung "Budgets und Kosten abstimmen" Application: Learning Management Source: Budgets und Kosten abstimmen (XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG E OTA Conciliación de Presupuesto y Coste Imported from BI Publisher Description: Informe de conciliación de presupuesto y coste Application: Learning Management Source: Conciliación de Presupuesto y Coste (XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG F OTA Etat de rapprochement du budget et des coûts Imported from BI Publisher Description: Etat de rapprochement du budget et des coûts Application: Learning Management Source: Etat de rapprochement du budget et des coûts (XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG I OTA Rapporto Quadratura costi e budget Imported from BI Publisher Description: Rapporto Quadratura costi e budget Application: Learning Management Source: Rapporto Quadratura costi e budget (XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG JA OTA 予算計画と原価の消込レポート Imported from BI Publisher Description: 予算計画と原価の消込レポート Application: Learning Management Source: 予算計画と原価の消込レポート(XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG KO OTA 예산 및 비용 대사 보고서 Imported from BI Publisher Description: 예산 및 비용 대사 보고서 Application: Learning Management Source: 예산 및 비용 대사 보고서(XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG PTB OTA Relatório de Orçamento e Reconciliação de Custo Imported from BI Publisher Description: Relatório de Orçamento e Reconciliação de Custo Application: Learning Management Source: Relatório de Orçamento e Reconciliação de Custo (XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG RU OTA Отчет о выверке бюджета и затрат Imported from BI Publisher Description: Отчет о выверке бюджета и затрат Application: Управление обучением Source: Отчет о выверке бюджета и затрат (XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG S OTA Budget och kostnader - avstämningsrapport Imported from BI Publisher Description: Budget och kostnader - avstämningsrapport Application: Learning Management Source: Budget och kostnader - avstämningsrapport (XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG TR OTA Bütçe ve Maliyet Mutabakat Raporu Imported from BI Publisher Description: Bütçe ve Maliyet Mutabakat Raporu Application: Eğitim Yönetimi Source: Bütçe ve Maliyet Mutabakat Raporu (XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG US OTA Budget and Cost Reconciliation Imported from BI Publisher Description: Budget and Cost Reconciliation Report Application: Learning Management Source: Budget and Cost Reconciliation Report (XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG ZHS OTA 预算和成本调节报表 Imported from BI Publisher Description: 预算和成本调节报表 Application: Oracle Learning Management Source: 预算和成本调节报表 (XML) Short Name: OTAFRBCR_XML DB package: OTA_OTAFRBCR_XMLP_PKG BI Publisher :c_business_group_name :c_curr_conv_type :c_rollup_level :c_training_plan_name :measurement_level :measurement_type_id :p_business_group_id :p_conc_request_id :p_currency :p_report_title :p_rollup :p_training_plan_id 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y AR مجموعة الأعمال معرف مجموعة الأعمال D Unternehmensgruppe Kennung Unternehmensgruppe E Grupo de Trabajo Identificador de grupo de trabajo F Entité professionnelle ID entité professionnelle I Business group Id del business group JA ビジネス・グループ ビジネス・グループID KO 업무 그룹 업무 그룹 ID PTB Grupo Funcional ID do Grupo Funcional RU Бизнес-группа Идентификатор бизнес-группы S Verksamhetsgrupp Id för verksamhetsgrupp TR İş Grubu İş Grubu No US Business Group Business Group ID ZHS 业务组 业务组标识 2 10 :p_training_plan_id LOV Oracle OTA_TRAINING_PLANS Y select otp.training_plan_id id, otp.name value, null description from ota_training_plans otp,hr_all_organization_units org,hr_lookups lkp,per_time_periods ptp where otp.business_group_id=fnd_global.per_business_group_id and otp.plan_status_type_id=lkp.lookup_code and lkp.lookup_type='OTA_PLAN_USER_STATUS_TYPE' and otp.time_period_id=ptp.time_period_id and otp.organization_id=org.organization_id(+) order by otp.name,org.name Y AR اسم خطة التدريب معرف خطة التدريب D Bezeichnung Schulungsplan Kennung Schulungsplan E Nombre de Plan de Formación Identificador de plan de formación F Nom du plan de formation ID plan de formation I Nome piano di formazione Id del piano di formazione JA 研修プラン名 研修プランID KO 교육 계획명 교육 계획 ID PTB Nome do Plano de Treinamento ID do Plano de Treinamento RU Имя учебного плана Идентификатор учебного плана S Namn på utbildningsplan Utbildningsplans-id TR Eğitim Planı Adı Eğitim Planı No US Training Plan Name Training Plan ID ZHS 培训计划名称 培训计划标识 3 20 :p_currency LOV Oracle HR_CURRENCIES Y select currency_code id, currency_code value, name description from fnd_currencies_vl where enabled_flag='Y' and currency_flag='Y' and sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate) order by name Y AR العملة العملة D Währung Währung E Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种 4 30 :p_rollup LOV Oracle OTA_TP_REPORT_LEVEL Y select lookup_code id, meaning value, null description from fnd_common_lookups where application_id=800 and lookup_type='TP_REPORT_LEVEL' order by meaning select meaning from fnd_common_lookups where application_id = 800 and lookup_type = 'TP_REPORT_LEVEL' and lookup_code = 'PLAN' Y AR مستوى حساب التكلفة مستوى حساب التكلفة D Zusammenfassungsebene Zusammenfassungsebene E Nivel de Acumulación Nivel de acumulación F Niveau de remontée Niveau de remontée I Livello di aggregazione Livello di aggregazione JA 積上レベル 積上レベル KO 적상 레벨 적상 레벨 PTB Nível de Totalização Nível de Totalização RU Уровень сведения Уровень сведения S Summeringsnivå Summeringsnivå TR Özet Düzeyi Özet Düzeyi US Rollup Level Rollup Level ZHS 累计层 累计层