[Home] [Help]
View: PAFV_NON_LABOR_RESOURCES
Product: | PA - Projects |
Description: | Business view to show information about the non-labor assets used for the projects for which charges are incurred. |
Implementation/DBA Data: |
APPS.PAFV_NON_LABOR_RESOURCES
|
View Text
SELECT PNL.NON_LABOR_RESOURCE
, PNL.DESCRIPTION
, PNL.START_DATE_ACTIVE
, PNL.END_DATE_ACTIVE
, PNL.EXPENDITURE_TYPE
, PET.DESCRIPTION
, '_DF:PA:PA_NONLABOR_RESOUR_DESC_FLEX:PNL'
, PNL.LAST_UPDATE_DATE
, PNL.LAST_UPDATED_BY
, PNL.CREATION_DATE
, PNL.CREATED_BY
FROM PA_NON_LABOR_RESOURCES PNL
, PA_EXPENDITURE_TYPES PET
WHERE PNL.EXPENDITURE_TYPE = PET.EXPENDITURE_TYPE WITH READ ONLY
Columns
Name |
NON_LABOR_RESOURCE |
DESCRIPTION |
START_EFFECTIVE_DATE |
END_EFFECTIVE_DATE |
EXPENDITURE_TYPE |
EXPENDITURE_TYPE_DESCR |
"_DF" |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |