View: POR_EXP_ORG_LOV_V

Product:	ICX - Oracle iProcurement
Description:	A new view in iP for Expenditure Organization
Implementation/DBA Data:	APPS.POR_EXP_ORG_LOV_V

View Text

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

Columns