eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_PROJECT_FUNDING_AUDITS

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_PROJECT_FUNDING_AUDITS

View Text

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 (+)

Columns

Name
PROJECT_ID
PROJECT_NUMBER
PROJECT_TYPE
TASK_NUMBER
AGREEMENT_NUMBER
CUSTOMER_NUMBER
CUSTOMER_NAME
REVALUATION_DATE
FUNDING_CURRENCY
FUNDING_BASELINED_FUNDING
FUNDING_AMOUNT_APPLIED
FUNDING_AMOUNT_DUE
FUNDING_BACKLOG
FUNDING_REVALUATION_FACTOR
FUNDING_BACKLOG_SUBJ_REVAL
REVPROC_CURRENCY
REVPROC_RATE_TYPE
REVPROC_RATE_DATE
REVPROC_RATE
REVPROC_BACKLOG_REVALUED
REVPROC_AMOUNT_APPLIED
REVPROC_AMOUNT_DUE_REVALED
REVPROC_REALIZED_GAINS
REVPROC_REALIZED_LOSSES
REVPROC_BASELINED_REVALUED
REVPROC_BASELINED_BFR_REVAL
REVPROC_REVALUATION_ADJ
INVPROC_CURRENCY
INVPROC_RATE_TYPE
INVPROC_RATE_DATE
INVPROC_RATE
INVPROC_BACKLOG_RAVALED
INVPROC_BASELINED_REVALED
INVPROC_BASELINED_BFR_REVAL
INVPROC_REVALUATION_ADJ
EVENT_NUMBER
EVENT_TYPE
EVENT_CLASSIFICATION
EVENT_CURRENCY
EVENT_AMOUNT