[Home] [Help]
View: 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
Name |
NON_LABOR_RESOURCE_ID |
NON_LABOR_RESOURCE |
DESCRIPTION |
EXPENDITURE_TYPE |
TRACK_AS_LABOR_FLAG |
UNIT_OF_MEASURE |
ROLLUP_QUANTITY_FLAG |
EQUIPMENT_RESOURCE_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |