View: PA_ORGANIZATIONS_RES_V

Product:	PA - Projects
Description:	10Sc Only
Implementation/DBA Data:	APPS.PA_ORGANIZATIONS_RES_V

View Text

SELECT ORGANIZATION_ID
, SUBSTR(NAME
, 1
, 60)
, 'Y'
, 'HOURS'
, 'N'
FROM PA_ORGANIZATIONS_EXPEND_V
WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES
, 'Y'
, DATE_FROM
, TRUNC(SYSDATE)) BETWEEN DATE_FROM
AND NVL(DATE_TO
, TRUNC(SYSDATE))
AND ACTIVE_FLAG = 'Y'

Columns