VIEW: APPS.PA_RESOURCES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'