[Home] [Help]
View: FII_BIS_APIPY_DRILL_V
Product: | FII - Financial Intelligence |
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 |