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）限制的操作单元。 EEE75CEB4AC26AD8E05362FB09051F8B select x.* from ( select * from ( SELECT /*+ leading(ppp pp) index(pp PA_PROJECTS_U1) */ 'PROJ_CMT-' || pp.project_id || '-' || NVL( TO_CHAR(pt.task_id), 'NO_TASK' ) || '-' || pct.cmt_line_id AS ecc_spec_id, GREATEST( pp.last_update_date, NVL( pt.last_update_date, pp.last_update_date ) , pct.last_update_date, ptad.last_update_date, NVL( fca.last_update_date, pp.last_update_date ) , NVL( fcr.last_update_date, pp.last_update_date ) , NVL( fcp.last_update_date, pp.last_update_date ) ) AS ecc_last_update_date, pp.project_id AS project_id, pp.segment1 AS project_number, pp.org_id AS org_id, pt.task_id AS task_id, pt.task_number AS task_number, pct.cmt_line_id AS cmt_line_id, pct.vendor_name AS supplier_name, pct.cmt_creation_date AS cmt_date, flv1.meaning AS cmt_type, pct.cmt_number AS cmt_number, pct.cmt_line_number AS cmt_line_number, pct.tot_cmt_raw_cost AS cmt_amount, pct.tot_cmt_burdened_cost AS cmt_burdened_cost, pct.cmt_approved_date AS cmt_approved_date, pct.cmt_promised_date AS cmt_promised_date, pct.cmt_need_by_date AS cmt_need_by_date, pct.description AS description, pct.expenditure_type AS exp_type, hou.name AS exp_org, DECODE( pct.cmt_approved_flag, 'y', 'yes', 'n', 'no' ) AS cmt_approved, pct.tot_cmt_quantity AS cmt_quantity, pct.unit_of_measure AS uom, pct.cmt_requestor_name AS cmt_requestor, pct.cmt_buyer_name AS cmt_buyer, flv2.meaning AS cmt_transaction_source, pct.denom_currency_code AS denom_currency_code, pct.denom_raw_cost AS denom_raw_cost, pct.denom_burdened_cost AS denom_burdened_cost, pct.acct_currency_code AS acct_currency_code, pct.acct_raw_cost AS acct_raw_cost, pct.acct_burdened_cost AS acct_burdened_cost, pct.acct_rate_date AS acct_rate_date, pct.acct_rate_type AS acct_rate_type, ROUND( pct.acct_exchange_rate, NVL( fca.extended_precision, NVL( fca.precision, 5 ) ) ) AS acct_exchange_rate, pct.receipt_currency_code AS receipt_currency_code, TO_CHAR(pct.receipt_currency_amount, fnd_currency_cache.get_format_mask(pct.receipt_currency_code, 40)) AS receipt_currency_amount, ROUND( pct.receipt_exchange_rate, NVL( fcr.extended_precision, NVL( fcr.precision, 5 ) ) ) AS receipt_exchange_rate, pct.project_currency_code AS project_currency_code, pct.project_rate_date AS project_rate_date, pct.project_rate_type AS project_rate_type, ROUND( pct.project_exchange_rate, NVL( fcp.extended_precision, NVL( fcp.precision, 5 ) ) ) AS project_exchange_rate, fm.message_text AS cmt_rejection_code, hou.language AS language FROM pa_projects_all pp, pa_tasks pt, pa_commitment_txns pct, pa_txn_accum_details ptad, hr_all_organization_units_tl hou, fnd_lookup_values flv1, fnd_lookup_values flv2, fnd_currencies fca, fnd_currencies fcr, fnd_currencies fcp, fnd_new_messages fm , (SELECT DISTINCT project_id FROM pjm_project_parameters) ppp WHERE pp.start_date >= NVL(to_date('2021/12/12','RRRR/MM/DD HH24:MI:SS'), pp.start_date) AND pp.project_type <> 'AWARD_PROJECT' AND pp.template_flag = 'N' AND pp.project_id = ppp.project_id AND pp.project_id = pct.project_id AND pt.task_id(+) = pct.task_id AND ptad.line_type = 'M' AND ptad.cmt_line_id = pct.cmt_line_id AND hou.organization_id = pct.organization_id AND flv1.view_application_id =275 AND flv1.security_group_id =0 AND flv1.lookup_type = 'COMMITMENT LINE TYPE' AND flv1.lookup_code = pct.line_type AND flv1.language = hou.language AND flv2.view_application_id =275 AND flv2.security_group_id =0 AND flv2.lookup_type = 'COMMITMENT TXN SOURCE' AND flv2.lookup_code = pct.transaction_source AND flv2.language = hou.language AND fca.currency_code(+) = pct.acct_currency_code AND fcr.currency_code(+) = pct.receipt_currency_code AND fcp.currency_code(+) = pct.project_currency_code AND fm.application_id(+) =275 AND fm.message_name(+) = pct.cmt_rejection_code AND (fm.language_code IS NULL OR fm.language_code = hou.language) AND hou.language IN ('US') AND fm.language_code (+) IN ('US') ) PIVOT( MAX(cmt_type) AS cmt_type, MAX(exp_org) AS exp_org, MAX(cmt_transaction_source) AS cmt_transaction_source, MAX(cmt_rejection_code) AS cmt_rejection_code FOR LANGUAGE IN ('US' "US")) ) x where 2=2 Y AR ECC تصنيع المشروعات, الارتباطات Imported from Enterprise Command Center Description: ارتباطات تصنيع المشروعات Dataset Key: pjm-commitments Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues D ECC Project Manufacturing, Verpflichtungen Imported from Enterprise Command Center Description: Project Manufacturing - Verpflichtungen Dataset Key: pjm-commitments Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues E ECC Project Manufacturing, Compromisos Imported from Enterprise Command Center Description: Compromisos de fabricación de proyecto Dataset Key: pjm-commitments Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues F ECC Project Manufacturing, Engagements Imported from Enterprise Command Center Description: Engagements Oracle Project Manufacturing Dataset Key: pjm-commitments Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues I ECC Project Manufacturing, Impegni Imported from Enterprise Command Center Description: Impegni Project Manufacturing Dataset Key: pjm-commitments Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues JA ECC プロジェクト製造, 取引約定 Imported from Enterprise Command Center Description: プロジェクト製造取引約定 Dataset Key: pjm-commitments Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues KO ECC Project Manufacturing, 약정 Imported from Enterprise Command Center Description: Project Manufacturing 약정 Dataset Key: pjm-commitments Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues RU ECC Производство по проектам, Обязательства Imported from Enterprise Command Center Description: Обязательства в Производстве по проектам Dataset Key: pjm-commitments Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues S ECC Projekttillverkning, Åtaganden Imported from Enterprise Command Center Description: Projekttillverkning: Reserveringar Dataset Key: pjm-commitments Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues TR ECC Proje Üretimi, Taahhütler Imported from Enterprise Command Center Description: Proje Üretim Taahhütleri Dataset Key: pjm-commitments Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues US ECC Project Manufacturing, Commitments Imported from Enterprise Command Center Description: Project Manufacturing Commitments Dataset Key: pjm-commitments Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues ZHS ECC Project Manufacturing, 承付款 Imported from Enterprise Command Center Description: 项目制造承付款 Dataset Key: pjm-commitments Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues Enterprise Command Center 1 10 2=2 x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where 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 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) US Operating Unit