VIEW: APPS.RCI_FS_CERT_V

Source

View Text - Preformatted

SELECT acb.certification_id AS id, actl.certification_name AS value ,ftep.name as period_name,fteq.name as qtr_name,ftey.name as year_name,ftd.ent_period_id as ent_period_id ,ftd.ent_qtr_id as ent_qtr_id,ftd.ent_year_id as ent_year_id FROM amw_certification_b acb, amw_certification_tl actl,amw_gl_periods_v agpv ,fii_time_day ftd,fii_time_ent_period ftep,fii_time_ent_qtr fteq,fii_time_ent_year ftey WHERE acb.certification_id = actl.certification_id and acb.object_type = 'FIN_STMT' AND actl.language = USERENV('lang') and acb.certification_period_name = agpv.period_name and acb.certification_period_set_name = agpv.period_set_name and to_number(to_char(agpv.end_date,'J')) = ftd.report_date_julian and ftd.ent_period_id = ftep.ent_period_id and ftd.ent_qtr_id = fteq.ent_qtr_id and ftd.ent_year_id = ftey.ent_year_id

View Text - HTML Formatted

SELECT ACB.CERTIFICATION_ID AS ID
, ACTL.CERTIFICATION_NAME AS VALUE
, FTEP.NAME AS PERIOD_NAME
, FTEQ.NAME AS QTR_NAME
, FTEY.NAME AS YEAR_NAME
, FTD.ENT_PERIOD_ID AS ENT_PERIOD_ID
, FTD.ENT_QTR_ID AS ENT_QTR_ID
, FTD.ENT_YEAR_ID AS ENT_YEAR_ID
FROM AMW_CERTIFICATION_B ACB
, AMW_CERTIFICATION_TL ACTL
, AMW_GL_PERIODS_V AGPV
, FII_TIME_DAY FTD
, FII_TIME_ENT_PERIOD FTEP
, FII_TIME_ENT_QTR FTEQ
, FII_TIME_ENT_YEAR FTEY
WHERE ACB.CERTIFICATION_ID = ACTL.CERTIFICATION_ID
AND ACB.OBJECT_TYPE = 'FIN_STMT'
AND ACTL.LANGUAGE = USERENV('LANG')
AND ACB.CERTIFICATION_PERIOD_NAME = AGPV.PERIOD_NAME
AND ACB.CERTIFICATION_PERIOD_SET_NAME = AGPV.PERIOD_SET_NAME
AND TO_NUMBER(TO_CHAR(AGPV.END_DATE
, 'J')) = FTD.REPORT_DATE_JULIAN
AND FTD.ENT_PERIOD_ID = FTEP.ENT_PERIOD_ID
AND FTD.ENT_QTR_ID = FTEQ.ENT_QTR_ID
AND FTD.ENT_YEAR_ID = FTEY.ENT_YEAR_ID