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.POS_MERGE_SUPPLIER_PKG dependencies on HZ_MERGE_PARTIES

Line 918: FROM hz_merge_parties

914: WHERE attr_group_id = p_attribute_group_id
915: AND data_level_id = p_data_level_id
916: AND party_id IN ( -- Only from parties
917: SELECT from_party_id
918: FROM hz_merge_parties
919: WHERE batch_id = p_batch_id
920: --AND merge_status = 'DONE'
921: AND merge_type <> 'SAME_PARTY_MERGE'
922: AND to_party_id = p_to_party_id)

Line 933: FROM hz_merge_parties

929: WHERE attr_group_id = p_attribute_group_id
930: AND data_level_id = p_data_level_id
931: AND party_id IN
932: (SELECT from_party_id
933: FROM hz_merge_parties
934: WHERE batch_id = p_batch_id
935: AND merge_type <> 'SAME_PARTY_MERGE'
936: AND to_party_id = p_to_party_id)
937: ORDER BY last_update_date)

Line 1000: hz_merge_parties batch

996: merge_from_entity_id
997: FROM hz_merge_party_details site,
998: hz_party_sites fromparty,
999: hz_party_sites toparty,
1000: hz_merge_parties batch
1001: WHERE fromparty.party_site_id = merge_from_entity_id
1002: AND toparty.party_site_id = merge_to_entity_id
1003: AND batch.batch_id = p_batch_id
1004: AND batch.batch_party_id = site.batch_party_id

Line 1024: hz_merge_parties batch

1020: merge_from_entity_id
1021: FROM hz_merge_party_details site,
1022: hz_party_sites fromparty,
1023: hz_party_sites toparty,
1024: hz_merge_parties batch
1025: WHERE fromparty.party_site_id = merge_from_entity_id
1026: AND toparty.party_site_id = merge_to_entity_id
1027: AND batch.batch_id = p_batch_id
1028: AND batch.batch_party_id = site.batch_party_id