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.

APPS.RCI_PROC_CERT_SUMM_PKG dependencies on AMW_GL_PERIODS_V

Line 197: ,amw_gl_periods_v agpv

193: ,amw_certification_vl acv
194: ,RCI_BP_CERT_RESULT_V rbcrv
195: ,RCI_FS_CERT_STATUS_V rfcsv
196: ,RCI_FS_CERT_TYPE_V rfctv
197: ,amw_gl_periods_v agpv
198: ,(select papf.full_name,fu.user_id from PER_ALL_PEOPLE_F papf,fnd_user fu where fu.employee_id = papf.person_id
199: and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date
200: and papf.employee_number is not null) papf
201: ,amw_employees_current_v aecv

Line 619: amw_certification_b acb, amw_gl_periods_v agpv, amw_fin_cert_scope fin_scope

615: to_number(to_char(agpv.period_year)||to_char(agpv.quarter_num)) ent_qtr_id,
616: agpv.period_year ent_year_id,
617: to_number(to_char(agpv.end_date,'J')) report_date_julian
618: FROM
619: amw_certification_b acb, amw_gl_periods_v agpv, amw_fin_cert_scope fin_scope
620: WHERE
621: acb.object_type = 'FIN_STMT'
622: -- AND acb.certification_status in ('ACTIVE','DRAFT')
623: AND acb.certification_id = fin_scope.fin_certification_id

Line 669: amw_certification_b acb, amw_gl_periods_v agpv, amw_opinions_log_v aolv

665: agpv.period_year ent_year_id,
666: to_number(to_char(agpv.end_date,'J')) report_date_julian,
667: G_USER_ID, sysdate, G_USER_ID, sysdate, G_LOGIN_ID
668: FROM
669: amw_certification_b acb, amw_gl_periods_v agpv, amw_opinions_log_v aolv
670: WHERE
671: acb.object_type = 'PROCESS'
672: AND aolv.opinion_type_code = 'CERTIFICATION'
673: AND aolv.object_name = 'AMW_ORG_PROCESS'