View: PA_ORGANIZATIONS_LOV_V

Product:	PA - Projects
Description:	PA_ORGANIZATIONS_LOV_V is a view that displays all the organizations which can be specified for a project or a task.
Implementation/DBA Data:	APPS.PA_ORGANIZATIONS_LOV_V

View Text

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

Columns