INV Item Organization Assignment
Description
Categories: Concurrent Program
Imported from Concurrent Program
Application: Inventory
Source: Item Organization Assignment
Short Name: INVITEMORG_ASSIGN
Application: Inventory
Source: Item Organization Assignment
Short Name: INVITEMORG_ASSIGN
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 ) ) |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Source Organization | LOV Oracle | ||
| Hierarchy Origin | LOV Oracle | ||
| Hierarchy Name | LOV Oracle | ||
| Category Set Name | LOV Oracle | ||
| Categories From | Char | ||
| To | Char | ||
| Items From | Char | ||
| To 2 | Char | ||
| Request Count | Number |