VIEW: APPS.PA_NON_LABOR_RESOURCES_V

Source

View Text - Preformatted

SELECT nlr.NON_LABOR_RESOURCE_ID ,nlr.NON_LABOR_RESOURCE ,nlr.EXPENDITURE_TYPE ,nlr.LAST_UPDATE_DATE ,nlr.LAST_UPDATED_BY ,nlr.CREATION_DATE ,nlr.CREATED_BY ,nlr.LAST_UPDATE_LOGIN ,nlr.START_DATE_ACTIVE ,nlr.END_DATE_ACTIVE ,nlr.DESCRIPTION ,nlr.ATTRIBUTE_CATEGORY ,nlr.ATTRIBUTE1 ,nlr.ATTRIBUTE2 ,nlr.ATTRIBUTE3 ,nlr.ATTRIBUTE4 ,nlr.ATTRIBUTE5 ,nlr.ATTRIBUTE6 ,nlr.ATTRIBUTE7 ,nlr.ATTRIBUTE8 ,nlr.ATTRIBUTE9 ,nlr.ATTRIBUTE10 ,nlr.ATTRIBUTE11 ,nlr.ATTRIBUTE12 ,nlr.ATTRIBUTE13 ,nlr.ATTRIBUTE14 ,nlr.ATTRIBUTE15 ,NVL(nlr.EQUIPMENT_RESOURCE_FLAG,'N') ,exp.UNIT_OF_MEASURE ,lk.meaning FROM PA_NON_LABOR_RESOURCES nlr ,PA_EXPENDITURE_TYPES exp ,PA_LOOKUPS lk WHERE nlr.expenditure_type = exp.expenditure_type AND lk.lookup_code = exp.Unit_of_measure AND lk.lookup_type = 'UNIT'

View Text - HTML Formatted

SELECT NLR.NON_LABOR_RESOURCE_ID
, NLR.NON_LABOR_RESOURCE
, NLR.EXPENDITURE_TYPE
, NLR.LAST_UPDATE_DATE
, NLR.LAST_UPDATED_BY
, NLR.CREATION_DATE
, NLR.CREATED_BY
, NLR.LAST_UPDATE_LOGIN
, NLR.START_DATE_ACTIVE
, NLR.END_DATE_ACTIVE
, NLR.DESCRIPTION
, NLR.ATTRIBUTE_CATEGORY
, NLR.ATTRIBUTE1
, NLR.ATTRIBUTE2
, NLR.ATTRIBUTE3
, NLR.ATTRIBUTE4
, NLR.ATTRIBUTE5
, NLR.ATTRIBUTE6
, NLR.ATTRIBUTE7
, NLR.ATTRIBUTE8
, NLR.ATTRIBUTE9
, NLR.ATTRIBUTE10
, NLR.ATTRIBUTE11
, NLR.ATTRIBUTE12
, NLR.ATTRIBUTE13
, NLR.ATTRIBUTE14
, NLR.ATTRIBUTE15
, NVL(NLR.EQUIPMENT_RESOURCE_FLAG
, 'N')
, EXP.UNIT_OF_MEASURE
, LK.MEANING
FROM PA_NON_LABOR_RESOURCES NLR
, PA_EXPENDITURE_TYPES EXP
, PA_LOOKUPS LK
WHERE NLR.EXPENDITURE_TYPE = EXP.EXPENDITURE_TYPE
AND LK.LOOKUP_CODE = EXP.UNIT_OF_MEASURE
AND LK.LOOKUP_TYPE = 'UNIT'