SELECT ORGANIZATION_CODE, ORGANIZATION_NAME , ORGANIZATION_ID FROM ORG_ORGANIZATION_DEFINITIONS WHERE SYSDATE <= NVL( DISABLE_DATE, SYSDATE ) ORDER BY ORGANIZATION_NAME
View Text - HTML Formatted
SELECT ORGANIZATION_CODE , ORGANIZATION_NAME , ORGANIZATION_ID FROM ORG_ORGANIZATION_DEFINITIONS WHERE SYSDATE <= NVL( DISABLE_DATE , SYSDATE ) ORDER BY ORGANIZATION_NAME