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_GL_DR_EXCEPT_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.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) , smry.set_of_books_id FROM PA_GL_DR_EXCEPT_SUM_V SMRY, PA_PROJECTS_ALL PRJ WHERE PRJ.PROJECT_ID = SMRY.PROJECT_ID AND nvl(prj.org_id,-99) = nvl(smry.org_id,-99)

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.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)
, SMRY.SET_OF_BOOKS_ID
FROM PA_GL_DR_EXCEPT_SUM_V SMRY
, PA_PROJECTS_ALL PRJ
WHERE PRJ.PROJECT_ID = SMRY.PROJECT_ID
AND NVL(PRJ.ORG_ID
, -99) = NVL(SMRY.ORG_ID
, -99)