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_ORG_DFCY_ETL_PKG dependencies on AMW_OPINIONS_LOG_V

Line 274: ,amw_opinions_log_v aolv1

270: ,G_LOGIN_ID
271: from amw_fin_process_eval_sum afpes
272: ,amw_certification_b acb
273: ,amw_latest_revisions_v alrv
274: ,amw_opinions_log_v aolv1
275: ,amw_opinions_log_v aolv2
276: ,(select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa
277: ,AMW_FIN_KEY_ACCOUNTS_VL AFKAV
278: ,amw_gl_periods_v agpv

Line 275: ,amw_opinions_log_v aolv2

271: from amw_fin_process_eval_sum afpes
272: ,amw_certification_b acb
273: ,amw_latest_revisions_v alrv
274: ,amw_opinions_log_v aolv1
275: ,amw_opinions_log_v aolv2
276: ,(select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa
277: ,AMW_FIN_KEY_ACCOUNTS_VL AFKAV
278: ,amw_gl_periods_v agpv
279: where afpes.fin_certification_id = acb.certification_id

Line 310: AMW_OPINIONS_LOG_V op

306: FROM AMW_CONTROL_ASSOCIATIONS ctrls,
307: AMW_CONTROLS_ALL_VL all_ctrls,
308: HR_ALL_ORGANIZATION_UNITS o,
309: HR_ALL_ORGANIZATION_UNITS_TL otl,
310: AMW_OPINIONS_LOG_V op
311: WHERE ctrls.object_type = 'RISK_FINCERT'
312: and ctrls.control_rev_id = all_ctrls.control_rev_id
313: and all_ctrls.APPROVAL_STATUS = 'A'
314: and o.organization_id = ctrls.pk2

Line 354: ,amw_opinions_log_v aolv

350: ,sysdate
351: ,G_USER_ID
352: ,G_LOGIN_ID
353: from amw_control_associations aca
354: ,amw_opinions_log_v aolv
355: ,amw_latest_revisions_v alrv
356: ,HR_ALL_ORGANIZATION_UNITS haou
357: ,HR_ALL_ORGANIZATION_UNITS_TL haout
358: ,amw_opinions_v aov1

Line 613: amw_opinions_log_v opinions_eval,

609: sysdate,
610: G_USER_ID,
611: G_LOGIN_ID
612: FROM amw_proc_cert_eval_sum proccert,
613: amw_opinions_log_v opinions_eval,
614: amw_opinions_v opinions_cert,
615: amw_process_organization_vl process,
616: amw_execution_scope execs,
617: amw_audit_units_v audit_v,

Line 889: ,amw_opinions_log_v aolv1

885: ,G_LOGIN_ID
886: from amw_fin_process_eval_sum afpes
887: ,amw_certification_b acb
888: ,amw_latest_revisions_v alrv
889: ,amw_opinions_log_v aolv1
890: ,amw_opinions_log_v aolv2
891: ,(select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa
892: ,AMW_FIN_KEY_ACCOUNTS_VL AFKAV
893: ,amw_gl_periods_v agpv

Line 890: ,amw_opinions_log_v aolv2

886: from amw_fin_process_eval_sum afpes
887: ,amw_certification_b acb
888: ,amw_latest_revisions_v alrv
889: ,amw_opinions_log_v aolv1
890: ,amw_opinions_log_v aolv2
891: ,(select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa
892: ,AMW_FIN_KEY_ACCOUNTS_VL AFKAV
893: ,amw_gl_periods_v agpv
894: where afpes.fin_certification_id = acb.certification_id

Line 925: AMW_OPINIONS_LOG_V op

921: FROM AMW_CONTROL_ASSOCIATIONS ctrls,
922: AMW_CONTROLS_ALL_VL all_ctrls,
923: HR_ALL_ORGANIZATION_UNITS o,
924: HR_ALL_ORGANIZATION_UNITS_TL otl,
925: AMW_OPINIONS_LOG_V op
926: WHERE ctrls.object_type = 'RISK_FINCERT'
927: and ctrls.control_rev_id = all_ctrls.control_rev_id
928: and all_ctrls.APPROVAL_STATUS = 'A'
929: and o.organization_id = ctrls.pk2

Line 1137: amw_opinions_log_v opinions_eval,

1133: sysdate,
1134: G_USER_ID,
1135: G_LOGIN_ID
1136: FROM amw_proc_cert_eval_sum proccert,
1137: amw_opinions_log_v opinions_eval,
1138: amw_opinions_v opinions_cert,
1139: amw_process_organization_vl process,
1140: amw_execution_scope execs,
1141: amw_audit_units_v audit_v,