VIEW: APPS.PA_PROJECT_FUNDINGS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')