SELECT
haotl.NAME,
iop.*,
MC.calendar_Code,
mc.description
FROM Inv_Org_Parameters iop,
HR_ORGANIZATION_UNITS_F_TL haotl,
MSC_CALENDARS mc
WHERE haotl.organization_id = iop.business_unit_id
AND TO_CHAR(iop.Schedule_id) = mc.SR_CALENDAR_CODE(+)
ORDER BY haotl.NAME, ORGANIZATION_CODE;