Product: | PA - Projects |
---|---|
Description: | PA_NON_LABOR_RESOURCES view stores non-labor assets that are utilized during project work and for which costs and revenue are tracked |
Implementation/DBA Data: | APPS.PA_NON_LABOR_RESOURCES_V |
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'