DBA Data[Home] [Help]

VIEW: APPS.OKL_AM_INV_ORG_UV

Source

View Text - Preformatted

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