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_GL_DR_EXCEPT_DET_MRC_V

Product:	PA - Projects
Description:	pa_gl_dr_except_det_mrc_v is a view that identifies the Draft Revenues that prevent a period from being closed.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SMRY.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, SMRY.DRAFT_REVENUE_NUM DRAFT_REVENUE_NUM
, SMRY.PROJECT_ID PROJECT_ID
, PRJ.SEGMENT1 PROJECT_NUMBER
, PRJ.PROJECT_CURRENCY_CODE
, SMRY.GL_DATE GL_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
, SMRY.ORG_ID ORG_ID
, SMRY.SAME_PA_GL_PERIOD
, PA_EXPENDITURES_UTILS.GETORGTLNAME(SMRY.ORG_ID)
FROM PA_GL_DR_EXCEPT_SUM_MRC_V SMRY
, PA_PROJECTS_ALL PRJ
WHERE PRJ.PROJECT_ID = SMRY.PROJECT_ID
AND NVL(PRJ.ORG_ID
, -99) = NVL(SMRY.ORG_ID
, -99)

Columns

Name
SET_OF_BOOKS_ID
DRAFT_REVENUE_NUM
PROJECT_ID
PROJECT_NUMBER
PROJECT_CURRENCY_CODE
GL_DATE
PERIOD_NAME
AGREEMENT_ID
AMOUNT
TRANSFER_REJECTION_REASON
EXCEPTION_REASON
CORRECTION_ACTION
ORG_ID
SAME_PA_GL_PERIOD
OU_NAME