View: PABV_RESOURCES

Product:	PA - Projects
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PABV_RESOURCES

View Text

SELECT PR.RESOURCE_ID
, PR.NAME
, PR.DESCRIPTION
, '_LA:UNIT_OF_MEASURE:PA_LOOKUPS:UNIT:MEANING'
, '_DF:PA:PA_RESOURCES_FLEX:PR'
, PRT.DESCRIPTION
, PRT.NAME
, PR.START_DATE_ACTIVE
, PR.END_DATE_ACTIVE
, PR.LAST_UPDATE_DATE
, PR.LAST_UPDATED_BY
, PR.CREATION_DATE
, PR.CREATED_BY
FROM PA_RESOURCES PR
, PA_RESOURCE_TYPES PRT
WHERE PR.RESOURCE_TYPE_ID = PRT.RESOURCE_TYPE_ID
AND PRT.RESOURCE_TYPE_CODE NOT IN ('UNCATEGORIZED'
, 'UNCLASSIFIED') WITH READ ONLY

Columns