View: PA_CC_DIST_LINES_SUMMARIZE_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_CC_DIST_LINES_SUMMARIZE_V

View Text

SELECT SUM(DECODE(SIGN(CCD.DENOM_TRANSFER_PRICE)
, 1
, CCD.DENOM_TRANSFER_PRICE
, 0 )) ENTERED_DR
, SUM(DECODE(SIGN(CCD.DENOM_TRANSFER_PRICE)
, -1
, -1 * CCD.DENOM_TRANSFER_PRICE
, 0 )) ENTERED_CR
, SUM(DECODE(SIGN(CCD.AMOUNT)
, 1
, CCD.AMOUNT
, 0 )) ACCOUNTED_DR
, SUM(DECODE(SIGN(CCD.AMOUNT)
, -1
, -1 * CCD.AMOUNT
, 0 )) ACCOUNTED_CR
, CCD.DENOM_TP_CURRENCY_CODE
, CCD.ACCT_CURRENCY_CODE
, CCD.GL_DATE
, CCD.GL_BATCH_NAME
, CCD.LINE_TYPE
, CCD.REQUEST_ID
, CCD.DR_CODE_COMBINATION_ID
, CCD.TRANSFER_STATUS_CODE
, CCD.TRANSFER_REJECTION_CODE
, COUNT(*)
, CCD.PA_DATE
, 'DR'
, CCD.ORG_ID
FROM PA_CC_DIST_LINES_ALL CCD
WHERE CCD.TRANSFER_STATUS_CODE IN ('A'
, 'R') GROUP BY CCD.DENOM_TP_CURRENCY_CODE
, CCD.ACCT_CURRENCY_CODE
, CCD.GL_DATE
, CCD.GL_BATCH_NAME
, CCD.DR_CODE_COMBINATION_ID
, CCD.LINE_TYPE
, CCD.TRANSFER_STATUS_CODE
, CCD.TRANSFER_REJECTION_CODE
, CCD.PA_DATE
, CCD.REQUEST_ID
, CCD.ORG_ID UNION ALL SELECT SUM(DECODE(SIGN(CCD.DENOM_TRANSFER_PRICE)
, -1
, -1 * CCD.DENOM_TRANSFER_PRICE
, 0 )) ENTERED_DR
, SUM(DECODE(SIGN(CCD.DENOM_TRANSFER_PRICE)
, 1
, CCD.DENOM_TRANSFER_PRICE
, 0 )) ENTERED_CR
, SUM(DECODE(SIGN(CCD.AMOUNT)
, -1
, -1 * CCD.AMOUNT
, 0 )) ACCOUNTED_DR
, SUM(DECODE(SIGN(CCD.AMOUNT)
, 1
, CCD.AMOUNT
, 0 )) ACCOUNTED_CR
, CCD.DENOM_TP_CURRENCY_CODE
, CCD.ACCT_CURRENCY_CODE
, CCD.GL_DATE
, CCD.GL_BATCH_NAME
, CCD.LINE_TYPE
, CCD.REQUEST_ID
, CCD.CR_CODE_COMBINATION_ID
, CCD.TRANSFER_STATUS_CODE
, CCD.TRANSFER_REJECTION_CODE
, COUNT(*)
, CCD.PA_DATE
, 'CR'
, CCD.ORG_ID
FROM PA_CC_DIST_LINES_ALL CCD
WHERE CCD.TRANSFER_STATUS_CODE IN ('A'
, 'R') GROUP BY CCD.DENOM_TP_CURRENCY_CODE
, CCD.ACCT_CURRENCY_CODE
, CCD.GL_DATE
, CCD.GL_BATCH_NAME
, CCD.CR_CODE_COMBINATION_ID
, CCD.LINE_TYPE
, CCD.TRANSFER_STATUS_CODE
, CCD.TRANSFER_REJECTION_CODE
, CCD.PA_DATE
, CCD.REQUEST_ID
, CCD.ORG_ID

Columns