Organization Details -- Organization Parameters1.sql

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 ORDER MANAGEMENT