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_OPINIONS_V

Line 924: from amw_opinions_v

920: begin
921:
922: select audit_result
923: into l_last_audit_status
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)

Line 931: (select max(last_update_date) from amw_opinions_v

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
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)

Line 956: select max(last_update_date) into l_last_update_date from amw_opinions_v

952: l_last_update_date date;
953:
954: begin
955:
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)

Line 2015: from amw_opinions_v

2011: begin
2012:
2013: select audit_result
2014: into l_last_audit_status
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

Line 2024: (select max(last_update_date) from amw_opinions_v

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 =
2024: (select max(last_update_date) from amw_opinions_v
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