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）限制的操作单元。 EEE75CEB4ADD6AD8E05362FB09051F8BY select x.* from ( select * from ( SELECT /* BR */ 'PROJ_BR' || '-' || dist.project_id || '-' || NVL( TO_CHAR(dist.task_id), 'NO_TASK' ) || '-' || por.po_header_id || '-' || por.po_release_id || '-' || pol.line_num || '-' || poll.shipment_num || '-' || dist.distribution_num AS ecc_spec_id, 'PROJ_BR' AS record_type, b.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( poh.last_update_date, to_date('01-01-1990', 'DD-MM-YYYY')) , NVL( pol.last_update_date, to_date('01-01-1990', 'DD-MM-YYYY')) , NVL( poll.last_update_date, to_date('01-01-1990', 'DD-MM-YYYY')) , NVL( dist.last_update_date, to_date('01-01-1990', 'DD-MM-YYYY')) , NVL( por.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, por.po_header_id AS po_header_id, poh.segment1 AS po_number, t.type_name AS br_document_type, por.po_release_id AS br_release_id, por.release_num AS br_release_number, TO_CHAR(por.po_header_id)|| ',' ||TO_CHAR(por.po_release_id) AS ACTIVITY_ID, pol.line_num AS po_line_number, poll.shipment_num AS po_shipment_number, dist.distribution_num AS po_distribution_number, por.revision_num AS po_revision_number, por.revised_date AS po_revised_date, por.release_date AS br_release_date, por.printed_date AS br_printed_date, po_status_lkup.meaning AS po_status, brclosestatus_lkup.meaning AS br_closure_status, poh.vendor_id AS supplier_id, pv.vendor_name AS supplier_name, poh.vendor_contact_id AS supplier_contact_id, DECODE(pvc.last_name||', '||pvc.first_name, ', ', NULL, pvc.last_name||', '||pvc.first_name) AS supplier_contact_name, poh.vendor_site_id AS supplier_site_id, pvs.vendor_site_code AS supplier_site_name, poh.ship_to_location_id AS ship_to_location_id, hrl.location_code AS ship_to_location_name, shipvia_lkup.freight_code_tl AS ship_via, freight_lkup.meaning AS freight_terms, fob_lkup.meaning AS fob, por.agent_id AS po_agent_id, prf.full_name AS po_agent_name, poh.bill_to_location_id AS bill_to_location_id, hrl2.location_code AS bill_to_location_name, poh.terms_id AS terms_id, b.name AS payment_term, poh.currency_code AS currency, DECODE( pol.matching_basis, 'QUANTITY', dist.quantity_ordered * poll.price_override, 'AMOUNT', dist.amount_ordered ) AS po_dist_amount, SUBSTR( msi.segment1, 1, 40 ) AS item_number, NVL(msitl.description, pol.item_description) AS item_description, dist.end_item_unit_number AS end_item_unit_number FROM pa_projects_all pp, pa_tasks pt, po_releases_all por, po_headers_all poh, po_lines_all pol, po_line_locations_all poll, po_distributions_all dist, po_document_types_all_tl t, fnd_lookup_values po_status_lkup, fnd_lookup_values brclosestatus_lkup, po_vendors pv, po_vendor_contacts pvc, po_vendor_sites_all pvs, hr_locations_all_tl hrl, fnd_lookup_values freight_lkup, fnd_lookup_values fob_lkup, hr_locations_all_tl hrl2, per_all_people_f prf, ap_terms_tl b, mtl_system_items_b msi, mtl_system_items_tl msitl, org_freight_tl shipvia_lkup ,(select distinct project_id from pjm_project_parameters ) p3 WHERE pp.start_date >= NVL(to_date('2021/12/12','RRRR/MM/DD HH24:MI:SS'), pp.start_date) and pp.project_id = p3.project_id AND pp.project_type <> 'AWARD_PROJECT' AND pp.template_flag = 'N' AND pp.project_id = dist.project_id AND pt.task_id(+) = dist.task_id AND poh.po_header_id = por.po_header_id AND poh.type_lookup_code = 'BLANKET' AND por.approved_flag IN ('Y', 'R') AND dist.po_header_id = poh.po_header_id AND dist.po_release_id = por.po_release_id AND dist.po_line_id = pol.po_line_id AND poh.po_header_id = pol.po_header_id AND dist.line_location_id = poll.line_location_id AND pol.po_line_id = poll.po_line_id AND dist.org_id = pol.org_id AND pol.item_id IS NOT NULL AND t.document_type_code(+) = 'RELEASE' AND t.document_subtype(+) = por.release_type AND t.org_id(+) = por.org_id AND po_status_lkup.lookup_type = 'AUTHORIZATION STATUS' AND po_status_lkup.lookup_code = NVL( por.authorization_status, 'INCOMPLETE' ) AND po_status_lkup.view_application_id = 201 AND po_status_lkup.security_group_id = 0 AND brclosestatus_lkup.lookup_type = 'DOCUMENT STATE' AND brclosestatus_lkup.lookup_code = nvl(por.closed_code, 'OPEN') AND brclosestatus_lkup.view_application_id = 201 AND brclosestatus_lkup.security_group_id = 0 AND pv.vendor_id(+) = poh.vendor_id AND pvc.vendor_contact_id(+) = poh.vendor_contact_id AND pvc.vendor_site_id(+) = poh.vendor_site_id AND pvs.vendor_id(+) = poh.vendor_id AND pvs.vendor_site_id(+) = poh.vendor_site_id AND hrl.location_id(+) = poh.ship_to_location_id AND freight_lkup.lookup_type(+) = 'FREIGHT TERMS' AND freight_lkup.lookup_code(+) = poh.freight_terms_lookup_code AND freight_lkup.view_application_id(+) = 201 AND freight_lkup.security_group_id(+) = 0 AND fob_lkup.lookup_type(+) = 'FOB' AND fob_lkup.lookup_code(+) = poh.fob_lookup_code AND fob_lkup.view_application_id(+) = 201 AND fob_lkup.security_group_id(+) = 0 AND prf.person_id(+) = por.agent_id AND trunc(SYSDATE) BETWEEN prf.effective_start_date AND prf.effective_end_date AND hrl2.location_id(+) = poh.bill_to_location_id AND b.term_id = poh.terms_id AND msi.inventory_item_id(+) = pol.item_id AND NVL( msi.organization_id, dist.destination_organization_id ) = dist.destination_organization_id AND msitl.inventory_item_id (+) = msi.inventory_item_id AND msitl.organization_id (+) = msi.organization_id AND dist.project_id IS NOT NULL AND shipvia_lkup.organization_id(+) = poh.org_id AND shipvia_lkup.freight_code(+) = poh.ship_via_lookup_code AND b.language = NVL( hrl.language, b.language ) AND b.language = NVL( hrl2.language, b.language ) AND b.language = NVL( t.language, b.language ) AND b.language = nvl(msitl.language, b.language) AND b.language = po_status_lkup.language AND b.language = brclosestatus_lkup.language AND b.language = nvl(shipvia_lkup.language, b.language) AND b.language = nvl(freight_lkup.language, b.language) AND b.language = nvl(fob_lkup.language, b.language) AND b.language IN ('US') AND po_status_lkup.language IN ('US') AND brclosestatus_lkup.language IN ('US') AND shipvia_lkup.language(+) IN ('US') AND freight_lkup.language(+) IN ('US') AND fob_lkup.language(+) IN ('US') ) PIVOT(MAX(br_document_type) AS br_document_type, MAX(ship_to_location_name) AS ship_to_location_name, MAX(bill_to_location_name) AS bill_to_location_name, MAX(payment_term) AS payment_term, MAX(item_description) AS item_description, MAX (po_status) AS po_status, MAX (br_closure_status) AS br_closure_status, MAX (ship_via) AS ship_via ,MAX (freight_terms) AS freight_terms, MAX (fob) AS fob FOR LANGUAGE IN ('US' "US")) ) x where 2=2 AR ECC تصنيع المشروعات, أنشطة الشراء, SQL3 Imported from Enterprise Command Center Description: تفاصيل مشتريات تصنيع المشروعات Dataset Key: pjm-procurement Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues D ECC Project Manufacturing, Beschaffungsaktivitäten, SQL3 Imported from Enterprise Command Center Description: Project Manufacturing - Beschaffungsdetails Dataset Key: pjm-procurement Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues E ECC Project Manufacturing, Actividades de Compras, SQL3 Imported from Enterprise Command Center Description: Detalles de compra de fabricación de proyecto Dataset Key: pjm-procurement Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues F ECC Project Manufacturing, Activités d'achat, SQL3 Imported from Enterprise Command Center Description: Détails approvisionnements Oracle Project Manufacturing Dataset Key: pjm-procurement Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues I ECC Project Manufacturing, Attività di acquisto, SQL3 Imported from Enterprise Command Center Description: Dettagli acquisti Project Manufacturing Dataset Key: pjm-procurement Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues JA ECC プロジェクト製造, 調達活動, SQL3 Imported from Enterprise Command Center Description: プロジェクト製造調達詳細 Dataset Key: pjm-procurement Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues KO ECC Project Manufacturing, 조달 활동, SQL3 Imported from Enterprise Command Center Description: Project Manufacturing 조달 상세내역 Dataset Key: pjm-procurement Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues RU ECC Производство по проектам, Закупочные операции, SQL3 Imported from Enterprise Command Center Description: Сведения о закупках в Производстве по проектам Dataset Key: pjm-procurement Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues S ECC Projekttillverkning, Inköpsaktiviteter, SQL3 Imported from Enterprise Command Center Description: Projekttillverkning: Inköpsdetaljer Dataset Key: pjm-procurement Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues TR ECC Proje Üretimi, Tedarik Aktiviteleri, SQL3 Imported from Enterprise Command Center Description: Proje Üretimi Tedarik Detayları Dataset Key: pjm-procurement Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues US ECC Project Manufacturing, Procurement Activities, SQL3 Imported from Enterprise Command Center Description: Project Manufacturing Procurement Details Dataset Key: pjm-procurement Query Procedure: PJM_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: PJM_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues ZHS ECC Project Manufacturing, 采购活动, SQL3 Imported from Enterprise Command Center Description: 项目制造采购详细信息 Dataset Key: pjm-procurement 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