APPS.RCI_ORG_CERT_ETL_PKG dependencies on AMW_OPINIONS_LOG_V

Line 345: amw_opinions_log_v certopinion,

341: ,G_LOGIN_ID
342: FROM amw_entity_hierarchies hier,
343: amw_fin_org_eval_sum orgeval,
344: amw_audit_units_v auv,
345: amw_opinions_log_v certopinion,
346: amw_opinions_log_v evalopinion,
347: amw_certification_vl acv,
348: amw_gl_periods_v agpv,
349: amw_fin_cert_scope afcs

Line 346: amw_opinions_log_v evalopinion,

342: FROM amw_entity_hierarchies hier,
343: amw_fin_org_eval_sum orgeval,
344: amw_audit_units_v auv,
345: amw_opinions_log_v certopinion,
346: amw_opinions_log_v evalopinion,
347: amw_certification_vl acv,
348: amw_gl_periods_v agpv,
349: amw_fin_cert_scope afcs
350: WHERE hier.entity_type = 'FINSTMT_CERTIFICATION'

Line 891: amw_opinions_log_v certopinion,

887: ,G_LOGIN_ID
888: FROM amw_entity_hierarchies hier,
889: amw_fin_org_eval_sum orgeval,
890: amw_audit_units_v auv,
891: amw_opinions_log_v certopinion,
892: amw_opinions_log_v evalopinion,
893: amw_certification_vl acv,
894: amw_gl_periods_v agpv,
895: amw_fin_cert_scope afcs

Line 892: amw_opinions_log_v evalopinion,

888: FROM amw_entity_hierarchies hier,
889: amw_fin_org_eval_sum orgeval,
890: amw_audit_units_v auv,
891: amw_opinions_log_v certopinion,
892: amw_opinions_log_v evalopinion,
893: amw_certification_vl acv,
894: amw_gl_periods_v agpv,
895: amw_fin_cert_scope afcs
896: WHERE hier.entity_type = 'FINSTMT_CERTIFICATION'

Line 1132: ,amw_opinions_log_v proccert_aolv

1128: ,hr_all_organization_units haou
1129: ,hr_all_organization_units_tl haout
1130: ,hr_organization_information hoi
1131: ,amw_opinions_v orgcert_aov
1132: ,amw_opinions_log_v proccert_aolv
1133: ,amw_certification_vl acv2
1134: ,AMW_FIN_PROC_CERT_RELAN afpcr
1135: ,(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
1136: ,AMW_FIN_KEY_ACCOUNTS_VL AFKAV