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: FII_BIS_APIPY_DRILL_V

Product:	FII - Financial Intelligence (Obsolete)
Description:	Internal view used for AP Invoice Payments Drill Down PM Viewer Reports
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ICX_SESSION_ID
, REPORT_NAME
, REPORTING_LEVEL
, REPORT_DATE
, TRANSACTION_TYPE
, INVOICE_SOURCE
, PERIOD_NUMBER
, PERIOD_NAME
, REPORT_PERIOD
, CY_AMOUNT
, CY_COUNT
, PY_AMOUNT
, PY_COUNT
FROM ( SELECT ICX_SESSION_ID
, REPORT_NAME
, ATTRIBUTE4 REPORTING_LEVEL
, REPORT_DATE
, ATTRIBUTE2 TRANSACTION_TYPE
, ATTRIBUTE3 INVOICE_SOURCE
, TO_NUMBER(DIMENSION1) PERIOD_NUMBER
, DIMENSION2 PERIOD_NAME
, DIMENSION3 REPORT_PERIOD
, SUM(DECODE(ATTRIBUTE1
, 'AMOUNT'
, DECODE(DIMENSION3
, 'PTD'
, MEASURE1
, 'QTD'
, MEASURE2
, 'YTD'
, MEASURE3
, 0)
, 0)) CY_AMOUNT
, SUM(DECODE(ATTRIBUTE1
, 'COUNT'
, DECODE(DIMENSION3
, 'PTD'
, MEASURE1
, 'QTD'
, MEASURE2
, 'YTD'
, MEASURE3
, 0)
, 0)) CY_COUNT
, SUM(DECODE(ATTRIBUTE1
, 'AMOUNT'
, DECODE(DIMENSION3
, 'PY PTD'
, MEASURE4
, 'PY QTD'
, MEASURE5
, 'PY YTD'
, MEASURE6
, 0)
, 0)) PY_AMOUNT
, SUM(DECODE(ATTRIBUTE1
, 'COUNT'
, DECODE(DIMENSION3
, 'PY PTD'
, MEASURE4
, 'PY QTD'
, MEASURE5
, 'PY YTD'
, MEASURE6
, 0)
, 0)) PY_COUNT
FROM FII_BIS_APIPY_TEMP
WHERE ATTRIBUTE4 = 'LINES'
AND REPORT_NAME = 'FII_PARAMETER_FIIAPIPY' GROUP BY ICX_SESSION_ID
, REPORT_NAME
, ATTRIBUTE4
, REPORT_DATE
, ATTRIBUTE2
, ATTRIBUTE3
, DIMENSION1
, DIMENSION2
, DIMENSION3 )

Columns

Name
ICX_SESSION_ID
REPORT_NAME
REPORTING_LEVEL
REPORT_DATE
TRANSACTION_TYPE
INVOICE_SOURCE
PERIOD_NUMBER
PERIOD_NAME
REPORT_PERIOD
CY_AMOUNT
CY_COUNT
PY_AMOUNT
PY_COUNT