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_EXECUTION_SCOPE

Line 419: FROM amw_execution_scope

415: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
416: AND aca.pk1 = r_load_cols.certification_id
417: AND aca.pk2 = r_load_cols.organization_id
418: AND aca.pk3 IN (SELECT DISTINCT process_id
419: FROM amw_execution_scope
420: START WITH process_id = r_load_cols.process_id
421: AND organization_id = r_load_cols.organization_id
422: AND entity_id = r_load_cols.certification_id
423: and entity_type='BUSIPROC_CERTIFICATION'

Line 616: amw_execution_scope execs,

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,
618: amw_audit_projects_v aapv,
619: amw_certification_vl acv,
620: amw_certification_vl acv2,

Line 681: FROM amw_execution_scope

677: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
678: AND aca.pk1 = r_load_cols.certification_id
679: AND aca.pk2 = r_load_cols.organization_id
680: AND aca.pk3 IN (SELECT DISTINCT process_id
681: FROM amw_execution_scope
682: START WITH process_id = r_load_cols.process_id
683: AND organization_id = r_load_cols.organization_id
684: AND entity_id = r_load_cols.certification_id
685: and entity_type='BUSIPROC_CERTIFICATION'

Line 966: FROM amw_execution_scope

962: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
963: AND aca.pk1 = r_load_cols.certification_id
964: AND aca.pk2 = r_load_cols.organization_id
965: AND aca.pk3 IN (SELECT DISTINCT process_id
966: FROM amw_execution_scope
967: START WITH process_id = r_load_cols.process_id
968: AND organization_id = r_load_cols.organization_id
969: AND entity_id = r_load_cols.certification_id
970: and entity_type='BUSIPROC_CERTIFICATION'

Line 1140: amw_execution_scope execs,

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,
1142: amw_audit_projects_v aapv,
1143: amw_certification_vl acv,
1144: amw_certification_vl acv2,

Line 1205: FROM amw_execution_scope

1201: WHERE aca.object_type = 'BUSIPROC_CERTIFICATION'
1202: AND aca.pk1 = r_load_cols.certification_id
1203: AND aca.pk2 = r_load_cols.organization_id
1204: AND aca.pk3 IN (SELECT DISTINCT process_id
1205: FROM amw_execution_scope
1206: START WITH process_id = r_load_cols.process_id
1207: AND organization_id = r_load_cols.organization_id
1208: AND entity_id = r_load_cols.certification_id
1209: and entity_type='BUSIPROC_CERTIFICATION'