DBA Data[Home] [Help]

VIEW: APPS.PAFV_NON_LABOR_RESOURCES

Source

View Text - Preformatted

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
View Text - HTML Formatted

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