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.AMW_AUDIT_ENGAGEMENT_PVT dependencies on AMW_CONTROL_ASSOCIATIONS

Line 1192: AND (apa.pk3=-1 or apa.pk3 in (select 1 from amw_control_associations WHERE object_type='PROJECT'

1188: AND apa2.pk2 = apa.pk2
1189: AND apa2.pk3 = apa.pk3
1190: AND apa2.pk4 = apa.pk4
1191: AND apa2.AUDIT_PROCEDURE_ID=apa.AUDIT_PROCEDURE_ID)
1192: AND (apa.pk3=-1 or apa.pk3 in (select 1 from amw_control_associations WHERE object_type='PROJECT'
1193: AND pk1 = p_source_project_id and control_id=apa.pk3));
1194:
1195:
1196: OPEN my_rec FOR SELECT audit_procedure_id from amw_ap_associations where

Line 1285: AND (apa.pk3=-1 or apa.pk3 in (select 1 from amw_control_associations WHERE object_type='PROJECT'

1281: AND apa2.pk2 = apa.pk2
1282: AND apa2.pk3 = apa.pk3
1283: AND apa2.pk4 = apa.pk4
1284: AND apa2.AUDIT_PROCEDURE_ID=apa.AUDIT_PROCEDURE_ID)
1285: AND (apa.pk3=-1 or apa.pk3 in (select 1 from amw_control_associations WHERE object_type='PROJECT'
1286: AND pk1 = p_source_project_id and control_id=apa.pk3));
1287: FOR ap_task in c_tasks LOOP
1288: update amw_ap_associations set pk4=ap_task.dest_task_id
1289: where pk1=p_dest_project_id and pk4=ap_task.src_task_id;

Line 1782: select 1 from amw_control_associations where pk1=p_source_entity_id and object_type='PROJECT'

1778: WHERE ENTITY_TYPE = 'PROJECT'
1779: AND ENTITY_ID = p_source_entity_id
1780: AND aes.PROCESS_ID is not null
1781: and exists(
1782: select 1 from amw_control_associations where pk1=p_source_entity_id and object_type='PROJECT'
1783: and control_id not in (select pk1_value from amw_opinions_v where pk2_value =p_source_entity_id
1784: and audit_result_code ='EFFECTIVE' and
1785: object_name='AMW_ORG_CONTROL') and pk3=aes.PROCESS_ID);
1786:

Line 1832: exists (select 1 from amw_control_associations where pk1=p_source_entity_id and object_type='PROJECT'

1828: WHERE ENTITY_TYPE = 'PROJECT'
1829: AND ENTITY_ID = p_source_entity_id
1830: AND aes.PARENT_PROCESS_ID =-1
1831: AND exists(select 1 from AMW_EXECUTION_SCOPE aes2 where
1832: exists (select 1 from amw_control_associations where pk1=p_source_entity_id and object_type='PROJECT'
1833: and control_id not in (select pk1_value from amw_opinions_v where pk2_value =p_source_entity_id
1834: and audit_result_code ='EFFECTIVE' and
1835: object_name='AMW_ORG_CONTROL') and pk3=aes2.PROCESS_ID) and aes.process_id=aes2.parent_process_id );
1836:

Line 1882: select 1 from amw_control_associations where pk1=p_source_entity_id and object_type='PROJECT'

1878: WHERE ENTITY_TYPE = 'PROJECT'
1879: AND ENTITY_ID = p_source_entity_id
1880: AND aes.PROCESS_ID is null
1881: and exists(
1882: select 1 from amw_control_associations where pk1=p_source_entity_id and object_type='PROJECT'
1883: and control_id not in (select pk1_value from amw_opinions_v where pk2_value =p_source_entity_id
1884: and audit_result_code ='EFFECTIVE' and
1885: object_name='AMW_ORG_CONTROL') and pk3 is null);
1886: