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 FND_OBJECTS

Line 929: and object_id = (select object_id from fnd_objects where obj_name = 'AMW_ORG_PROCESS') )

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
933: and object_opinion_type_id =

Line 936: and object_id = (select object_id from fnd_objects where obj_name = 'AMW_ORG_PROCESS') ) );

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:
940: exception

Line 961: and object_id = (select object_id from fnd_objects where obj_name = 'AMW_ORG_PROCESS') );

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:
965: exception

Line 2021: and object_id = (select object_id from fnd_objects where obj_name =

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

Line 2030: and object_id = (select object_id from fnd_objects where obj_name =

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;
2034: