INV Organization Hierarchy Exceptions

➜ Back to Library
Description
Categories: BI Publisher
Application: Inventory
Source: Organization Hierarchy Exceptions Report (XML)
Short Name: INVORGES_XML
DB package: INV_INVORGES_XMLP_PKG
Run INV Organization Hierarchy Exceptions and other Oracle EBS reports with Blitz Report™ on our demo environment
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 COBRA Coverage PER COBRA Payments PA Organization Hierarchy PER Organization Hierarchy PO Receipt Adjustments PER Work Force Count PER Head Count Detail PER ADA PON Solicitation data template
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™