FND Design Data [Home] [Help]

View: PA_PROJ_FUND_FORMS_MRC_V

Product: PA - Projects
Description: - 10SC Only
Implementation/DBA Data: Not implemented in this database
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
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('TRANSLATION'
, 'SECURED_DATA'))
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, P.NAME
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('TRANSLATION'
, 'SECURED_DATA'))
, F.TASK_ID
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, T.TASK_NUMBER
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('TRANSLATION'
, 'SECURED_DATA'))
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, T.TASK_NAME
, PA_PROJ_ELEMENTS_UTILS.GET_PA_LOOKUP_MEANING('TRANSLATION'
, 'SECURED_DATA'))
, 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
, MC.CURRENCY_CODE REP_PROJFUNC_CURRENCY_CODE
, PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(MC.RATE_TYPE) REP_PROJFUNC_RATE_TYPE_NAME
, MC.CONVERSION_DATE REP_PROJFUNC_RATE_DATE
, MC.EXCHANGE_RATE REP_PROJFUNC_EXCHANGE_RATE
, MC.ALLOCATED_AMOUNT REP_PROJFUNC_ALLOCATED_AMT
, MC.REALIZED_GAINS_AMT REP_PROJFUNC_RLZD_GAINS_AMT
, MC.REALIZED_LOSSES_AMT REP_PROJFUNC_RLZD_LOSSES_AMT
, MC.INV_APPLIED_AMOUNT REP_PROJFUNC_INV_APPLIED_AMT
, MC.INV_DUE_AMOUNT REP_PROJFUNC_INV_DUE_AMT
, MC.BACKLOG_AMOUNT REP_PROJFUNC_BACKLOG_AMT
, F.CI_ID
FROM PA_PROJECT_TYPES_ALL PT
, PA_TASKS T
, PA_PROJECTS_ALL P
, PA_PROJECT_FUNDINGS F
, PA_MC_PROJECT_FUNDINGS MC
WHERE P.PROJECT_ID = F.PROJECT_ID
AND T.PROJECT_ID (+) = F.PROJECT_ID
AND T.TASK_ID (+) = F.TASK_ID
AND NVL(P.ORG_ID
, -99) = NVL(PT.ORG_ID
, -99)
AND PT.PROJECT_TYPE = P.PROJECT_TYPE
AND F.BUDGET_TYPE_CODE IN ('DRAFT'
, 'BASELINE')
AND MC.PROJECT_FUNDING_ID = F.PROJECT_FUNDING_ID
AND MC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10))
, -99)

Columns

Name
ROW_ID
PROJECT_FUNDING_ID
PROJECT_ID
PROJECT_NUMBER
PROJECT_NAME
TASK_ID
TASK_NUMBER
TASK_NAME
AGREEMENT_ID
BUDGET_TYPE_CODE
ALLOCATED_AMOUNT
DATE_ALLOCATED
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
CREATED_BY_PERSON_NAME
LAST_UPDATE_LOGIN
ALLOWABLE_FUNDING_LEVEL_CODE
PROJECT_TYPE_CLASS_CODE
PM_FUNDING_REFERENCE
PM_PRODUCT_CODE
FUNDING_CURRENCY_CODE
PROJECT_CURRENCY_CODE
PROJECT_RATE_TYPE
PROJECT_RATE_TYPE_NAME
PROJECT_BIL_RATE_DATE_CODE
PROJECT_RATE_DATE
PROJECT_EXCHANGE_RATE
PROJECT_ALLOCATED_AMOUNT
PROJFUNC_CURRENCY_CODE
PROJFUNC_RATE_TYPE
PROJFUNC_RATE_TYPE_NAME
PROJFUNC_BIL_RATE_DATE_CODE
PROJFUNC_RATE_DATE
PROJFUNC_EXCHANGE_RATE
PROJFUNC_ALLOCATED_AMOUNT
INVPROC_CURRENCY_TYPE
INVPROC_CURRENCY_CODE
INVPROC_RATE_TYPE
INVPROC_RATE_DATE
INVPROC_EXCHANGE_RATE
INVPROC_ALLOCATED_AMOUNT
REVPROC_CURRENCY_CODE
REVPROC_RATE_TYPE
REVPROC_RATE_DATE
REVPROC_EXCHANGE_RATE
REVPROC_ALLOCATED_AMOUNT
FUNDING_CATEGORY
FUNDING_INV_APPLIED_AMOUNT
FUNDING_INV_DUE_AMOUNT
FUNDING_BACKLOG_AMOUNT
PROJFUNC_REALIZED_GAINS_AMT
PROJFUNC_REALIZED_LOSSES_AMT
PROJFUNC_INV_APPLIED_AMOUNT
PROJFUNC_INV_DUE_AMOUNT
PROJFUNC_BACKLOG_AMOUNT
INVPROC_BACKLOG_AMOUNT
REVALUATION_PROJFUNC_RATE_TYPE
REVAL_PROJFUNC_RATE_TYPE_NAME
REVALUATION_PROJFUNC_RATE_DATE
REVALUATION_PROJFUNC_RATE
REVALUATION_INVPROC_RATE_TYPE
REVAL_INVPROC_RATE_TYPE_NAME
REVALUATION_INVPROC_RATE_DATE
REVALUATION_INVPROC_RATE
FUNDING_REVALUATION_FACTOR
REP_PROJFUNC_CURRENCY_CODE
REP_PROJFUNC_RATE_TYPE_NAME
REP_PROJFUNC_RATE_DATE
REP_PROJFUNC_EXCHANGE_RATE
REP_PROJFUNC_ALLOCATED_AMT
REP_PROJFUNC_RLZD_GAINS_AMT
REP_PROJFUNC_RLZD_LOSSES_AMT
REP_PROJFUNC_INV_APPLIED_AMT
REP_PROJFUNC_INV_DUE_AMT
REP_PROJFUNC_BACKLOG_AMT
CI_ID