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_UTILITY_PVT dependencies on AMW_OPINION_TYPES_B

Line 928: where opinion_type_id = (select opinion_type_id from amw_opinion_types_b where opinion_type_code = p_mode)

924: from amw_opinions_v
925: where pk1_value = p_process_id and pk3_value = p_org_id
926: and object_opinion_type_id =
927: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES
928: where opinion_type_id = (select opinion_type_id from amw_opinion_types_b where opinion_type_code = p_mode)
929: and object_id = (select object_id from fnd_objects where obj_name = 'AMW_ORG_PROCESS') )
930: and last_update_date =
931: (select max(last_update_date) from amw_opinions_v
932: where pk1_value = p_process_id and pk3_value = p_org_id

Line 935: where opinion_type_id = (select opinion_type_id from amw_opinion_types_b where opinion_type_code = p_mode)

931: (select max(last_update_date) from amw_opinions_v
932: where pk1_value = p_process_id and pk3_value = p_org_id
933: and object_opinion_type_id =
934: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES
935: where opinion_type_id = (select opinion_type_id from amw_opinion_types_b where opinion_type_code = p_mode)
936: and object_id = (select object_id from fnd_objects where obj_name = 'AMW_ORG_PROCESS') ) );
937:
938: return l_last_audit_status;
939:

Line 960: where opinion_type_id = (select opinion_type_id from amw_opinion_types_b where opinion_type_code = p_mode)

956: select max(last_update_date) into l_last_update_date from amw_opinions_v
957: where pk1_value = p_process_id and pk3_value = p_org_id
958: and object_opinion_type_id =
959: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES
960: where opinion_type_id = (select opinion_type_id from amw_opinion_types_b where opinion_type_code = p_mode)
961: and object_id = (select object_id from fnd_objects where obj_name = 'AMW_ORG_PROCESS') );
962:
963: return l_last_update_date;
964:

Line 2019: where opinion_type_id = (select opinion_type_id from amw_opinion_types_b

2015: from amw_opinions_v
2016: where pk1_value = p_org_id
2017: and object_opinion_type_id =
2018: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES
2019: where opinion_type_id = (select opinion_type_id from amw_opinion_types_b
2020: where opinion_type_code = p_mode)
2021: and object_id = (select object_id from fnd_objects where obj_name =
2022: 'AMW_ORGANIZATION') )
2023: and last_update_date =

Line 2029: amw_opinion_types_b where opinion_type_code = p_mode)

2025: where pk1_value = p_org_id
2026: and object_opinion_type_id =
2027: (select object_opinion_type_id from AMW_OBJECT_OPINION_TYPES
2028: where opinion_type_id = (select opinion_type_id from
2029: amw_opinion_types_b where opinion_type_code = p_mode)
2030: and object_id = (select object_id from fnd_objects where obj_name =
2031: 'AMW_ORGANIZATION') ) );
2032:
2033: return l_last_audit_status;