View: PA_PROJECT_FUNDINGS_V

Product:	PA - Projects
Description:	10SC Only
Implementation/DBA Data:	APPS.PA_PROJECT_FUNDINGS_V

View Text

SELECT F.ROWID ROW_ID
, F.PROJECT_FUNDING_ID
, F.PROJECT_ID
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, P.SEGMENT1
, SUBSTR(PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('TRANSLATION'
, 'SECURED_DATA')
, 1
, 25))
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, P.NAME
, SUBSTR(PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('TRANSLATION'
, 'SECURED_DATA')
, 1
, 30))
, F.TASK_ID
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, T.TASK_NUMBER
, SUBSTR(PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('TRANSLATION'
, 'SECURED_DATA')
, 1
, 25))
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, T.TASK_NAME
, SUBSTR(PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('TRANSLATION'
, 'SECURED_DATA')
, 1
, 20))
, F.AGREEMENT_ID
, F.BUDGET_TYPE_CODE
, F.ALLOCATED_AMOUNT
, F.DATE_ALLOCATED
, F.ATTRIBUTE_CATEGORY
, F.ATTRIBUTE1
, F.ATTRIBUTE2
, F.ATTRIBUTE3
, F.ATTRIBUTE4
, F.ATTRIBUTE5
, F.ATTRIBUTE6
, F.ATTRIBUTE7
, F.ATTRIBUTE8
, F.ATTRIBUTE9
, F.ATTRIBUTE10
, F.LAST_UPDATE_DATE
, F.LAST_UPDATED_BY
, F.CREATION_DATE
, F.CREATED_BY
, NULL
, F.LAST_UPDATE_LOGIN
, PT.ALLOWABLE_FUNDING_LEVEL_CODE
, PT.PROJECT_TYPE_CLASS_CODE
, F.PM_FUNDING_REFERENCE
, F.PM_PRODUCT_CODE
, F.FUNDING_CURRENCY_CODE
, F.PROJECT_CURRENCY_CODE
, F.PROJECT_RATE_TYPE
, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(F.PROJECT_RATE_TYPE) PROJECT_RATE_TYPE_NAME
, P.PROJECT_BIL_RATE_DATE_CODE
, F.PROJECT_RATE_DATE
, F.PROJECT_EXCHANGE_RATE
, F.PROJECT_ALLOCATED_AMOUNT
, F.PROJFUNC_CURRENCY_CODE
, F.PROJFUNC_RATE_TYPE
, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(F.PROJFUNC_RATE_TYPE) PROJFUNC_RATE_TYPE_NAME
, P.PROJFUNC_BIL_RATE_DATE_CODE
, F.PROJFUNC_RATE_DATE
, F.PROJFUNC_EXCHANGE_RATE
, F.PROJFUNC_ALLOCATED_AMOUNT
, P.INVPROC_CURRENCY_TYPE
, F.INVPROC_CURRENCY_CODE
, F.INVPROC_RATE_TYPE
, F.INVPROC_RATE_DATE
, F.INVPROC_EXCHANGE_RATE
, F.INVPROC_ALLOCATED_AMOUNT
, F.REVPROC_CURRENCY_CODE
, F.REVPROC_RATE_TYPE
, F.REVPROC_RATE_DATE
, F.REVPROC_EXCHANGE_RATE
, F.REVPROC_ALLOCATED_AMOUNT
, F.FUNDING_CATEGORY
, F.FUNDING_INV_APPLIED_AMOUNT
, F.FUNDING_INV_DUE_AMOUNT
, F.FUNDING_BACKLOG_AMOUNT
, F.PROJFUNC_REALIZED_GAINS_AMT
, F.PROJFUNC_REALIZED_LOSSES_AMT
, F.PROJFUNC_INV_APPLIED_AMOUNT
, F.PROJFUNC_INV_DUE_AMOUNT
, F.PROJFUNC_BACKLOG_AMOUNT
, F.INVPROC_BACKLOG_AMOUNT
, F.REVALUATION_PROJFUNC_RATE_TYPE
, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(F.REVALUATION_PROJFUNC_RATE_TYPE)REVAL_PROJFUNC_RATE_TYPE_NAME
, DECODE(F.REVALUATION_PROJFUNC_RATE_TYPE
, NULL
, NULL
, F.REVALUATION_RATE_DATE) REVALUATION_PROJFUNC_RATE_DATE
, F.REVALUATION_PROJFUNC_RATE
, F.REVALUATION_INVPROC_RATE_TYPE
, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(F.REVALUATION_INVPROC_RATE_TYPE) REVAL_INVPROC_RATE_TYPE_NAME
, DECODE(F.INVPROC_CURRENCY_CODE
, F.FUNDING_CURRENCY_CODE
, NULL
, F.REVALUATION_RATE_DATE) REVALUATION_INVPROC_RATE_DATE
, F.REVALUATION_INVPROC_RATE
, F.FUNDING_REVALUATION_FACTOR
, F.CI_ID
, P.ENABLE_TOP_TASK_CUSTOMER_FLAG
FROM PA_PROJECT_TYPES_ALL PT
, PA_TASKS T
, PA_PROJECTS_ALL P
, PA_PROJECT_FUNDINGS F
WHERE P.PROJECT_ID = F.PROJECT_ID
AND T.PROJECT_ID (+) = F.PROJECT_ID
AND T.TASK_ID (+) = F.TASK_ID
AND P.ORG_ID = PT.ORG_ID
AND PT.PROJECT_TYPE = P.PROJECT_TYPE
AND F.BUDGET_TYPE_CODE IN ('DRAFT'
, 'BASELINE')

Columns