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_DR_EXCEPTIONS_DET_V

Product:	PA - Projects
Description:	Is a view that identifies the Draft Revenues that prevent a period from being closed.
Implementation/DBA Data:	APPS.PA_DR_EXCEPTIONS_DET_V

View Text

SELECT SMRY.DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM
, SMRY.PROJECT_ID PROJECT_ID
, PRJ.SEGMENT1 PROJECT_NUMBER
, PRJ.PROJECT_CURRENCY_CODE
, SMRY.PA_DATE PA_DATE
, SMRY.PERIOD_NAME PERIOD_NAME
, SMRY.AGREEMENT_ID AGREEMENT_ID
, SMRY.AMOUNT AMOUNT
, SMRY.TRANSFER_REJECTION_REASON TRANSFER_REJECTION_REASON
, SMRY.EXCEPTION_REASON EXCEPTION_REASON
, SMRY.CORRECTIVE_ACTION CORRECTION_ACTION
FROM PA_DR_EXCEPTIONS_SUM_V SMRY
, PA_PROJECTS_ALL PRJ
WHERE PRJ.PROJECT_ID = SMRY.PROJECT_ID

Columns

Name
DRAFT_REVENUE_NUM
PROJECT_ID
PROJECT_NUMBER
PROJECT_CURRENCY_CODE
PA_DATE
PERIOD_NAME
AGREEMENT_ID
AMOUNT
TRANSFER_REJECTION_REASON
EXCEPTION_REASON
CORRECTION_ACTION