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_SIG_ACCT_EVAL_SUMM_PKG dependencies on AMW_OPINIONS_V

Line 222: ,amw_opinions_v o

218: FROM
219: rci_sig_acct_eval_f accteval
220: ,fii_time_day ftd
221: ,amw_fin_cert_eval_sum afces
222: ,amw_opinions_v o
223: ,amw_certification_vl acv
224: ,amw_employees_current_v aecv
225: ,amw_fin_stmnt_vl afsv
226: /* ,(select id,value from rci_fs_acct_eval_v where obj_name=''AMW_KEY_ACCOUNT'') evallook

Line 388: ,(select audit_result eval_result,authored_date eval_date,pk1_value org_id,pk2_value project_id,author eval_by from amw_opinions_v aov1

384: amw_audit_units_v aauv
385: ,rci_org_cert_summ_f rocsf
386: ,amw_certification_vl acv
387: ,rci_bp_cert_result_v certres
388: ,(select audit_result eval_result,authored_date eval_date,pk1_value org_id,pk2_value project_id,author eval_by from amw_opinions_v aov1
389: where aov1.opinion_type_code(+) = ''EVALUATION'' and aov1.object_name(+) = ''AMW_ORGANIZATION''
390: and aov1.authored_date = (select max(aov2.authored_date) from amw_opinions_v aov2
391: where aov2.opinion_type_code(+) = ''EVALUATION'' and aov2.object_name(+) = ''AMW_ORGANIZATION''
392: and aov1.pk1_value=aov2.pk1_value))

Line 390: and aov1.authored_date = (select max(aov2.authored_date) from amw_opinions_v aov2

386: ,amw_certification_vl acv
387: ,rci_bp_cert_result_v certres
388: ,(select audit_result eval_result,authored_date eval_date,pk1_value org_id,pk2_value project_id,author eval_by from amw_opinions_v aov1
389: where aov1.opinion_type_code(+) = ''EVALUATION'' and aov1.object_name(+) = ''AMW_ORGANIZATION''
390: and aov1.authored_date = (select max(aov2.authored_date) from amw_opinions_v aov2
391: where aov2.opinion_type_code(+) = ''EVALUATION'' and aov2.object_name(+) = ''AMW_ORGANIZATION''
392: and aov1.pk1_value=aov2.pk1_value))
393: evalopinion
394: ,(select period_name, period_set_name,

Line 431: from amw_opinions_v aov1

427: ,rci_org_cert_summ_f rocsf
428: ,amw_certification_vl acv
429: ,rci_bp_cert_result_v certres
430: ,(select audit_result eval_result,authored_date eval_date,pk1_value org_id,pk2_value project_id,author eval_by
431: from amw_opinions_v aov1
432: where aov1.opinion_type_code(+) = ''EVALUATION''
433: and aov1.object_name(+) = ''AMW_ORGANIZATION''
434: and aov1.authored_date = (select max(aov2.authored_date)
435: from amw_opinions_v aov2

Line 435: from amw_opinions_v aov2

431: from amw_opinions_v aov1
432: where aov1.opinion_type_code(+) = ''EVALUATION''
433: and aov1.object_name(+) = ''AMW_ORGANIZATION''
434: and aov1.authored_date = (select max(aov2.authored_date)
435: from amw_opinions_v aov2
436: where aov2.opinion_type_code(+) = ''EVALUATION''
437: and aov2.object_name(+) = ''AMW_ORGANIZATION''
438: and aov1.pk1_value=aov2.pk1_value)) evalopinion
439: ,fii_time_day ftd

Line 486: FROM amw_control_associations aca,amw_opinions_v aov

482: BEGIN
483: SELECT
484: count(1) into v_cnt
485: FROM (SELECT DISTINCT aca.pk1 cert_id, aca.pk2 org_id, aca.control_id
486: FROM amw_control_associations aca,amw_opinions_v aov
487: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
488: AND aca.pk1 = p_cert_id
489: AND aca.pk2 = p_org_id
490: AND aov.object_name = 'AMW_ORG_CONTROL'

Line 511: FROM amw_control_associations aca,amw_opinions_v aov

507: v_cnt number;
508: BEGIN
509: SELECT count(1) into v_cnt
510: FROM (SELECT DISTINCT aca.pk1 cert_id, aca.pk2 org_id, aca.control_id
511: FROM amw_control_associations aca,amw_opinions_v aov
512: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
513: AND aca.pk1 = p_cert_id
514: AND aca.pk2 = p_org_id
515: AND aov.object_name = 'AMW_ORG_CONTROL'

Line 541: FROM amw_opinions_v opinion

537: WHERE
538: amw_exec.entity_type = 'BUSIPROC_CERTIFICATION'
539: AND amw_exec.entity_id = p_cert_id
540: AND EXISTS (SELECT opinion.opinion_id
541: FROM amw_opinions_v opinion
542: WHERE opinion.pk1_value = amw_exec.process_id
543: AND opinion.pk3_value = p_org_id
544: AND opinion.opinion_type_code = 'EVALUATION'
545: AND opinion.object_name = 'AMW_ORG_PROCESS'

Line 626: from amw_opinions_v aov1

622: ,rci_org_cert_summ_f rocsf
623: ,amw_certification_vl acv
624: ,rci_bp_cert_result_v certres
625: ,(select audit_result eval_result,authored_date eval_date,pk1_value org_id,pk2_value project_id,author eval_by
626: from amw_opinions_v aov1
627: where aov1.opinion_type_code(+) = ''EVALUATION''
628: and aov1.object_name(+) = ''AMW_ORGANIZATION''
629: and aov1.authored_date = (select max(aov2.authored_date)
630: from amw_opinions_v aov2

Line 630: from amw_opinions_v aov2

626: from amw_opinions_v aov1
627: where aov1.opinion_type_code(+) = ''EVALUATION''
628: and aov1.object_name(+) = ''AMW_ORGANIZATION''
629: and aov1.authored_date = (select max(aov2.authored_date)
630: from amw_opinions_v aov2
631: where aov2.opinion_type_code(+) = ''EVALUATION''
632: and aov2.object_name(+) = ''AMW_ORGANIZATION''
633: and aov1.pk1_value=aov2.pk1_value)) evalopinion
634: ,fii_time_day ftd

Line 725: from amw_opinions_v aov1

721: ,fii_time_day ftd
722: ,amw_fin_cert_eval_sum afces
723: ,amw_fin_key_accounts_vl afka
724: ,(select distinct authored_date,pk1_value,pk2_value,author
725: from amw_opinions_v aov1
726: where aov1.opinion_type_code(+) = ''EVALUATION''
727: and aov1.object_name(+) = ''AMW_KEY_ACCOUNT''
728: and aov1.authored_date = (select max(aov2.authored_date)
729: from amw_opinions_v aov2

Line 729: from amw_opinions_v aov2

725: from amw_opinions_v aov1
726: where aov1.opinion_type_code(+) = ''EVALUATION''
727: and aov1.object_name(+) = ''AMW_KEY_ACCOUNT''
728: and aov1.authored_date = (select max(aov2.authored_date)
729: from amw_opinions_v aov2
730: where aov2.opinion_type_code(+) = ''EVALUATION''
731: and aov2.object_name(+) = ''AMW_KEY_ACCOUNT''
732: and aov1.pk1_value=aov2.pk1_value
733: and aov1.pk2_value=aov2.pk2_value)) o

Line 1169: FROM amw_opinions_v

1165: /*todo 01/06/2005 remove this
1166: CURSOR c_get_acct_evaluations
1167: IS
1168: SELECT pk1_value, pk2_value, audit_result_code
1169: FROM amw_opinions_v
1170: WHERE opinion_type_code = 'EVALUATION'
1171: AND object_name = 'AMW_KEY_ACCOUNT';
1172:
1173: CURSOR c_get_process_certifications

Line 1176: FROM amw_opinions_v

1172:
1173: CURSOR c_get_process_certifications
1174: IS
1175: SELECT pk1_value, pk2_value, pk3_value, audit_result_code
1176: FROM amw_opinions_v
1177: WHERE opinion_type_code = 'CERTIFICATION'
1178: AND object_name = 'AMW_ORG_PROCESS';
1179:
1180: CURSOR c_stmt_grp is

Line 1281: ,amw_opinions_v o

1277: FROM
1278: amw_fin_cert_scope a
1279: ,amw_fin_cert_eval_sum afces
1280: ,amw_certification_b acb
1281: ,amw_opinions_v o
1282: ,amw_gl_periods_v agpv
1283: WHERE
1284: a.fin_certification_id = acb.certification_id
1285: and acb.object_type = 'FIN_STMT'