[Home] [Help]
View: PABV_FUNDINGS
Product: | PA - Projects |
Description: | - Retrofitted |
Implementation/DBA Data: |
APPS.PABV_FUNDINGS
|
View Text
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
Columns
Name |
PROJECT_FUNDING_ID |
ALLOCATED_AMOUNT |
ALLOCATION_DATE |
"_DF" |
AGREEMENT_ID |
PROJECT_ID |
TASK_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |