INV Organization Hierarchy Exceptions

➜ Back to Library
XMLXML import file

Description

Categories
BI Publisher
Application
Inventory
Source
Organization Hierarchy Exceptions Report (XML)
Short Name
INVORGES_XML
DB package
INV_INVORGES_XMLP_PKG

SQL 13 lines

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

Parameters 1

ParameterTypeList of values SQL
Legal Entity NameLOV Oracle