Organization Details -- Organization Details.sql

SELECT IOP.ORGANIZATION_CODE, IOP.ORGANIZATION_ID, IOP.INVENTORY_FLAG, (SELECT NAME FROM HR_ORGANIZATION_UNITS_F_TL WHERE iop.organization_id = organization_id AND sysdate BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE) "Org Name", IOP.BUSINESS_UNIT_ID, (SELECT name FROM HR_ORGANIZATION_UNITS_F_TL WHERE iop.BUSINESS_UNIT_ID = organization_id AND sysdate BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE) "BU Name" FROM INV_ORG_PARAMETERS IOP ORDER BY 4, 6