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.ARP_CMERGE_ARCUS dependencies on HZ_CUST_SITE_USES_ALL

Line 285: FROM hz_cust_site_uses_all cust, ra_customer_merges merge --SSUptake

281: CURSOR c1 IS
282: SELECT merge.duplicate_site_id,merge.customer_site_id,
283: cust.bill_to_site_use_id,merge.duplicate_site_code,
284: merge.customer_createsame,cust.org_id --SSUptake
285: FROM hz_cust_site_uses_all cust, ra_customer_merges merge --SSUptake
286: WHERE merge.request_id = req_id
287: AND merge.set_number = set_num
288: AND merge.process_flag = 'N'
289: AND cust.site_use_id = merge.duplicate_site_id

Line 323: update hz_cust_site_uses_all --SSUptake

319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN
321: l_ra_bill_to_site_use_id := l_bill_to_site_use_id;
322: END;
323: update hz_cust_site_uses_all --SSUptake
324: set bill_to_site_use_id = l_ra_bill_to_site_use_id
325: where site_use_id = l_cust_site_id
326: and org_id = l_org_id; --SSUptake
327: END IF;

Line 329: update hz_cust_site_uses_all --SSUptake

325: where site_use_id = l_cust_site_id
326: and org_id = l_org_id; --SSUptake
327: END IF;
328: ELSIF l_site_use_code = 'BILL_TO' THEN
329: update hz_cust_site_uses_all --SSUptake
330: set bill_to_site_use_id = l_cust_site_id
331: where org_id = l_org_id --SSUptake
332: and site_use_id in (
333: SELECT site_use_id

Line 334: FROM hz_cust_site_uses_all su, --SSUptake

330: set bill_to_site_use_id = l_cust_site_id
331: where org_id = l_org_id --SSUptake
332: and site_use_id in (
333: SELECT site_use_id
334: FROM hz_cust_site_uses_all su, --SSUptake
335: hz_cust_acct_sites_all site --SSUptake
336: WHERE su.org_id = l_org_id --SSUptake
337: AND su.org_id = site.org_id --SSUptake
338: AND site.cust_acct_site_id = su.cust_acct_site_id

Line 426: FROM hz_cust_site_uses_all su, ra_customer_merges m --SSUptake

422: x_to_site_id NUMBER;
423:
424: CURSOR c1 IS
425: SELECT site_use_id
426: FROM hz_cust_site_uses_all su, ra_customer_merges m --SSUptake
427: WHERE m.request_id = req_id
428: AND m.process_flag = 'N'
429: AND m.set_number = set_num
430: AND m.org_id = su.org_id --SSUptake

Line 465: UPDATE HZ_CUST_SITE_USES_ALL yt --SSUptake

461: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_SITE_USES', FALSE );
462:
463: --inactivate customer account site uses.
464:
465: UPDATE HZ_CUST_SITE_USES_ALL yt --SSUptake
466: SET status = 'I',
467: last_update_date = sysdate,
468: last_updated_by =hz_utility_v2pub.user_id,-- arp_standard.profile.user_id,
469: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,

Line 494: UPDATE hz_cust_site_uses_all asu

490:
491: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
492: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_SITE_USES', FALSE );
493:
494: UPDATE hz_cust_site_uses_all asu
495: SET primary_flag = 'Y',
496: last_update_date = SYSDATE,
497: last_updated_by = arp_standard.PROFILE.user_id,
498: last_update_login = arp_standard.PROFILE.last_update_login,

Line 512: FROM hz_cust_acct_sites_all s, hz_cust_site_uses_all su

508: AND m.org_id = asu.org_id
509: AND m.process_flag = 'N'
510: AND m.duplicate_primary_flag = 'Y'
511: AND not exists (SELECT 'EXISTS'
512: FROM hz_cust_acct_sites_all s, hz_cust_site_uses_all su
513: WHERE s.cust_account_id = m.customer_id
514: AND su.cust_acct_site_id = s.cust_acct_site_id
515: AND s.org_id = m.org_id
516: AND su.org_id = s.org_id

Line 574: UPDATE HZ_CUST_SITE_USES_ALL yt

570:
571: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
572: arp_message.set_token( 'TABLE_NAME', 'HZ_CUST_SITE_USES', FALSE );
573:
574: UPDATE HZ_CUST_SITE_USES_ALL yt
575: SET status = 'D'
576: WHERE EXISTS (
577: SELECT 'Y'
578: FROM ra_customer_merges m

Line 634: p_owner_table_name =>'HZ_CUST_SITE_USES_ALL',

630: p_init_msg_list => FND_API.G_FALSE,
631: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
632: p_old_owner_table_id => x_from_site_id,
633: p_new_owner_table_id => x_to_site_id,
634: p_owner_table_name =>'HZ_CUST_SITE_USES_ALL',
635: p_orig_system => null,
636: p_orig_system_reference => null,
637: p_reason_code => 'MERGED',
638: x_return_status => x_return_status,

Line 737: FROM HZ_CUST_SITE_USES_ALL su --SSUptake

733: AND m.set_number = set_num
734: AND m.delete_duplicate_flag = 'N'
735: AND NOT EXISTS (
736: SELECT 'active site uses exist'
737: FROM HZ_CUST_SITE_USES_ALL su --SSUptake
738: WHERE su.org_id = yt.org_id --SSUptake
739: AND su.cust_acct_site_id = yt.cust_acct_site_id
740: AND su.status = 'A' )
741: FOR UPDATE NOWAIT;

Line 755: FROM HZ_CUST_SITE_USES_ALL su --SSUptake

751: AND m.org_id = yt.org_id --SSUptake
752: AND yt.cust_acct_site_id = m.duplicate_address_id
753: AND NOT EXISTS (
754: SELECT 'site uses exist'
755: FROM HZ_CUST_SITE_USES_ALL su --SSUptake
756: WHERE su.cust_acct_site_id = yt.cust_acct_site_id
757: AND su.org_id = yt.org_id --SSUptake
758: AND su.status <> 'D' )
759: FOR UPDATE NOWAIT;

Line 769: FROM HZ_CUST_SITE_USES_ALL su --SSUptake

765: AND m.request_id = req_id
766: AND m.set_number = set_num
767: AND (m.delete_duplicate_flag = 'N' or m.delete_duplicate_flag = 'Y') --5571559
768: AND NOT EXISTS (SELECT 'site uses exist'
769: FROM HZ_CUST_SITE_USES_ALL su --SSUptake
770: WHERE su.org_id = m.org_id --SSUptake
771: AND su.cust_acct_site_id = m.duplicate_address_id
772: AND su.status = 'A' );
773:

Line 821: FROM HZ_CUST_SITE_USES_ALL su

817: AND m.duplicate_address_id = yt.cust_acct_site_id
818: AND m.org_id = yt.org_id) --SSUptake
819: AND NOT EXISTS (
820: SELECT 'active site uses exist'
821: FROM HZ_CUST_SITE_USES_ALL su
822: WHERE su.cust_acct_site_id = yt.cust_acct_site_id
823: AND su.org_id = yt.org_id
824: AND su.status = 'A' );
825:

Line 856: FROM HZ_CUST_SITE_USES_ALL s --SSUptake

852: AND m.org_id = yt.org_id
853: AND m.delete_duplicate_flag = 'N' )
854: AND NOT EXISTS (
855: SELECT 'no active bill to'
856: FROM HZ_CUST_SITE_USES_ALL s --SSUptake
857: WHERE s.cust_acct_site_id = yt.cust_acct_site_id
858: AND s.org_id = yt.org_id
859: AND s.site_use_code = 'BILL_TO'
860: AND status = 'A' )

Line 893: FROM HZ_CUST_SITE_USES_ALL s --SSUptake

889: AND m.duplicate_address_id = yt.cust_acct_site_id
890: AND m.org_id = yt.org_id )
891: AND NOT EXISTS (
892: SELECT 'no active ship to'
893: FROM HZ_CUST_SITE_USES_ALL s --SSUptake
894: WHERE s.cust_acct_site_id = yt.cust_acct_site_id
895: AND s.org_id = yt.org_id
896: AND s.site_use_code = 'SHIP_TO'
897: AND status = 'A' )

Line 930: FROM HZ_CUST_SITE_USES_ALL s --SSUptake

926: AND m.org_id = yt.org_id
927: AND m.duplicate_address_id = yt.cust_acct_site_id)
928: AND NOT EXISTS (
929: SELECT 'no active market site'
930: FROM HZ_CUST_SITE_USES_ALL s --SSUptake
931: WHERE s.cust_acct_site_id = yt.cust_acct_site_id
932: AND s.org_id = yt.org_id
933: AND s.site_use_code = 'MARKET'
934: AND status = 'A' )

Line 954: FROM hz_cust_site_uses_all su, ra_customer_merges m

950: program_application_id = arp_standard.profile.program_application_id,
951: program_id = arp_standard.profile.program_id,
952: program_update_date = sysdate
953: WHERE EXISTS ( SELECT 1
954: FROM hz_cust_site_uses_all su, ra_customer_merges m
955: WHERE m.request_id = req_id
956: AND m.set_number = set_num
957: AND m.customer_createsame = 'N'
958: AND m.process_flag = 'N'

Line 987: FROM hz_cust_site_uses_all su, ra_customer_merges m

983: program_application_id = arp_standard.profile.program_application_id,
984: program_id = arp_standard.profile.program_id,
985: program_update_date = sysdate
986: WHERE EXISTS ( SELECT 1
987: FROM hz_cust_site_uses_all su, ra_customer_merges m
988: WHERE m.request_id = req_id
989: AND m.set_number = set_num
990: AND m.customer_createsame = 'N'
991: AND m.process_flag = 'N'

Line 1020: FROM hz_cust_site_uses_all su, ra_customer_merges m

1016: program_application_id = arp_standard.profile.program_application_id,
1017: program_id = arp_standard.profile.program_id,
1018: program_update_date = sysdate
1019: WHERE EXISTS ( SELECT 1
1020: FROM hz_cust_site_uses_all su, ra_customer_merges m
1021: WHERE m.request_id = req_id
1022: AND m.set_number = set_num
1023: AND m.customer_createsame = 'N'
1024: AND m.process_flag = 'N'

Line 1064: FROM HZ_CUST_SITE_USES_ALL su --SSUptake

1060: AND m.duplicate_address_id = yt.cust_acct_site_id
1061: AND m.org_id = yt.org_id)
1062: AND NOT EXISTS (
1063: SELECT 'site uses exist'
1064: FROM HZ_CUST_SITE_USES_ALL su --SSUptake
1065: WHERE su.cust_acct_site_id = yt.cust_acct_site_id
1066: AND su.org_id = yt.org_id
1067: AND su.status <> 'D' );
1068:

Line 4635: FROM HZ_CUST_SITE_USES_ALL su, ra_customer_merges m --SSUptake

4631: ) IS
4632:
4633: CURSOR cust_site_uses IS
4634: SELECT site_use_id
4635: FROM HZ_CUST_SITE_USES_ALL su, ra_customer_merges m --SSUptake
4636: WHERE cust_acct_site_id = m.duplicate_address_id
4637: AND m.org_id = su.org_id --SSUptake
4638: AND m.process_flag = 'N'
4639: AND m.request_id = req_id

Line 4771: owner_table_name = 'HZ_CUST_SITE_USES_ALL' and

4767: OPEN cust_site_uses;
4768: CLOSE cust_site_uses;
4769:
4770: delete from hz_orig_sys_references where
4771: owner_table_name = 'HZ_CUST_SITE_USES_ALL' and
4772: owner_table_id in (
4773: select site_use_id from hz_cust_site_uses_all su
4774: where status = 'D'
4775: and exists ( SELECT 'Y'

Line 4773: select site_use_id from hz_cust_site_uses_all su

4769:
4770: delete from hz_orig_sys_references where
4771: owner_table_name = 'HZ_CUST_SITE_USES_ALL' and
4772: owner_table_id in (
4773: select site_use_id from hz_cust_site_uses_all su
4774: where status = 'D'
4775: and exists ( SELECT 'Y'
4776: FROM ra_customer_merges m
4777: WHERE su.cust_acct_site_id = m.duplicate_address_id

Line 4786: DELETE FROM HZ_CUST_SITE_USES_ALL su

4782: AND m.delete_duplicate_flag = 'Y'
4783: )
4784: );
4785:
4786: DELETE FROM HZ_CUST_SITE_USES_ALL su
4787: WHERE EXISTS (
4788: SELECT 'Y'
4789: FROM ra_customer_merges m
4790: WHERE m.duplicate_address_id = su.cust_acct_site_id

Line 5860: FROM HZ_CUST_SITE_USES_ALL csu --SSUptake

5856: WHERE location_id = l_location_id
5857: AND party_id = l_merge_to_party_id )
5858: AND EXISTS ( --'same site usage'
5859: SELECT site_use_id
5860: FROM HZ_CUST_SITE_USES_ALL csu --SSUptake
5861: WHERE cas.cust_acct_site_id = csu.cust_acct_site_id
5862: AND site_use_code = l_duplicate_site_code
5863: AND csu.org_id = cas.org_id ); --SSUptake
5864:

Line 5886: FROM HZ_CUST_SITE_USES_ALL --SSUptake

5882:
5883: --In case of multiple usages exist, select the one
5884: --with mininum id.
5885: SELECT MIN(site_use_id) INTO l_customer_site_id
5886: FROM HZ_CUST_SITE_USES_ALL --SSUptake
5887: WHERE cust_acct_site_id = l_customer_address_id
5888: AND org_id = m_org_id --SSUptake
5889: AND site_use_code = l_duplicate_site_code;
5890:

Line 6470: FROM HZ_CUST_SITE_USES_ALL --SSUptake

6466: cust_site_use_rec.gl_id_remittance,
6467: cust_site_use_rec.gl_id_factor,
6468: cust_site_use_rec.tax_classification,
6469: site_use_org_id
6470: FROM HZ_CUST_SITE_USES_ALL --SSUptake
6471: WHERE site_use_id = l_duplicate_site_id
6472: AND org_id = m_org_id; --SSUptake
6473:
6474: ----Bug 5211233

Line 6478: from hz_cust_site_uses_all

6474: ----Bug 5211233
6475: IF cust_site_use_rec.primary_flag = 'Y' THEN
6476: BEGIN
6477: Select NULL INTO cust_site_use_rec.primary_flag
6478: from hz_cust_site_uses_all
6479: where CUST_ACCT_SITE_ID in (select CUST_ACCT_SITE_ID from hz_cust_acct_sites_all
6480: Where cust_account_id = l_customer_id
6481: AND org_id = site_use_org_id)
6482: AND SITE_USE_CODE = cust_site_use_rec.site_use_code

Line 6500: from HZ_CUST_SITE_USES_ALL

6496: -- Check whether the bill_to_site_use_id is valid.
6497: BEGIN
6498: select 1
6499: into l_count
6500: from HZ_CUST_SITE_USES_ALL
6501: where site_use_id = cust_site_use_rec.bill_to_site_use_id
6502: and site_use_code = 'BILL_TO';
6503: EXCEPTION
6504: WHEN NO_DATA_FOUND THEN

Line 6560: FROM hz_cust_acct_sites_all as1, hz_cust_site_uses_all asu

6556: l_dun_exists:='N';
6557: IF (l_duplicate_site_code = 'DUN' or l_duplicate_site_code = 'STMTS') and cust_site_use_rec.status = 'A' THEN
6558: BEGIN
6559: SELECT 'Y' INTO l_dun_exists
6560: FROM hz_cust_acct_sites_all as1, hz_cust_site_uses_all asu
6561: WHERE as1.cust_account_id = l_customer_id
6562: AND asu.cust_acct_site_id = as1.cust_acct_site_id
6563: AND as1.org_id = m_org_id
6564: AND asu.site_use_code = l_duplicate_site_code

Line 6861: FROM HZ_CUST_SITE_USES_ALL

6857: if l_customer_site_id is not null then
6858: --Select primary flag and location
6859: SELECT primary_flag, location
6860: INTO l_customer_primary_flag, l_customer_location
6861: FROM HZ_CUST_SITE_USES_ALL
6862: WHERE site_use_id = l_customer_site_id;
6863: end if;
6864: --bug 3959776
6865: SELECT party_site_number INTO l_party_site_number

Line 7956: ---------Insert into hz_cust_site_uses_all_m--------------

7952: AND acs.org_id = m.org_id ;
7953:
7954: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_SITES_ALL_M');
7955:
7956: ---------Insert into hz_cust_site_uses_all_m--------------
7957: INSERT INTO hz_cust_site_uses_all_m(
7958: customer_merge_header_id,
7959: site_use_id ,
7960: cust_acct_site_id ,

Line 7957: INSERT INTO hz_cust_site_uses_all_m(

7953:
7954: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_ACCT_SITES_ALL_M');
7955:
7956: ---------Insert into hz_cust_site_uses_all_m--------------
7957: INSERT INTO hz_cust_site_uses_all_m(
7958: customer_merge_header_id,
7959: site_use_id ,
7960: cust_acct_site_id ,
7961: last_update_date ,

Line 8202: and cm.set_number = set_num ) m,hz_cust_site_uses_all su --SSUptake

8198: FROM (select distinct duplicate_site_id,customer_merge_header_id,org_id
8199: from ra_customer_merges cm
8200: where cm.process_flag = 'N'
8201: and cm.request_id = req_id
8202: and cm.set_number = set_num ) m,hz_cust_site_uses_all su --SSUptake
8203: WHERE su.site_use_id = duplicate_site_id
8204: AND su.org_id = m.org_id; --SSUptake
8205:
8206: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');

Line 8206: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');

8202: and cm.set_number = set_num ) m,hz_cust_site_uses_all su --SSUptake
8203: WHERE su.site_use_id = duplicate_site_id
8204: AND su.org_id = m.org_id; --SSUptake
8205:
8206: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) inserted in HZ_CUST_SITE_USES_ALL_M');
8207:
8208: ---------Insert into hz_cust_acct_relate_all_m--------------
8209: INSERT INTO hz_cust_acct_relate_all_m(
8210: customer_merge_header_id,