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.JTF_TERR_MERGE_PUB dependencies on HZ_UTILITY_PUB

Line 65: , jtv.last_update_date = HZ_UTILITY_PUB.last_update_date

61: IF (p_from_FK_id <> p_to_FK_id) THEN
62:
63: UPDATE jtf_terr_values_all jtv
64: SET jtv.low_value_char_id = p_to_fk_id
65: , jtv.last_update_date = HZ_UTILITY_PUB.last_update_date
66: , jtv.last_updated_by = HZ_UTILITY_PUB.last_updated_by
67: , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login
68: WHERE jtv.low_value_char_id = p_from_FK_id
69: AND EXISTS (

Line 66: , jtv.last_updated_by = HZ_UTILITY_PUB.last_updated_by

62:
63: UPDATE jtf_terr_values_all jtv
64: SET jtv.low_value_char_id = p_to_fk_id
65: , jtv.last_update_date = HZ_UTILITY_PUB.last_update_date
66: , jtv.last_updated_by = HZ_UTILITY_PUB.last_updated_by
67: , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login
68: WHERE jtv.low_value_char_id = p_from_FK_id
69: AND EXISTS (
70: SELECT jtq.terr_qual_id

Line 67: , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login

63: UPDATE jtf_terr_values_all jtv
64: SET jtv.low_value_char_id = p_to_fk_id
65: , jtv.last_update_date = HZ_UTILITY_PUB.last_update_date
66: , jtv.last_updated_by = HZ_UTILITY_PUB.last_updated_by
67: , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login
68: WHERE jtv.low_value_char_id = p_from_FK_id
69: AND EXISTS (
70: SELECT jtq.terr_qual_id
71: FROM jtf_terr_qual_all jtq

Line 149: , jtv.last_update_date = HZ_UTILITY_PUB.last_update_date

145: IF (p_from_FK_id <> p_to_FK_id) THEN
146:
147: UPDATE jtf_terr_values_all jtv
148: SET jtv.low_value_char_id = p_to_fk_id
149: , jtv.last_update_date = HZ_UTILITY_PUB.last_update_date
150: , jtv.last_updated_by = HZ_UTILITY_PUB.last_updated_by
151: , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login
152: WHERE jtv.low_value_char_id = p_from_FK_id
153: AND EXISTS (

Line 150: , jtv.last_updated_by = HZ_UTILITY_PUB.last_updated_by

146:
147: UPDATE jtf_terr_values_all jtv
148: SET jtv.low_value_char_id = p_to_fk_id
149: , jtv.last_update_date = HZ_UTILITY_PUB.last_update_date
150: , jtv.last_updated_by = HZ_UTILITY_PUB.last_updated_by
151: , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login
152: WHERE jtv.low_value_char_id = p_from_FK_id
153: AND EXISTS (
154: SELECT jtq.terr_qual_id

Line 151: , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login

147: UPDATE jtf_terr_values_all jtv
148: SET jtv.low_value_char_id = p_to_fk_id
149: , jtv.last_update_date = HZ_UTILITY_PUB.last_update_date
150: , jtv.last_updated_by = HZ_UTILITY_PUB.last_updated_by
151: , jtv.last_update_login = HZ_UTILITY_PUB.last_update_login
152: WHERE jtv.low_value_char_id = p_from_FK_id
153: AND EXISTS (
154: SELECT jtq.terr_qual_id
155: FROM jtf_terr_qual_all jtq