[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 |