[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 |