VIEW: APPS.PA_PROJ_FUND_REVAL_V

Source

View Text - Preformatted

SELECT F.ROWID ROW_ID , F.PROJECT_ID , DECODE(pa_security.allow_query(P.project_id), 'Y', P.SEGMENT1, SUBSTR(LK.Meaning,1,25)) , DECODE(pa_security.allow_query(P.project_id), 'Y', P.NAME, SUBSTR(LK.Meaning,1,30)) , F.TASK_ID , DECODE(pa_security.allow_query(P.project_id), 'Y', T.TASK_NUMBER, SUBSTR(LK.Meaning,1,25)) , DECODE(pa_security.allow_query(P.project_id), 'Y', T.TASK_NAME, SUBSTR(LK.Meaning,1,20)) , F.AGREEMENT_ID , A.AGREEMENT_NUM , A.CUSTOMER_ID , HZ_P.PARTY_NAME , HZ_P.PARTY_NUMBER , F.REVALUATION_THROUGH_DATE , F.REVALUATION_RATE_DATE , F.REVALUATION_PROJFUNC_RATE_TYPE , C1.USER_CONVERSION_TYPE PROJFUNC_RATE_TYPE_NAME , F.REVALUATION_INVPROC_RATE_TYPE , C2.USER_CONVERSION_TYPE INVPROC_RATE_TYPE_NAME , F.REVALUATION_PROJFUNC_RATE , F.REVALUATION_INVPROC_RATE , F.FUNDING_CURRENCY_CODE , SPF.TOTAL_BASELINED_AMOUNT FUNDING_BASELINED_AMOUNT , F.PROJFUNC_CURRENCY_CODE , SPF.PROJFUNC_BASELINED_AMOUNT PROJFUNC_REVLD_BASELINED_AMT , F.PROJFUNC_REVAL_AMOUNT PROJFUNC_BASELINED_AMOUNT , F.PROJFUNC_ALLOCATED_AMOUNT PROJFUNC_ADJUSTMENT_AMOUNT , F.INVPROC_CURRENCY_CODE , SPF.INVPROC_BASELINED_AMOUNT INVPROC_REVLD_BASELINED_AMT , F.INVPROC_REVAL_AMOUNT INVPROC_BASELINED_AMOUNT , F.INVPROC_ALLOCATED_AMOUNT INVPROC_ADJUSTMENT_AMOUNT , decode (F.BUDGET_TYPE_CODE, 'BASELINE' , 'Yes', 'No') , F.REQUEST_ID FROM PA_PROJECT_FUNDINGS F, PA_SUMMARY_PROJECT_FUNDINGS SPF, PA_AGREEMENTS_ALL A, PA_PROJECTS P, PA_TASKS T, HZ_PARTIES HZ_P, HZ_CUST_ACCOUNTS HZ_C, PA_LOOKUPS LK, PA_CONVERSION_TYPES_V C1, PA_CONVERSION_TYPES_V C2 WHERE P.PROJECT_ID = F.PROJECT_ID AND T.PROJECT_ID (+) = F.PROJECT_ID AND T.TASK_ID (+) = F.TASK_ID AND SPF.PROJECT_ID = F.PROJECT_ID AND nvl(SPF.TASK_ID,0) = NVL(F.TASK_ID,0) AND SPF.AGREEMENT_ID = F.AGREEMENT_ID AND A.AGREEMENT_ID = F.AGREEMENT_ID AND HZ_C.CUST_ACCOUNT_ID = A.CUSTOMER_ID AND HZ_C.PARTY_ID = HZ_P.party_id AND LK.lookup_type = 'TRANSLATION' AND LK.lookup_code = 'SECURED_DATA' AND F.revaluation_projfunc_rate_type = c1.conversion_type(+) AND F.revaluation_invproc_rate_type = c2.conversion_type(+)

View Text - HTML Formatted

SELECT F.ROWID ROW_ID
, F.PROJECT_ID
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, P.SEGMENT1
, SUBSTR(LK.MEANING
, 1
, 25))
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, P.NAME
, SUBSTR(LK.MEANING
, 1
, 30))
, F.TASK_ID
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, T.TASK_NUMBER
, SUBSTR(LK.MEANING
, 1
, 25))
, DECODE(PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID)
, 'Y'
, T.TASK_NAME
, SUBSTR(LK.MEANING
, 1
, 20))
, F.AGREEMENT_ID
, A.AGREEMENT_NUM
, A.CUSTOMER_ID
, HZ_P.PARTY_NAME
, HZ_P.PARTY_NUMBER
, F.REVALUATION_THROUGH_DATE
, F.REVALUATION_RATE_DATE
, F.REVALUATION_PROJFUNC_RATE_TYPE
, C1.USER_CONVERSION_TYPE PROJFUNC_RATE_TYPE_NAME
, F.REVALUATION_INVPROC_RATE_TYPE
, C2.USER_CONVERSION_TYPE INVPROC_RATE_TYPE_NAME
, F.REVALUATION_PROJFUNC_RATE
, F.REVALUATION_INVPROC_RATE
, F.FUNDING_CURRENCY_CODE
, SPF.TOTAL_BASELINED_AMOUNT FUNDING_BASELINED_AMOUNT
, F.PROJFUNC_CURRENCY_CODE
, SPF.PROJFUNC_BASELINED_AMOUNT PROJFUNC_REVLD_BASELINED_AMT
, F.PROJFUNC_REVAL_AMOUNT PROJFUNC_BASELINED_AMOUNT
, F.PROJFUNC_ALLOCATED_AMOUNT PROJFUNC_ADJUSTMENT_AMOUNT
, F.INVPROC_CURRENCY_CODE
, SPF.INVPROC_BASELINED_AMOUNT INVPROC_REVLD_BASELINED_AMT
, F.INVPROC_REVAL_AMOUNT INVPROC_BASELINED_AMOUNT
, F.INVPROC_ALLOCATED_AMOUNT INVPROC_ADJUSTMENT_AMOUNT
, DECODE (F.BUDGET_TYPE_CODE
, 'BASELINE'
, 'YES'
, 'NO')
, F.REQUEST_ID
FROM PA_PROJECT_FUNDINGS F
, PA_SUMMARY_PROJECT_FUNDINGS SPF
, PA_AGREEMENTS_ALL A
, PA_PROJECTS P
, PA_TASKS T
, HZ_PARTIES HZ_P
, HZ_CUST_ACCOUNTS HZ_C
, PA_LOOKUPS LK
, PA_CONVERSION_TYPES_V C1
, PA_CONVERSION_TYPES_V C2
WHERE P.PROJECT_ID = F.PROJECT_ID
AND T.PROJECT_ID (+) = F.PROJECT_ID
AND T.TASK_ID (+) = F.TASK_ID
AND SPF.PROJECT_ID = F.PROJECT_ID
AND NVL(SPF.TASK_ID
, 0) = NVL(F.TASK_ID
, 0)
AND SPF.AGREEMENT_ID = F.AGREEMENT_ID
AND A.AGREEMENT_ID = F.AGREEMENT_ID
AND HZ_C.CUST_ACCOUNT_ID = A.CUSTOMER_ID
AND HZ_C.PARTY_ID = HZ_P.PARTY_ID
AND LK.LOOKUP_TYPE = 'TRANSLATION'
AND LK.LOOKUP_CODE = 'SECURED_DATA'
AND F.REVALUATION_PROJFUNC_RATE_TYPE = C1.CONVERSION_TYPE(+)
AND F.REVALUATION_INVPROC_RATE_TYPE = C2.CONVERSION_TYPE(+)