INV Organization Hierarchy Exceptions

➜ Back to Library
Description
Categories: BI Publisher
Columns: Organization Name, Code ...
Application: Inventory
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
Download
Related Blitz Reports
PER Organization Hierarchy PER COBRA Coverage PER COBRA Payments PA Organization Hierarchy PO Receipt Adjustments PER Head Count Detail PER ADA PER Work Force Count PO Backordered Internal Requisitions
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: