View: PA_NON_LABOR_RESOURCES_RES_V

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

View Text

SELECT NON_LABOR_RESOURCE_ID
, NON_LABOR_RESOURCE
, DESCRIPTION
, EXPENDITURE_TYPE
, 'N'
, NULL
, 'N'
, NVL(EQUIPMENT_RESOURCE_FLAG
, 'N')
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM PA_NON_LABOR_RESOURCES
WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES
, 'Y'
, START_DATE_ACTIVE
, TRUNC(SYSDATE) ) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns