Organization Details - Organization Details

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) AS "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) AS "BU Name", 
     (SELECT ORG_INFORMATION4 
      FROM hr_organization_information_f 
      WHERE iop.BUSINESS_UNIT_ID = organization_id 
        AND sysdate BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE 
        AND ORG_INFORMATION_CONTEXT = 'FUN_BUSINESS_UNIT') AS "Set ID" 
 FROM INV_ORG_PARAMETERS IOP 
 ORDER BY 4, 6;