View: FII_BIS_GLSUM_V

View Text

SELECT GFM.SET_OF_BOOKS_ID
, GSOB.NAME SET_OF_BOOKS_NAME
, (SELECT ORG.NAME
FROM HR_ALL_ORGANIZATION_UNITS ORG
WHERE ORG.ORGANIZATION_ID = FND_PROFILE.VALUE('ORG_ID')
AND ROWNUM =1) ORG_NAME
, GSOB.CURRENCY_CODE
, PS.PERIOD_YEAR
, PS.PERIOD_NAME
, PS.END_DATE
, PS.QUARTER_NUM
, DECODE(GFM.FIN_METRIC_CODE
, 'REVENUE'
, 1
, 'EXPENSE'
, 2
, 'NET_INCOME'
, 3
, 'EPS_DILUTED'
, 4
, 'PROFIT_MARGIN'
, 5
, 'CONTRIB_MARGIN'
, 6
, 'CURRENT_RATIO'
, 7
, 'DSO'
, 8
, 'AR_TURNOVER'
, 9 ) ORDER_BY
, L.MEANING FIN_METRIC
, GFM.FIN_METRIC_CODE FIN_CODE
, GFM.QUARTER1_VALUE Q1_VALUE
, GFM.QUARTER2_VALUE Q2_VALUE
, GFM.QUARTER3_VALUE Q3_VALUE
, GFM.QUARTER4_VALUE Q4_VALUE
, TO_NUMBER(GFM.YEAR_VALUE) YTD
, SUBSTRB(GFM.REPORT_NAME
, 1
, 100) DETAIL_REPORT
, SUBSTRB(GFM.REPORT_PARAMETERS
, 1
, 200) REPORT_PARAMETERS
FROM GL_OASIS_FIN_METRICS GFM
, GL_LOOKUPS L
, GL_SETS_OF_BOOKS GSOB
, GL_PERIOD_STATUSES PS
WHERE L.LOOKUP_TYPE = 'FIN_METRIC_CODES'
AND L.LOOKUP_CODE = GFM.FIN_METRIC_CODE
AND GFM.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND PS.SET_OF_BOOKS_ID = GFM.SET_OF_BOOKS_ID
AND PS.EFFECTIVE_PERIOD_NUM = GFM.EFFECTIVE_PERIOD_NUM
AND PS.APPLICATION_ID = 101

Columns