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_CC_DIST_SUM_REP_MRC_V

Product:	PA - Projects
Description:	This will select data from pa_draft_invoices, pa_cc_dist_lines_all, pa_mc_cc_dist_lines_all
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SUM(DECODE(SIGN(PA.DENOM_TRANSFER_PRICE)
, 1
, PA.DENOM_TRANSFER_PRICE
, 0 )) ENTERED_DR
, SUM(DECODE(SIGN(PA.DENOM_TRANSFER_PRICE)
, -1
, -1 * PA.DENOM_TRANSFER_PRICE
, 0 )) ENTERED_CR
, SUM(DECODE(SIGN(MC.AMOUNT)
, 1
, MC.AMOUNT
, 0 )) ACCOUNTED_DR
, SUM(DECODE(SIGN(MC.AMOUNT)
, -1
, -1 * MC.AMOUNT
, 0 )) ACCOUNTED_CR
, PA.DENOM_TP_CURRENCY_CODE
, MC.ACCT_CURRENCY_CODE
, PA.GL_DATE
, MC.GL_BATCH_NAME
, MC.LINE_TYPE
, MC.REQUEST_ID
, PA.DR_CODE_COMBINATION_ID
, MC.TRANSFER_STATUS_CODE
, MC.TRANSFER_REJECTION_CODE
, COUNT(*)
, PA.PA_DATE
, 'DR'
FROM PA_CC_DIST_LINES PA
, PA_MC_CC_DIST_LINES_ALL MC
WHERE MC.EXPENDITURE_ITEM_ID = PA.EXPENDITURE_ITEM_ID
AND MC.PRC_ASSIGNMENT_ID = -99
AND MC.LINE_NUM = PA.LINE_NUM
AND MC.LINE_TYPE = PA.LINE_TYPE
AND MC.TRANSFER_STATUS_CODE IN ('A'
, 'R')
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10))
, -99) GROUP BY PA.DENOM_TP_CURRENCY_CODE
, MC.ACCT_CURRENCY_CODE
, PA.GL_DATE
, MC.GL_BATCH_NAME
, PA.DR_CODE_COMBINATION_ID
, MC.LINE_TYPE
, MC.TRANSFER_STATUS_CODE
, MC.TRANSFER_REJECTION_CODE
, PA.PA_DATE
, MC.REQUEST_ID UNION ALL SELECT SUM(DECODE(SIGN(PA.DENOM_TRANSFER_PRICE)
, -1
, -1 * PA.DENOM_TRANSFER_PRICE
, 0 )) ENTERED_DR
, SUM(DECODE(SIGN(PA.DENOM_TRANSFER_PRICE)
, 1
, PA.DENOM_TRANSFER_PRICE
, 0 )) ENTERED_CR
, SUM(DECODE(SIGN(MC.AMOUNT)
, -1
, -1 * MC.AMOUNT
, 0 )) ACCOUNTED_DR
, SUM(DECODE(SIGN(MC.AMOUNT)
, 1
, MC.AMOUNT
, 0 )) ACCOUNTED_CR
, PA.DENOM_TP_CURRENCY_CODE
, MC.ACCT_CURRENCY_CODE
, PA.GL_DATE
, MC.GL_BATCH_NAME
, MC.LINE_TYPE
, MC.REQUEST_ID
, PA.CR_CODE_COMBINATION_ID
, MC.TRANSFER_STATUS_CODE
, MC.TRANSFER_REJECTION_CODE
, COUNT(*)
, PA.PA_DATE
, 'CR'
FROM PA_CC_DIST_LINES PA
, PA_MC_CC_DIST_LINES_ALL MC
WHERE MC.EXPENDITURE_ITEM_ID = PA.EXPENDITURE_ITEM_ID
AND MC.PRC_ASSIGNMENT_ID = -99
AND MC.LINE_NUM = PA.LINE_NUM
AND MC.LINE_TYPE = PA.LINE_TYPE
AND MC.TRANSFER_STATUS_CODE IN ('A'
, 'R')
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10))
, -99) GROUP BY PA.DENOM_TP_CURRENCY_CODE
, MC.ACCT_CURRENCY_CODE
, PA.GL_DATE
, MC.GL_BATCH_NAME
, PA.CR_CODE_COMBINATION_ID
, MC.LINE_TYPE
, MC.TRANSFER_STATUS_CODE
, MC.TRANSFER_REJECTION_CODE
, PA.PA_DATE
, MC.REQUEST_ID

Columns

Name
ENTERED_DR
ENTERED_CR
ACCOUNTED_DR
ACCOUNTED_CR
DENOM_TP_CURRENCY_CODE
ACCT_CURRENCY_CODE
GL_DATE
GL_BATCH_NAME
LINE_TYPE
REQUEST_ID
CODE_COMBINATION_ID
TRANSFER_STATUS_CODE
TRANSFER_REJECTION_CODE
NUMBER_OF_LINES
PA_DATE
DEBIT_CREDIT_FLAG