ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA279D2E0530100007F1FF2 INV Organization Code (all) 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 US All active inventory organization codes 22F4EC80E1E2870DE06362FB0905BD09Y select x.* from ( SELECT * FROM ( SELECT ECC_SPEC_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID, ITEM, ORG_CODE, DESCRIPTION, CROSS_REFERENCE_TYPE, CROSS_REFERENCE_VALUE, LANGUAGE FROM MTL_ITEM_ECC_CROSS_REF_V mtl_v where language in ('US') ) PIVOT ( MAX(DESCRIPTION) AS DESCRIPTION for LANGUAGE in ('US' "US")) ) x where 2=2 AR ECC إدارة معلومات المنتجات, الإسناد الترافقي للصنف Imported from Enterprise Command Center Dataset Key: inv-cross-ref Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues D ECC Product Information Management, Artikelquerverweis Imported from Enterprise Command Center Dataset Key: inv-cross-ref Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues E ECC Product Information Management, Referencia Cruzada de Artículo Imported from Enterprise Command Center Dataset Key: inv-cross-ref Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues F ECC Product Information Management, Référence croisée d'article Imported from Enterprise Command Center Dataset Key: inv-cross-ref Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues I ECC Gestione informazioni prodotto, Rif. incrociato articolo Imported from Enterprise Command Center Dataset Key: inv-cross-ref Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues JA ECC 製品情報管理, 品目相互参照 Imported from Enterprise Command Center Dataset Key: inv-cross-ref Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues KO ECC 제품 정보 관리, 품목 상호 참조 Imported from Enterprise Command Center Dataset Key: inv-cross-ref Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues RU ECC Управление сведениями о продуктах, Перекрестная ссылка позиции Imported from Enterprise Command Center Dataset Key: inv-cross-ref Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues S ECC Hantering av produktinformation, Korsreferens för artikel Imported from Enterprise Command Center Dataset Key: inv-cross-ref Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues TR ECC Ürün Ana Veri Yönetimi, Kalem Çapraz Referansı Imported from Enterprise Command Center Dataset Key: inv-cross-ref Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues US ECC Product Information Management, Item Cross-Reference Imported from Enterprise Command Center Dataset Key: inv-cross-ref Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues ZHS ECC Product Information Management, 物料交叉参考 Imported from Enterprise Command Center Dataset Key: inv-cross-ref Query Procedure: INV_ECC_ITEM_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: INV_ITEM_ECC_DATASECURITY_PKG.GetFilterAttributeValues Enterprise Command Center 2=2 1 10 2=2 x.org_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