VIEW: APPS.FPA_AW_YEAR_ATTS_V

Source

View Text - Preformatted

SELECT cal_hier, year, year_number, start_date from table ( olap_table(fpa_utilities_pvt.aw_space_name || ' duration query','fpa_year_tbl', 'call lmt_year_prg(''YEAR'')', 'DIMENSION cal_hier from CAL_PERIOD_TYPE_D               DIMENSION year from time_d            WITH ATTRIBUTE year_number from time_time_identifier_r  		  ATTRIBUTE start_date from start_date_year_r'))

View Text - HTML Formatted

SELECT CAL_HIER
, YEAR
, YEAR_NUMBER
, START_DATE
FROM TABLE ( OLAP_TABLE(FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_YEAR_TBL'
, 'CALL LMT_YEAR_PRG(''YEAR'')'
, 'DIMENSION CAL_HIER
FROM CAL_PERIOD_TYPE_D DIMENSION YEAR
FROM TIME_D WITH ATTRIBUTE YEAR_NUMBER
FROM TIME_TIME_IDENTIFIER_R ATTRIBUTE START_DATE
FROM START_DATE_YEAR_R'))