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）限制的操作单元。 EEE75CEB4AD86AD8E05362FB09051F8B select x.* from ( select * from ( SELECT bal.ecc_spec_id AS ecc_spec_id, bal.record_type AS record_type, bal.language AS language, GREATEST( NVL( pp.last_update_date, to_date('01-01-1990', 'DD-MM-YYYY')) , NVL( pt.last_update_date, to_date('01-01-1990', 'DD-MM-YYYY')) , NVL( bal.last_update_date, to_date('01-01-1990', 'DD-MM-YYYY')) ) 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, bal.inv_org_id AS inv_ord_id, bal.inv_org_name AS inv_org_name, bal.item_id AS item_id, bal.item_number AS item_number, bal.item_description AS item_description, bal.inv_sub_code AS item_sub_code, bal.inv_sup_locator AS inv_sup_locator, bal.inv_primary_uom AS inv_primary_uom, bal.inv_onhand_quantity AS inv_onhand_quantity, ppp.costing_group_id AS inv_cost_group_id, grp.cost_group AS inv_cost_group_name, grp.description AS inv_cost_group_description FROM pa_projects_all pp, pa_tasks pt, ( SELECT 'PROJ_INV_BAL' || '-' || loc.project_id || '-' || NVL( TO_CHAR(loc.task_id), 'NO_TASK' ) || '-' || qty.organization_id || '-' || qty.inventory_item_id || '-' || phyloc.concatenated_segments || '-' || item.primary_uom_code AS ecc_spec_id, 'PROJ_INV_BAL' AS record_type, org.language AS language, MAX( GREATEST( NVL( qty.last_update_date, to_date('01-01-1990', 'DD-MM-YYYY')) , NVL( loc.last_update_date, to_date('01-01-1990', 'DD-MM-YYYY')) , NVL( item.last_update_date, to_date('01-01-1990', 'DD-MM-YYYY')) , NVL( org.last_update_date, to_date('01-01-1990', 'DD-MM-YYYY')) , NVL( phyloc.last_update_date, to_date('01-01-1990', 'DD-MM-YYYY')) ) ) AS last_update_date, loc.project_id AS project_id, loc.task_id AS task_id, qty.organization_id AS inv_org_id, org.name AS inv_org_name, qty.inventory_item_id AS item_id, item.concatenated_segments AS item_number, msitl.description AS item_description, qty.subinventory_code AS inv_sub_code, DECODE( mp.project_reference_enabled, NULL , phyloc.concatenated_segments, 2, phyloc.concatenated_segments, 1, inv_project.get_pjm_locsegs(phyloc.concatenated_segments ) ) AS inv_sup_locator, item.primary_uom_code AS inv_primary_uom, NVL( SUM( qty.transaction_quantity ) , 0 ) AS inv_onhand_quantity FROM pjm_project_parameters para, mtl_onhand_quantities_detail qty, mtl_item_locations loc, mtl_system_items_kfv item, mtl_system_items_tl msitl, hr_all_organization_units_tl org, mtl_parameters mp, mtl_item_locations_kfv phyloc WHERE loc.organization_id = qty.organization_id AND loc.organization_id = mp.organization_id AND loc.inventory_location_id = qty.locator_id AND item.inventory_item_id = qty.inventory_item_id AND item.organization_id = qty.organization_id AND org.organization_id = qty.organization_id AND msitl.inventory_item_id = item.inventory_item_id AND msitl.organization_id = item.organization_id AND msitl.language = org.language AND phyloc.organization_id = loc.organization_id AND phyloc.inventory_location_id = NVL( loc.inventory_location_id, loc.physical_location_id ) and loc.project_id = para.project_id and loc.organization_id = para.organization_id GROUP BY loc.project_id, loc.task_id, qty.organization_id, org.name, qty.inventory_item_id, item.concatenated_segments, msitl.description, qty.subinventory_code, mp.project_reference_enabled, phyloc.concatenated_segments, item.primary_uom_code, org.language ) bal, pjm_project_parameters ppp, cst_cost_groups grp 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 = bal.project_id AND pt.task_id(+) = bal.task_id AND ppp.project_id(+) = pp.project_id AND ppp.organization_id = bal.inv_org_id AND grp.cost_group_id(+) = ppp.costing_group_id AND language IN ('US') ) PIVOT( MAX(inv_org_name) AS inv_org_name, MAX(item_description) AS item_description FOR LANGUAGE IN ('US' "US")) ) x where 2=2 Y AR ECC تصنيع المشروعات, الرصيد المتوافر Imported from Enterprise Command Center Description: رصيد المخزون لتصنيع المشروعات Dataset Key: pjm-inv-balance Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues D ECC Project Manufacturing, Lagerbestand Imported from Enterprise Command Center Description: Project Manufacturing - Lagerbestand Dataset Key: pjm-inv-balance Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues E ECC Project Manufacturing, Saldo de Cantidad Física Actual Imported from Enterprise Command Center Description: Saldo de inventario de fabricación de proyecto Dataset Key: pjm-inv-balance Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues F ECC Project Manufacturing, Solde réel Imported from Enterprise Command Center Description: Solde du stock Oracle Project Manufacturing Dataset Key: pjm-inv-balance Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues I ECC Project Manufacturing, Saldo quantità esist. Imported from Enterprise Command Center Description: Saldo magazzino di Project Manufacturing Dataset Key: pjm-inv-balance 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-inv-balance 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-inv-balance 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-inv-balance Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues S ECC Projekttillverkning, Lagersaldo Imported from Enterprise Command Center Description: Projekttillverkning: Lagersaldo Dataset Key: pjm-inv-balance Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues TR ECC Proje Üretimi, Eldeki Bakiye Imported from Enterprise Command Center Description: Proje Üretimi Envanter Bakiyesi Dataset Key: pjm-inv-balance Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues US ECC Project Manufacturing, On-Hand Balance Imported from Enterprise Command Center Description: Project Manufacturing Inventory Balance Dataset Key: pjm-inv-balance 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-inv-balance 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