VIEW: APPS.POR_EXP_ORG_LOV_V

Source

View Text - Preformatted

SELECT ORGANIZATION_ID, BUSINESS_GROUP_ID, NAME, DATE_FROM, DATE_TO, ACTIVE_FLAG from PA_ORGANIZATIONS_EXPEND_V WHERE NVL(ACTIVE_FLAG,'*') = 'Y' AND TRUNC(sysdate) BETWEEN DATE_FROM AND NVL(DATE_TO, TRUNC(SYSDATE)) ORDER BY NAME

View Text - HTML Formatted

SELECT ORGANIZATION_ID
, BUSINESS_GROUP_ID
, NAME
, DATE_FROM
, DATE_TO
, ACTIVE_FLAG
FROM PA_ORGANIZATIONS_EXPEND_V
WHERE NVL(ACTIVE_FLAG
, '*') = 'Y'
AND TRUNC(SYSDATE) BETWEEN DATE_FROM
AND NVL(DATE_TO
, TRUNC(SYSDATE)) ORDER BY NAME