EBS 11i determines whether the inventory organization is Engineering

The Code is as follows:

SELECT COUNT(1)-- INTO v_Count  FROM Org_Organization_Definitions Ood, Hr_All_Organization_Units Haou WHERE 1 = 1   AND Ood.Organization_Code = ‘&Organization_Code‘   AND Ood.Organization_Id = Haou.Organization_Id   AND Haou.Internal_External_Flag = ‘INT‘   AND EXISTS (SELECT 1          FROM Hr_Organization_Information         WHERE Organization_Id = Haou.Organization_Id           AND Org_Information_Context = ‘CLASS‘           AND Org_Information1 = ‘PA_EXPENDITURE_ORG‘           AND Org_Information2 = ‘Y‘)   AND EXISTS (SELECT 1          FROM Hr_Organization_Information         WHERE Organization_Id = Haou.Organization_Id           AND Org_Information_Context = ‘CLASS‘           AND Org_Information1 = ‘PJM‘           AND Org_Information2 = ‘Y‘);

Count <> 0 indicates the engineering inventory organization.

This article is from "The road is long and the distance is long ..." Blog, please be sure to keep this source http://baser.blog.51cto.com/4153192/1568962

EBS 11i determines whether the inventory organization is Engineering