View: PA_RESOURCES_V

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

View Text

SELECT R.ROWID
, R.RESOURCE_ID
, PA_RESOURCES_PKG.GET_RESOURCE_NAME(R.RESOURCE_ID
, R.RESOURCE_TYPE_ID)
, R.DESCRIPTION
, R.RESOURCE_TYPE_ID
, RT.NAME
, RT.RESOURCE_TYPE_CODE
, RT.RESOURCE_CLASS_CODE
, R.UNIT_OF_MEASURE
, DECODE(R.UNIT_OF_MEASURE
, NULL
, NULL
, PL.MEANING)
, R.ROLLUP_QUANTITY_FLAG
, R.TRACK_AS_LABOR_FLAG
, R.START_DATE_ACTIVE
, R.END_DATE_ACTIVE
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_LOGIN
, R.ATTRIBUTE1
, R.ATTRIBUTE_CATEGORY
FROM PA_RESOURCES R
, PA_RESOURCE_TYPES RT
, PA_LOOKUPS PL
WHERE R.RESOURCE_TYPE_ID = RT.RESOURCE_TYPE_ID
AND R.UNIT_OF_MEASURE = PL.LOOKUP_CODE (+)
AND PL.LOOKUP_TYPE (+) = 'UNIT'

Columns