FND Design Data [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: ViewAPPS.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