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.

VIEW: APPS.PA_DR_EXCEPTIONS_DET_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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