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.HZ_DQM_DUP_ID_PKG dependencies on HZ_UTILITY_V2PUB

Line 1208: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY

1204: ,p_dup_batch_name => p_batch_name
1205: ,p_match_rule_id => p_match_rule_id
1206: ,p_application_id => '222'
1207: ,p_request_type => 'IMPORT'
1208: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
1209: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
1210: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
1211: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
1212: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

Line 1209: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE

1205: ,p_match_rule_id => p_match_rule_id
1206: ,p_application_id => '222'
1207: ,p_request_type => 'IMPORT'
1208: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
1209: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
1210: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
1211: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
1212: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1213: );

Line 1210: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN

1206: ,p_application_id => '222'
1207: ,p_request_type => 'IMPORT'
1208: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
1209: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
1210: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
1211: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
1212: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1213: );
1214:

Line 1211: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE

1207: ,p_request_type => 'IMPORT'
1208: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
1209: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
1210: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
1211: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
1212: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1213: );
1214:
1215: -- THIS IS ADDED FOR AUTOMERGE

Line 1212: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY

1208: ,p_created_by => HZ_UTILITY_V2PUB.CREATED_BY
1209: ,p_creation_date => HZ_UTILITY_V2PUB.CREATION_DATE
1210: ,p_last_update_login => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN
1211: ,p_last_update_date => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE
1212: ,p_last_updated_by => HZ_UTILITY_V2PUB.LAST_UPDATED_BY
1213: );
1214:
1215: -- THIS IS ADDED FOR AUTOMERGE
1216: -- WE WANT TO IDENTIFY BATCHES THAT ARE AUTO MERGE ENABLED

Line 1835: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date

1831: ,last_update_date,last_updated_by)
1832:
1833: select p_batch_id, win_party_osr,win_party_os, win_party_osr, win_party_os,
1834: 'PARTY', 0, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1835: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1836: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1837: ,hz_utility_v2pub.last_updated_by
1838: from
1839: (

Line 1836: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date

1832:
1833: select p_batch_id, win_party_osr,win_party_os, win_party_osr, win_party_os,
1834: 'PARTY', 0, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1835: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1836: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1837: ,hz_utility_v2pub.last_updated_by
1838: from
1839: (
1840: select distinct d.ord_f_osr as win_party_osr, d.f_os as win_party_os, level as levelu

Line 1837: ,hz_utility_v2pub.last_updated_by

1833: select p_batch_id, win_party_osr,win_party_os, win_party_osr, win_party_os,
1834: 'PARTY', 0, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1835: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1836: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1837: ,hz_utility_v2pub.last_updated_by
1838: from
1839: (
1840: select distinct d.ord_f_osr as win_party_osr, d.f_os as win_party_os, level as levelu
1841: from hz_int_dup_results d

Line 1867: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date

1863: ,created_by,creation_date,last_update_login
1864: ,last_update_date,last_updated_by)
1865: select p_batch_id, win_party_osr,win_party_os, win_party_osr, win_party_os,
1866: 'PARTY', 0, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1867: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1868: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1869: ,hz_utility_v2pub.last_updated_by
1870: from
1871: (

Line 1868: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date

1864: ,last_update_date,last_updated_by)
1865: select p_batch_id, win_party_osr,win_party_os, win_party_osr, win_party_os,
1866: 'PARTY', 0, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1867: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1868: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1869: ,hz_utility_v2pub.last_updated_by
1870: from
1871: (
1872: select distinct d.ord_f_osr as win_party_osr, d.f_os as win_party_os, level as levelu

Line 1869: ,hz_utility_v2pub.last_updated_by

1865: select p_batch_id, win_party_osr,win_party_os, win_party_osr, win_party_os,
1866: 'PARTY', 0, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1867: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1868: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1869: ,hz_utility_v2pub.last_updated_by
1870: from
1871: (
1872: select distinct d.ord_f_osr as win_party_osr, d.f_os as win_party_os, level as levelu
1873: from hz_int_dup_results_gt d

Line 1902: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date

1898: ,created_by,creation_date,last_update_login
1899: ,last_update_date,last_updated_by)
1900: select p_batch_id, a.winner_record_osr,a.winner_record_os, b.ord_t_osr, b.t_os,
1901: 'PARTY', b.score, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1902: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1903: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1904: ,hz_utility_v2pub.last_updated_by
1905: from hz_imp_int_dedup_results a, hz_int_dup_results_gt b
1906: where a.batch_id = p_batch_id and b.batch_id = p_batch_id and a.entity = 'PARTY'

Line 1903: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date

1899: ,last_update_date,last_updated_by)
1900: select p_batch_id, a.winner_record_osr,a.winner_record_os, b.ord_t_osr, b.t_os,
1901: 'PARTY', b.score, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1902: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1903: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1904: ,hz_utility_v2pub.last_updated_by
1905: from hz_imp_int_dedup_results a, hz_int_dup_results_gt b
1906: where a.batch_id = p_batch_id and b.batch_id = p_batch_id and a.entity = 'PARTY'
1907: and b.ord_f_osr = a.winner_record_osr ;

Line 1904: ,hz_utility_v2pub.last_updated_by

1900: select p_batch_id, a.winner_record_osr,a.winner_record_os, b.ord_t_osr, b.t_os,
1901: 'PARTY', b.score, hz_utility_pub.creation_date, hz_utility_pub.last_update_date
1902: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date
1903: ,hz_utility_v2pub.last_update_login,hz_utility_v2pub.last_update_date
1904: ,hz_utility_v2pub.last_updated_by
1905: from hz_imp_int_dedup_results a, hz_int_dup_results_gt b
1906: where a.batch_id = p_batch_id and b.batch_id = p_batch_id and a.entity = 'PARTY'
1907: and b.ord_f_osr = a.winner_record_osr ;
1908: