APPS.RLM_CUST_MERGE dependencies on RLM_CUST_ITEM_TERMS

Line 1259: FROM RLM_CUST_ITEM_TERMS

1255: --
1256: CURSOR cust_merge_cur IS
1257: SELECT address_id,
1258: customer_id
1259: FROM RLM_CUST_ITEM_TERMS
1260: WHERE customer_id in
1261: (select m.duplicate_id
1262: from ra_customer_merges m
1263: where m.process_flag = 'N'

Line 1284: SELECT * from rlm_cust_item_terms

1280: AND m.request_id = req_id
1281: AND m.set_number = set_num;
1282:
1283: CURSOR cust_item_terms_cur is
1284: SELECT * from rlm_cust_item_terms
1285: where customer_id in
1286: (select m.duplicate_id
1287: from ra_customer_merges m
1288: where m.process_flag = 'N'

Line 1318: setARMessageLockTable('RLM_CUST_ITEM_TERMS');

1314: arp_message.set_line('RLM_CUST_MERGE.Cust_Item_Terms()+' || getTimeStamp);
1315: --
1316: IF (process_mode = 'LOCK') THEN
1317: --
1318: setARMessageLockTable('RLM_CUST_ITEM_TERMS');
1319: --
1320: open cust_merge_cur;
1321: --
1322: close cust_merge_cur;

Line 1469: 'RLM_CUST_ITEM_TERMS',

1465: LAST_UPDATE_DATE,
1466: LAST_UPDATED_BY)
1467: Values
1468: ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1469: 'RLM_CUST_ITEM_TERMS',
1470: MERGE_HEADER_ID_LIST(I),
1471: cust_item_terms.CUST_ITEM_TERMS_ID,
1472: cust_item_terms.CUSTOMER_ITEM_ID,
1473: cust_item_terms.SHIP_FROM_ORG_ID,

Line 1592: setARMessageDeleteTable('RLM_CUST_ITEM_TERMS');

1588: END IF;
1589:
1590: IF p_duplicateIdTab.COUNT <> 0 THEN
1591: --
1592: setARMessageDeleteTable('RLM_CUST_ITEM_TERMS');
1593: --
1594: FORALL i IN p_duplicateIdTab.FIRST..p_duplicateIdTab.LAST
1595: --
1596: DELETE RLM_CUST_ITEM_TERMS

Line 1596: DELETE RLM_CUST_ITEM_TERMS

1592: setARMessageDeleteTable('RLM_CUST_ITEM_TERMS');
1593: --
1594: FORALL i IN p_duplicateIdTab.FIRST..p_duplicateIdTab.LAST
1595: --
1596: DELETE RLM_CUST_ITEM_TERMS
1597: WHERE (address_id = p_duplicateAddressIdTab(i)
1598: OR customer_id = DECODE(p_duplicateIdTab(i),
1599: p_customerIdTab(i),
1600: -3.1428571,