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_OPEN_ISSUE_SUMM_PKG dependencies on AMW_CERTIFICATION_B

Line 160: amw_certification_b proc_cert,

156: to_number(to_char(agpv.end_date,'J')) /**as reportDateJulian**/
157: from eng_engineering_changes eec,
158: eng_change_subjects ecs,
159: AMW_FIN_PROC_CERT_RELAN afpcr,
160: amw_certification_b proc_cert,
161: amw_certification_b fin_cert,
162: amw_gl_periods_v agpv,
163: fii_time_day ftd
164: where change_order_type_id in (select change_order_type_id

Line 161: amw_certification_b fin_cert,

157: from eng_engineering_changes eec,
158: eng_change_subjects ecs,
159: AMW_FIN_PROC_CERT_RELAN afpcr,
160: amw_certification_b proc_cert,
161: amw_certification_b fin_cert,
162: amw_gl_periods_v agpv,
163: fii_time_day ftd
164: where change_order_type_id in (select change_order_type_id
165: from eng_change_order_types

Line 285: from AMW_CERTIFICATION_B cert

281: into l_FIN_CERT_ID, l_FIN_CERT_TYPE, l_FIN_CERT_STATUS,
282: l_period_year, l_period_num, l_quarter_num, l_ent_period_id,
283: l_ent_qtr_id, l_ent_year_id, l_report_date_julian,
284: l_ent_period_end, l_ent_qtr_end, l_ent_yr_end
285: from AMW_CERTIFICATION_B cert
286: ,AMW_FIN_PROC_CERT_RELAN rln
287: ,AMW_CERTIFICATION_B cert2
288: ,amw_gl_periods_v agpv
289: ,fii_time_day ftd

Line 287: ,AMW_CERTIFICATION_B cert2

283: l_ent_qtr_id, l_ent_year_id, l_report_date_julian,
284: l_ent_period_end, l_ent_qtr_end, l_ent_yr_end
285: from AMW_CERTIFICATION_B cert
286: ,AMW_FIN_PROC_CERT_RELAN rln
287: ,AMW_CERTIFICATION_B cert2
288: ,amw_gl_periods_v agpv
289: ,fii_time_day ftd
290: where cert.OBJECT_TYPE = 'PROCESS'
291: and rln.PROC_CERT_ID=cert.CERTIFICATION_ID