APPS.RLM_CUST_MERGE dependencies on RLM_CUST_SHIPTO_TERMS

Line 854: FROM RLM_CUST_SHIPTO_TERMS

850: --
851: CURSOR cust_merge_cur IS
852: SELECT address_id,
853: customer_id
854: FROM RLM_CUST_SHIPTO_TERMS
855: WHERE customer_id in
856: (select m.duplicate_id
857: from ra_customer_merges m
858: where m.process_flag = 'N'

Line 872: FROM rlm_cust_shipto_terms yt,ra_customer_merges m

868:
869: /*2447493*/
870: CURSOR merge_records_cur IS
871: SELECT distinct CUSTOMER_MERGE_HEADER_ID
872: FROM rlm_cust_shipto_terms yt,ra_customer_merges m
873: where yt.customer_id = m.duplicate_id
874: AND m.process_flag = 'N'
875: AND m.request_id = req_id
876: AND m.set_number = set_num;

Line 879: SELECT * from rlm_cust_shipto_terms

875: AND m.request_id = req_id
876: AND m.set_number = set_num;
877:
878: CURSOR cust_shipto_terms_cur is
879: SELECT * from rlm_cust_shipto_terms
880: where customer_id in
881: (select m.duplicate_id
882: from ra_customer_merges m
883: where m.process_flag = 'N'

Line 911: setARMessageLockTable('RLM_CUST_SHIPTO_TERMS');

907: arp_message.set_line('RLM_CUST_MERGE.Cust_Shipto_Terms()+' || getTimeStamp);
908: --
909: IF (process_mode = 'LOCK') THEN
910: --
911: setARMessageLockTable('RLM_CUST_SHIPTO_TERMS');
912: --
913: open cust_merge_cur;
914: close cust_merge_cur;
915: --

Line 1074: 'RLM_CUST_SHIPTO_TERMS',

1070: LAST_UPDATE_DATE,
1071: LAST_UPDATED_BY)
1072: Values
1073: ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1074: 'RLM_CUST_SHIPTO_TERMS',
1075: MERGE_HEADER_ID_LIST(I),
1076: cust_shipto_terms.CUST_SHIPTO_TERMS_ID,
1077: cust_shipto_terms.ADDRESS_ID,
1078: cust_shipto_terms.CUSTOMER_ID,

Line 1211: setARMessageDeleteTable('RLM_CUST_SHIPTO_TERMS');

1207: END IF;
1208:
1209: IF p_duplicateIdTab.COUNT <> 0 THEN
1210: --
1211: setARMessageDeleteTable('RLM_CUST_SHIPTO_TERMS');
1212:
1213: --
1214: FORALL i IN p_duplicateIdTab.FIRST..p_duplicateIdTab.LAST
1215:

Line 1216: DELETE RLM_CUST_SHIPTO_TERMS

1212:
1213: --
1214: FORALL i IN p_duplicateIdTab.FIRST..p_duplicateIdTab.LAST
1215:
1216: DELETE RLM_CUST_SHIPTO_TERMS
1217: WHERE (address_id = p_duplicateAddressIdTab(i)
1218: OR customer_id = DECODE(p_duplicateIdTab(i),
1219: p_customerIdTab(i),
1220: -3.1428571,

Line 1277: FROM rlm_cust_shipto_terms yt,ra_customer_merges m

1273:
1274: /*2447493*/
1275: CURSOR merge_records_cur IS
1276: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1277: FROM rlm_cust_shipto_terms yt,ra_customer_merges m
1278: where yt.customer_id = m.duplicate_id
1279: AND m.process_flag = 'N'
1280: AND m.request_id = req_id
1281: AND m.set_number = set_num;