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.

[Home] [Help]

APPS.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on AMW_OBJECT_OPINION_TYPES

Line 510: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =

506: -- T0 Update the Control Effectiveness Details
507:
508: select opinion_component_id into v_overall from amw_opinion_componts_b
509: where opinion_component_code = 'OVERALL' and object_opinion_type_id =
510: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
511: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
512:
513: select opinion_component_id into v_design from amw_opinion_componts_b
514: where opinion_component_code = 'DESIGN' and object_opinion_type_id =

Line 515: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =

511: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
512:
513: select opinion_component_id into v_design from amw_opinion_componts_b
514: where opinion_component_code = 'DESIGN' and object_opinion_type_id =
515: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
516: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
517:
518: select opinion_component_id into v_operating from amw_opinion_componts_b
519: where opinion_component_code = 'OPERATING' and object_opinion_type_id =

Line 520: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =

516: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
517:
518: select opinion_component_id into v_operating from amw_opinion_componts_b
519: where opinion_component_code = 'OPERATING' and object_opinion_type_id =
520: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
521: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
522:
523: select object_opinion_type_id into v_opinion_object_id from AMW_OBJECT_OPINION_TYPES
524: where opinion_type_id = (select opinion_type_id from AMW_OPINION_TYPES_b

Line 523: select object_opinion_type_id into v_opinion_object_id from AMW_OBJECT_OPINION_TYPES

519: where opinion_component_code = 'OPERATING' and object_opinion_type_id =
520: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES where object_id =
521: (select object_id from fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL'));
522:
523: select object_opinion_type_id into v_opinion_object_id from AMW_OBJECT_OPINION_TYPES
524: where opinion_type_id = (select opinion_type_id from AMW_OPINION_TYPES_b
525: where opinion_type_code = 'EVALUATION') and object_id = (select object_id from
526: fnd_objects where obj_name = 'AMW_ORG_AP_CONTROL');
527: