[Home] [Help]
331: AMW_FIN_PROC_CERT_RELAN REL,
332: AMW_FIN_PROCESS_EVAL_SUM finprocsum,
333: HR_ALL_ORGANIZATION_UNITS o,
334: HR_ALL_ORGANIZATION_UNITS_TL otl,
335: AMW_PROCESS_ORGANIZATION_VL proc,
336: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
337: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn,
338: amw_certification_b acb,
339: (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,
528: G_LOGIN_ID
529: FROM amw_proc_cert_eval_sum proccert,
530: amw_opinions_log_v opinions_eval,
531: amw_opinions_v opinions_cert,
532: amw_process_organization_vl process,
533: amw_execution_scope execs,
534: amw_audit_units_v audit_v,
535: amw_certification_vl acv,
536: amw_audit_projects_v aapv,
740: AMW_FIN_PROC_CERT_RELAN REL,
741: AMW_FIN_PROCESS_EVAL_SUM finprocsum,
742: HR_ALL_ORGANIZATION_UNITS o,
743: HR_ALL_ORGANIZATION_UNITS_TL otl,
744: AMW_PROCESS_ORGANIZATION_VL proc,
745: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
746: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn,
747: amw_certification_b acb,
748: (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,
922: G_LOGIN_ID
923: FROM amw_proc_cert_eval_sum proccert,
924: amw_opinions_log_v opinions_eval,
925: amw_opinions_v opinions_cert,
926: amw_process_organization_vl process,
927: amw_execution_scope execs,
928: amw_audit_units_v audit_v,
929: amw_certification_vl acv,
930: amw_audit_projects_v aapv,