ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 11E2772E94022550E06362FB09055495Y select x.* from ( SELECT * FROM (SELECT IESD.ECC_SPEC_ID, IESD.ECC_SPEC_ID ORG_ITEM_SD, IESD.ORGANIZATION_CODE, IESD.ORGANIZATION_ID, IESD.INVENTORY_ITEM_ID, IESD.ITEM_NAME, IESD.ITEM_DESCRIPTION, IESD.REQUIREMENT_DATE, IESD.SUPPLY_DEMAND_SOURCE_TYPE, Decode(IESD.SUPPLY_DEMAND_SOURCE_TYPE,9,2,21,8,22,8,23,2, IESD.SUPPLY_DEMAND_SOURCE_TYPE) DEMAND_SOURCE_TYPE, IESD.SUPPLY_DEMAND_TYPE, IESD.SUPPLY_DEMAND_ID, IESD.SUPPLY_DEMAND_VALUE, IESD.SUPPLY_DEMAND_SOURCE, IESD.QUANTITY, IESD.ONHAND_QUANTITY, IESD.NET_CHANGE, IESD.TOTAL_SUPPLY, IESD.TOTAL_DEMAND, IESD.NET_AVAILABLE, IESD.ABS_QUANTITY, IESD.EXCESS_DEMAND, decode(IESD.SUPPLY_DEMAND,'AVAILABLE', (SELECT meaning FROM fnd_lookup_values flv WHERE lookup_code = IESD.SUPPLY_DEMAND AND lookup_type = 'OKR_R_AVAIL_STATUS' AND view_application_id=0 AND flv.language= IESD.language), (SELECT meaning FROM fnd_lookup_values flv WHERE lookup_code = IESD.SUPPLY_DEMAND AND lookup_type = 'MRP_SUPPLY_DEMAND_TYPE' AND view_application_id=700 AND flv.language= IESD.language)) SUPPLY_DEMAND, IESD.SUPPLY_STATUS SUPPLY_STATUS_CODE, decode(IESD.SUPPLY_STATUS, null, null, (SELECT meaning FROM fnd_lookup_values flv WHERE lookup_code = IESD.SUPPLY_STATUS AND lookup_type = 'INV_ECC_SUPPLY_DEMAND_STATUS' AND view_application_id=3 AND flv.language= IESD.language)) SUPPLY_STATUS, IESD.DEMAND_STATUS DEMAND_STATUS_CODE, decode(IESD.DEMAND_STATUS, null, null, (SELECT meaning FROM fnd_lookup_values flv WHERE lookup_code = IESD.DEMAND_STATUS AND lookup_type = 'INV_ECC_SUPPLY_DEMAND_STATUS' AND view_application_id=3 AND flv.language= IESD.language)) DEMAND_STATUS, IESD.DATE_MONTH, IESD.EXCESS_STOCK, IESD.DAILY_NET_AVAILABLE, IESD.PHYSICAL_ONHAND, IESD.PHYSICAL_AVAILABILITY, IESD.LANGUAGE , DECODE (IESD.INVENTORY_ITEM_ID, NULL ,'N', DECODE (IESD.SUPPLY_DEMAND_SOURCE_TYPE, 9,'Y', 22, 'Y', 'N' )) ALLOW_TRANSFER_RESERVATION , DECODE (IESD.INVENTORY_ITEM_ID, NULL ,'N', 'Y') ALLOW_VIEW_ONHAND FROM INV_ECC_SUP_DMD_V IESD WHERE LANGUAGE IN ( 'US') AND IESD.PROCESS_FLAG=1 )PIVOT (MAX(ITEM_DESCRIPTION) AS ITEM_DESCRIPTION, Max(SUPPLY_STATUS) AS SUPPLY_STATUS,Max(DEMAND_STATUS) AS DEMAND_STATUS,Max(SUPPLY_DEMAND) AS SUPPLY_DEMAND for LANGUAGE in ( 'US' "US")) ) x where 2=2 AR ECC إدارة المخازن, Inventory Supply and Demand Imported from Enterprise Command Center Dataset Key: inv-sup-dmd Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues D ECC Bestandsverwaltung, Inventory Supply and Demand Imported from Enterprise Command Center Dataset Key: inv-sup-dmd Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues E ECC Inventory Management, Inventory Supply and Demand Imported from Enterprise Command Center Dataset Key: inv-sup-dmd Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues F ECC Inventory Management, Inventory Supply and Demand Imported from Enterprise Command Center Dataset Key: inv-sup-dmd Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues I ECC Gestione magazzino, Inventory Supply and Demand Imported from Enterprise Command Center Dataset Key: inv-sup-dmd Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues JA ECC 在庫管理, Inventory Supply and Demand Imported from Enterprise Command Center Dataset Key: inv-sup-dmd Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues KO ECC Inventory Management, Inventory Supply and Demand Imported from Enterprise Command Center Dataset Key: inv-sup-dmd Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues RU ECC Управление запасами, Inventory Supply and Demand Imported from Enterprise Command Center Dataset Key: inv-sup-dmd Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues S ECC Lagerstyrning, Inventory Supply and Demand Imported from Enterprise Command Center Dataset Key: inv-sup-dmd Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues TR ECC Envanter Yönetimi, Inventory Supply and Demand Imported from Enterprise Command Center Dataset Key: inv-sup-dmd Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues US ECC Inventory Management, Inventory Supply and Demand Imported from Enterprise Command Center Dataset Key: inv-sup-dmd Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues ZHS ECC Inventory Management, Inventory Supply and Demand Imported from Enterprise Command Center Dataset Key: inv-sup-dmd Query Procedure: INV_ECC_SUP_DMD_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: inv_ecc_datasecurity_pkg_pub.GetFilterAttributeValues Enterprise Command Center 2=2 1 10 2=2 x.organization_code=:organization_code LOV INV Organization Code (all) 8E2FF36EDEA279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') US Organization Code