VIEW: APPS.PABV_FUNDINGS

Source

View Text - Preformatted

SELECT pf.project_funding_id , pf.allocated_amount , pf.date_allocated , '_DF:PA:PA_PROJECT_FUNDINGS_DESC_FLEX:pf' , pf.agreement_id , pf.project_id , pf.task_id , pf.LAST_UPDATE_DATE , pf.LAST_UPDATED_BY , pf.CREATION_DATE , pf.CREATED_BY FROM pa_project_fundings pf , pa_projects_all ppa WHERE pf.project_id = ppa.project_id and '_SEC:ppa.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PF.PROJECT_FUNDING_ID
, PF.ALLOCATED_AMOUNT
, PF.DATE_ALLOCATED
, '_DF:PA:PA_PROJECT_FUNDINGS_DESC_FLEX:PF'
, PF.AGREEMENT_ID
, PF.PROJECT_ID
, PF.TASK_ID
, PF.LAST_UPDATE_DATE
, PF.LAST_UPDATED_BY
, PF.CREATION_DATE
, PF.CREATED_BY
FROM PA_PROJECT_FUNDINGS PF
, PA_PROJECTS_ALL PPA
WHERE PF.PROJECT_ID = PPA.PROJECT_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY