INV Organization Hierarchy Exceptions
Description
Categories: BI Publisher
Application: Inventory
Source: Organization Hierarchy Exceptions Report (XML)
Short Name: INVORGES_XML
DB package: INV_INVORGES_XMLP_PKG
Source: Organization Hierarchy Exceptions Report (XML)
Short Name: INVORGES_XML
DB package: INV_INVORGES_XMLP_PKG
SELECT SUBSTR(ORGANIZATION_NAME, 1,50) "Organization Name", ORGANIZATION_CODE "Code" FROM ORG_ORGANIZATION_DEFINITIONS WHERE ORGANIZATION_ID NOT IN (SELECT DISTINCT ORGANIZATION_ID_PARENT FROM PER_ORG_STRUCTURE_ELEMENTS) AND ORGANIZATION_ID NOT IN (SELECT ORGANIZATION_ID_CHILD FROM PER_ORG_STRUCTURE_ELEMENTS) AND LEGAL_ENTITY = (SELECT ORGANIZATION_ID FROM HR_ALL_ORGANIZATION_UNITS WHERE ltrim(rtrim(NAME)) = :P_LEGAL_ENTITY_NAME) ORDER BY ORGANIZATION_NAME |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Legal Entity Name | LOV Oracle |