[Home] [Help]
View: PA_DR_EXCEPTIONS_DET_MRC_V
Product: | PA - Projects |
Description: | Is a view that identifies the Draft Revenues that prevent a period from being - Retrofitted |
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.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_MRC_V SMRY
, PA_PROJECTS_ALL PRJ
WHERE PRJ.PROJECT_ID = SMRY.PROJECT_ID
Columns
Name |
SET_OF_BOOKS_ID |
DRAFT_REVENUE_NUM |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_CURRENCY_CODE |
PA_DATE |
PERIOD_NAME |
AGREEMENT_ID |
AMOUNT |
TRANSFER_REJECTION_REASON |
EXCEPTION_REASON |
CORRECTION_ACTION |