ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41D7DA406034CFAFE06362FB09055662Y SELECT ORGANIZATION_ID_CHILD FROM ( SELECT ORGANIZATION_ID_CHILD FROM PER_ORG_STRUCTURE_ELEMENTS ARC CONNECT BY ARC.ORGANIZATION_ID_PARENT = PRIOR ARC.ORGANIZATION_ID_CHILD AND ARC.ORG_STRUCTURE_VERSION_ID = PRIOR ARC.ORG_STRUCTURE_VERSION_ID START WITH ARC.ORGANIZATION_ID_PARENT = :B2 AND ARC.ORG_STRUCTURE_VERSION_ID = :B1 ) , HR_ALL_ORGANIZATION_UNITS ORG , HR_ORGANIZATION_INFORMATION HOI , MTL_PARAMETERS MP WHERE ORG.ORGANIZATION_ID = HOI.ORGANIZATION_ID AND ORG.ORGANIZATION_ID = MP.ORGANIZATION_ID AND HOI.ORG_INFORMATION1 = 'INV' AND HOI.ORG_INFORMATION2 = 'Y' AND HOI.ORG_INFORMATION_CONTEXT = 'CLASS' AND ORG.ORGANIZATION_ID = ORGANIZATION_ID_CHILD AND ( ORG.DATE_TO >= SYSDATE OR ORG.DATE_TO IS NULL ) AND ( NOT EXISTS( SELECT 1 FROM ORG_ACCESS ACC WHERE ACC.ORGANIZATION_ID = ORGANIZATION_ID_CHILD ) OR EXISTS( SELECT 1 FROM ORG_ACCESS ACC WHERE ACC.ORGANIZATION_ID = ORGANIZATION_ID_CHILD AND ACC.RESPONSIBILITY_ID = :B3 ) ) AR INV تخصيص تنظيم الصنف Imported from Concurrent Program Application: المخازن Source: تخصيص تنظيم الصنف Short Name: INVITEMORG_ASSIGN D INV Zuordnung Artikelorganisation Imported from Concurrent Program Application: Lager Source: Zuordnung Artikelorganisation Short Name: INVITEMORG_ASSIGN E INV Asignación de Organización de Artículo Imported from Concurrent Program Application: Inventory Source: Asignación de Organización de Artículo Short Name: INVITEMORG_ASSIGN F INV Affectation d'un article à une organisation Imported from Concurrent Program Application: Inventory Source: Affectation d'un article à une organisation Short Name: INVITEMORG_ASSIGN I INV Assegnazione organizzazione articoli Imported from Concurrent Program Application: Inventory Source: Assegnazione organizzazione articoli Short Name: INVITEMORG_ASSIGN JA INV 品目組織割当 Imported from Concurrent Program Application: Inventory Source: 品目組織割当 Short Name: INVITEMORG_ASSIGN KO INV 품목 조직 지정 Imported from Concurrent Program Application: Inventory Source: 품목 조직 지정 Short Name: INVITEMORG_ASSIGN PTB INV Atribuição da Organização do Item Imported from Concurrent Program Application: Inventário Source: Atribuição da Organização do Item Short Name: INVITEMORG_ASSIGN RU INV Назначение организаций позициям Imported from Concurrent Program Application: Запасы Source: Назначение организаций позициям Short Name: INVITEMORG_ASSIGN S INV Artikelorganisationstilldelning Imported from Concurrent Program Application: Inventory Source: Artikelorganisationstilldelning Short Name: INVITEMORG_ASSIGN TR INV Kalem Organizasyonu Atama Imported from Concurrent Program Application: Stok Yönetimi Source: Kalem Organizasyonu Atama Short Name: INVITEMORG_ASSIGN US INV Item Organization Assignment Imported from Concurrent Program Application: Inventory Source: Item Organization Assignment Short Name: INVITEMORG_ASSIGN ZHS INV 物料组织分配 Imported from Concurrent Program Application: 库存管理系统 Source: 物料组织分配 Short Name: INVITEMORG_ASSIGN Concurrent Program 1=1 1 -10 :category_structure Number select min(structure_id) from mtl_category_sets where category_set_id = nvl(:$flex$.category_set_name,category_set_id) Y US Category Structure Category Structure 2 10 :source_organization LOV Oracle INV_ITEMASSIGN_HIER_ORIGIN Y select hao.organization_id id, haotl.name value, null description from mtl_parameters mp,hr_all_organization_units hao,hr_all_organization_units_tl haotl where hao.organization_id=mp.organization_id and haotl.organization_id=mp.organization_id and haotl.language=userenv('LANG') and (hao.date_to>=sysdate or hao.date_to is null ) and (not exists (select 1 from org_access acc where acc.organization_id=mp.organization_id) or exists (select 1 from org_access acc where acc.organization_id=mp.organization_id and acc.responsibility_id=fnd_global.resp_id) ) order by value,description US Source Organization Source Organization 3 20 :hierarchy_origin LOV Oracle INV_ITEMASSIGN_HIER_ORIGIN Y select hao.organization_id id, haotl.name value, null description from mtl_parameters mp,hr_all_organization_units hao,hr_all_organization_units_tl haotl where hao.organization_id=mp.organization_id and haotl.organization_id=mp.organization_id and haotl.language=userenv('LANG') and (hao.date_to>=sysdate or hao.date_to is null ) and (not exists (select 1 from org_access acc where acc.organization_id=mp.organization_id) or exists (select 1 from org_access acc where acc.organization_id=mp.organization_id and acc.responsibility_id=fnd_global.resp_id) ) order by value,description Y US Hierarchy Origin Organization Hierarchy Origin 4 30 :hierarchy_name LOV Oracle INV_ITEMASSIGN_HIER_WITH_SRC Y select organization_structure_id id, name value, null description from per_organization_structures where inv_orghierarchy_pvt.contained_in_hierarchy(name,:$flex$.inv_itemassign_hier_origin)='Y' order by name Y US Hierarchy Name Organization Hierarchy Name with Item master validation 5 40 :category_set_name LOV Oracle INV_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets order by value,description select category_set_name from mtl_default_sets_view where functional_area_id = 1 Y US Category Set Name Category Set Name 6 50 :categories_from Char US Categories From Categories From 7 60 :categories_to Char US To Categories To 8 70 :items_from Char US Items From Items From 9 80 :items_to Char US To 2 Items To 10 90 :request_count Number Y US Request Count Request Count