ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE8879D2E0530100007F1FF2 HR Operating Unit (all) 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')) order by hou.name US 1D3077E2013207BBE06362FB09050099 select x.* from ( SELECT * FROM ( SELECT /*+ push_pred(oel) */ oel.order_number, hdfv.* , oel.customer,oel.customer_number,oel.ship_to_location, oel.order_date, oel.status, oel.order_alert_count,oel.request_date,oel.order_type, oel.order_alert_flag,oel.ecc_spec_id,oel.header_id,oel.header_hold_name,oel.customer_po, oel.org_id,oel.order_currency,oel.order_total,oel.language_code,oel.csr_user_name, oel.ORDER_CREATION_DATE, oel.ORDER_BOOKED_DATE, oel.OPERATING_UNIT FROM ( SELECT /*+ leading(oegt) cardinality(oegt 10) */ oegt.order_number, oegt.customer, oegt.customer_number, ship_su.LOCATION ship_to_location, oegt.order_date, oegt.status, SUM (oegt.alert_count) + MAX(nvl(oegt.hdr_alert_count,0)) order_alert_count, DECODE (SUM (oegt.alert_count) + MAX(nvl(oegt.hdr_alert_count,0)),0,'ecc_blank','ecc_warning') order_alert_flag, oegt.header_id ecc_spec_id, oegt.header_id, oegt.header_hold_name, oh.cust_po_number customer_po, oh.request_date , oegt.order_type, oegt.org_id, oegt.func_currency order_currency, oegt.order_total order_total, oh.csr_user_id,oegt.csr_user_name, oegt.ORDER_BOOKED_DATE ORDER_BOOKED_DATE, oegt.ORDER_CREATION_DATE ORDER_CREATION_DATE, oegt.language_code language_code, oegt.OPERATING_UNIT FROM oe_ecc_global_temp oegt, oe_order_headers_all oh, hz_cust_site_uses_all ship_su WHERE oh.header_id =oegt.header_id AND oh.ship_to_org_id = ship_su.site_use_id(+) AND oegt.org_id IS NOT NULL GROUP BY oegt.header_id, oegt.order_number, oegt.customer, oegt.customer_number, oegt.order_date, oegt.status, ship_su.LOCATION, oegt.header_hold_name, oh.cust_po_number, oh.request_date , oegt.hdr_alert_count, oegt.order_type, oegt.org_id, oegt.func_currency, oegt.order_total, oh.csr_user_id,oegt.csr_user_name, oegt.ORDER_BOOKED_DATE , oegt.ORDER_CREATION_DATE , oegt.language_code, oegt.OPERATING_UNIT) oel , (select "ROW_ID" "'ONTH_ROW_ID'","CONTEXT_VALUE" "'ONTH_CONTEXT_VALUE'","ADDITIONAL_COMMENT" "'ONTH_ADDITIONAL_COMMENT'",to_char("SPECIAL_PRICE") "'ONTH_SPECIAL_PRICE'",to_char("LUMPSUM_ON_NET") "'ONTH_LUMPSUM_ON_NET'",to_char("ADDITIONAL_DISCOUNT_ON_NET___") "'ONTH_ADDITIONAL_DISCOUNT_ON_NET___'","CONCATENATED_SEGMENTS" "'ONTH_CONCATENATED_SEGMENTS'" from ( select ROWID "ROW_ID",CONTEXT "CONTEXT_VALUE",ATTRIBUTE1 "ADDITIONAL_COMMENT",ATTRIBUTE2 "SPECIAL_PRICE",ATTRIBUTE3 "LUMPSUM_ON_NET",ATTRIBUTE4 "ADDITIONAL_DISCOUNT_ON_NET___",ATTRIBUTE1||'.'||ATTRIBUTE2||'.'||ATTRIBUTE3||'.'||ATTRIBUTE4 "CONCATENATED_SEGMENTS" from OE_ORDER_HEADERS_ALL ) ) hdfv, oe_order_headers_all h WHERE 1=1 and h.rowid = hdfv."'ONTH_ROW_ID'"(+) and h.header_id = oel.header_id ) PIVOT ( max(STATUS) as STATUS, max(ORDER_CURRENCY) as ORDER_CURRENCY, max(ORDER_TYPE) as ORDER_TYPE, max(operating_unit) as operating_unit for language_code in ('US' "US")) ) x where 2=2 Y AR ECC إدارة الطلبات, الطلبات (2) Imported from Enterprise Command Center Dataset Key: ont-headers Query Procedure: OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: oe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues D ECC Auftragsmanagement, Aufträge (2) Imported from Enterprise Command Center Dataset Key: ont-headers Query Procedure: OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: oe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues E ECC Order Management, Pedidos (2) Imported from Enterprise Command Center Dataset Key: ont-headers Query Procedure: OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: oe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues F ECC Order Management, Commandes (2) Imported from Enterprise Command Center Dataset Key: ont-headers Query Procedure: OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: oe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues I ECC Gestione ordini, Ordini (2) Imported from Enterprise Command Center Dataset Key: ont-headers Query Procedure: OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: oe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues JA ECC 受注管理, 受注 (2) Imported from Enterprise Command Center Dataset Key: ont-headers Query Procedure: OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: oe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues KO ECC Order Management, 주문 (2) Imported from Enterprise Command Center Dataset Key: ont-headers Query Procedure: OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: oe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues RU ECC Управление заказами, Заказы (2) Imported from Enterprise Command Center Dataset Key: ont-headers Query Procedure: OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: oe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues S ECC Orderhantering, Order (2) Imported from Enterprise Command Center Dataset Key: ont-headers Query Procedure: OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: oe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues TR ECC Sipariş Yönetimi, Siparişler (2) Imported from Enterprise Command Center Dataset Key: ont-headers Query Procedure: OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: oe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues US ECC Order Management, Orders (2) Imported from Enterprise Command Center Dataset Key: ont-headers Query Procedure: OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: oe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues ZHS ECC Order Management, 订单 (2) Imported from Enterprise Command Center Dataset Key: ont-headers Query Procedure: OE_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: oe_ecc_datasecurity_pkg_pub.GetFilterAttributeValues Enterprise Command Center 1=1 2=2 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 (all) 8E2FF36EDE8879D2E0530100007F1FF2 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')) 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