INV Organization Hierarchy Exceptions

Description

Categories: BI Publisher, Logistics

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

Copy

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

Ask a question

Download

Related Blitz Reports

PER Organization Hierarchy PER COBRA Payments PER COBRA Coverage PA Organization Hierarchy PO Receipt Adjustments PER Head Count Detail PER ADA (2) PER ADA PER Work Force Count