VIEW: APPS.PA_PROJECT_FUNDING_AUDITS

Source

View Text - Preformatted

SELECT PF.Project_ID, PRJ.Segment1, PT.Project_Type, TSK.Task_Number, AGR.Agreement_Num, HZ_P.PARTY_Number, HZ_P.PARTY_Name, PF.Revaluation_Through_Date, PF.Funding_Currency_Code, PF.Funding_Reval_Amount, PF.Funding_Inv_Applied_Amount, PF.Funding_Inv_Due_Amount, PF.Funding_Backlog_Amount, PF.Funding_Revaluation_Factor, PF.Funding_Backlog_Amount*Funding_Revaluation_Factor, PF.ProjFunc_Currency_Code, substr(PA_Multi_Currency.Get_User_Conversion_Type(PF.Revaluation_ProjFunc_Rate_Type),1,30), PF.Revaluation_Rate_Date, PF.Revaluation_ProjFunc_Rate, PF.ProjFunc_Backlog_Amount, PF.ProjFunc_Inv_Applied_Amount, PF.ProjFunc_Inv_Due_Amount, PF.ProjFunc_Realized_Gains_Amt, PF.ProjFunc_Realized_Losses_Amt, PF.ProjFunc_Revalued_Amount, PF.ProjFunc_Reval_Amount, PF.ProjFunc_Allocated_Amount, PF.InvProc_Currency_Code, substr(PA_Multi_Currency.Get_User_Conversion_Type(PF.Revaluation_InvProc_Rate_Type),1,30), PF.Revaluation_Rate_Date, PF.Revaluation_InvProc_Rate, PF.InvProc_Backlog_Amount, PF.InvProc_Revalued_Amount, PF.InvProc_Reval_Amount, PF.InvProc_Allocated_Amount, EV.Event_Num, EV.Event_Type, LK.Meaning, EV.Bill_Trans_Currency_Code, EV.Bill_Trans_Rev_Amount FROM PA_Project_Types PT, PA_Project_Fundings PF, PA_Projects PRJ, PA_Tasks TSK, PA_Agreements AGR, HZ_PARTIES HZ_P, HZ_CUST_ACCOUNTS HZ_C, PA_Events EV, PA_Event_Types ET, PA_Lookups LK WHERE PF.Project_ID = PRJ.Project_ID AND PT.Project_Type = PRJ.Project_Type AND PT.org_id = PRJ.org_id AND PF.Funding_Category = 'REVALUATION' AND PF.Agreement_ID = AGR.Agreement_ID AND AGR.Customer_ID = HZ_C.CUST_ACCOUNT_ID AND HZ_C.PARTY_ID = HZ_P.Party_id AND PF.Project_ID = TSK.Project_ID (+) AND PF.Task_ID = TSK.Task_ID (+) AND EV.Project_Funding_ID (+) = PF.Project_Funding_ID AND EV.Project_ID (+) = PF.Project_ID AND LK.Lookup_Type (+) = 'EVENT TYPE CLASSIFICATION' AND LK.Lookup_Code (+) = ET.Event_Type_Classification AND EV.Event_Type = ET.Event_Type (+)

View Text - HTML Formatted

SELECT PF.PROJECT_ID
, PRJ.SEGMENT1
, PT.PROJECT_TYPE
, TSK.TASK_NUMBER
, AGR.AGREEMENT_NUM
, HZ_P.PARTY_NUMBER
, HZ_P.PARTY_NAME
, PF.REVALUATION_THROUGH_DATE
, PF.FUNDING_CURRENCY_CODE
, PF.FUNDING_REVAL_AMOUNT
, PF.FUNDING_INV_APPLIED_AMOUNT
, PF.FUNDING_INV_DUE_AMOUNT
, PF.FUNDING_BACKLOG_AMOUNT
, PF.FUNDING_REVALUATION_FACTOR
, PF.FUNDING_BACKLOG_AMOUNT*FUNDING_REVALUATION_FACTOR
, PF.PROJFUNC_CURRENCY_CODE
, SUBSTR(PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(PF.REVALUATION_PROJFUNC_RATE_TYPE)
, 1
, 30)
, PF.REVALUATION_RATE_DATE
, PF.REVALUATION_PROJFUNC_RATE
, PF.PROJFUNC_BACKLOG_AMOUNT
, PF.PROJFUNC_INV_APPLIED_AMOUNT
, PF.PROJFUNC_INV_DUE_AMOUNT
, PF.PROJFUNC_REALIZED_GAINS_AMT
, PF.PROJFUNC_REALIZED_LOSSES_AMT
, PF.PROJFUNC_REVALUED_AMOUNT
, PF.PROJFUNC_REVAL_AMOUNT
, PF.PROJFUNC_ALLOCATED_AMOUNT
, PF.INVPROC_CURRENCY_CODE
, SUBSTR(PA_MULTI_CURRENCY.GET_USER_CONVERSION_TYPE(PF.REVALUATION_INVPROC_RATE_TYPE)
, 1
, 30)
, PF.REVALUATION_RATE_DATE
, PF.REVALUATION_INVPROC_RATE
, PF.INVPROC_BACKLOG_AMOUNT
, PF.INVPROC_REVALUED_AMOUNT
, PF.INVPROC_REVAL_AMOUNT
, PF.INVPROC_ALLOCATED_AMOUNT
, EV.EVENT_NUM
, EV.EVENT_TYPE
, LK.MEANING
, EV.BILL_TRANS_CURRENCY_CODE
, EV.BILL_TRANS_REV_AMOUNT
FROM PA_PROJECT_TYPES PT
, PA_PROJECT_FUNDINGS PF
, PA_PROJECTS PRJ
, PA_TASKS TSK
, PA_AGREEMENTS AGR
, HZ_PARTIES HZ_P
, HZ_CUST_ACCOUNTS HZ_C
, PA_EVENTS EV
, PA_EVENT_TYPES ET
, PA_LOOKUPS LK
WHERE PF.PROJECT_ID = PRJ.PROJECT_ID
AND PT.PROJECT_TYPE = PRJ.PROJECT_TYPE
AND PT.ORG_ID = PRJ.ORG_ID
AND PF.FUNDING_CATEGORY = 'REVALUATION'
AND PF.AGREEMENT_ID = AGR.AGREEMENT_ID
AND AGR.CUSTOMER_ID = HZ_C.CUST_ACCOUNT_ID
AND HZ_C.PARTY_ID = HZ_P.PARTY_ID
AND PF.PROJECT_ID = TSK.PROJECT_ID (+)
AND PF.TASK_ID = TSK.TASK_ID (+)
AND EV.PROJECT_FUNDING_ID (+) = PF.PROJECT_FUNDING_ID
AND EV.PROJECT_ID (+) = PF.PROJECT_ID
AND LK.LOOKUP_TYPE (+) = 'EVENT TYPE CLASSIFICATION'
AND LK.LOOKUP_CODE (+) = ET.EVENT_TYPE_CLASSIFICATION
AND EV.EVENT_TYPE = ET.EVENT_TYPE (+)