APPS.INV_CMERGE_ITEMS dependencies on MTL_CUSTOMER_ITEMS

Line 22: MTL_CUSTOMER_ITEMS.CUSTOMER_ITEM_ID%TYPE

18: INDEX BY BINARY_INTEGER;
19: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
20:
21: TYPE CUSTOMER_ITEM_ID_LIST_TYPE IS TABLE OF
22: MTL_CUSTOMER_ITEMS.CUSTOMER_ITEM_ID%TYPE
23: INDEX BY BINARY_INTEGER;
24: PRIMARY_KEY_ID_LIST CUSTOMER_ITEM_ID_LIST_TYPE;
25:
26: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF

Line 27: MTL_CUSTOMER_ITEMS.CUSTOMER_ID%TYPE

23: INDEX BY BINARY_INTEGER;
24: PRIMARY_KEY_ID_LIST CUSTOMER_ITEM_ID_LIST_TYPE;
25:
26: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
27: MTL_CUSTOMER_ITEMS.CUSTOMER_ID%TYPE
28: INDEX BY BINARY_INTEGER;
29: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
30: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
31:

Line 33: MTL_CUSTOMER_ITEMS.ADDRESS_ID%TYPE

29: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
30: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
31:
32: TYPE ADDRESS_ID_LIST_TYPE IS TABLE OF
33: MTL_CUSTOMER_ITEMS.ADDRESS_ID%TYPE
34: INDEX BY BINARY_INTEGER;
35: NUM_COL2_ORIG_LIST ADDRESS_ID_LIST_TYPE;
36: NUM_COL2_NEW_LIST ADDRESS_ID_LIST_TYPE;
37:

Line 40: MTL_CUSTOMER_ITEMS.CUSTOMER_ITEM_NUMBER%TYPE

36: NUM_COL2_NEW_LIST ADDRESS_ID_LIST_TYPE;
37:
38: -- Bug 4135064.
39: TYPE CUSTOMER_ITEM_NUMBER_LIST_TYPE IS TABLE OF
40: MTL_CUSTOMER_ITEMS.CUSTOMER_ITEM_NUMBER%TYPE
41: INDEX BY BINARY_INTEGER;
42: CUST_ITEM_NUM_LIST CUSTOMER_ITEM_NUMBER_LIST_TYPE;
43:
44: TYPE CUST_CATEGORY_CODE_LIST_TYPE IS TABLE OF

Line 45: MTL_CUSTOMER_ITEMS.CUSTOMER_CATEGORY_CODE%TYPE

41: INDEX BY BINARY_INTEGER;
42: CUST_ITEM_NUM_LIST CUSTOMER_ITEM_NUMBER_LIST_TYPE;
43:
44: TYPE CUST_CATEGORY_CODE_LIST_TYPE IS TABLE OF
45: MTL_CUSTOMER_ITEMS.CUSTOMER_CATEGORY_CODE%TYPE
46: INDEX BY BINARY_INTEGER;
47: CUST_CATEGORY_CODE_LIST CUST_CATEGORY_CODE_LIST_TYPE;
48:
49: TYPE ITEM_DEF_LEVEL_LIST_TYPE IS TABLE OF

Line 50: MTL_CUSTOMER_ITEMS.ITEM_DEFINITION_LEVEL%TYPE

46: INDEX BY BINARY_INTEGER;
47: CUST_CATEGORY_CODE_LIST CUST_CATEGORY_CODE_LIST_TYPE;
48:
49: TYPE ITEM_DEF_LEVEL_LIST_TYPE IS TABLE OF
50: MTL_CUSTOMER_ITEMS.ITEM_DEFINITION_LEVEL%TYPE
51: INDEX BY BINARY_INTEGER;
52: ITEM_DEF_LEVEL_LIST ITEM_DEF_LEVEL_LIST_TYPE;
53: -- Bug 4135064
54:

Line 67: FROM MTL_CUSTOMER_ITEMS yt, ra_customer_merges m

63: decode(yt.item_definition_level,3,m.CUSTOMER_ADDRESS_ID,yt.ADDRESS_ID),yt.ADDRESS_ID)
64: , customer_item_number
65: , customer_category_code
66: , item_definition_level
67: FROM MTL_CUSTOMER_ITEMS yt, ra_customer_merges m
68: WHERE (
69: yt.CUSTOMER_ID = m.DUPLICATE_ID
70: OR yt.ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
71: ) AND m.process_flag = 'N'

Line 80: | MTL_CUSTOMER_ITEMS |

76: BEGIN
77:
78: arp_message.set_line( 'INV_CMERGE_ITEMS.MERGE()+' );
79: /*-----------------------+
80: | MTL_CUSTOMER_ITEMS |
81: +-----------------------*/
82: /* try to lock the table first */
83:
84: IF process_mode='LOCK' THEN

Line 88: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MTL_CUSTOMER_ITEMS',FALSE);

84: IF process_mode='LOCK' THEN
85: NULL;
86: ELSE
87: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
88: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MTL_CUSTOMER_ITEMS',FALSE);
89: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
90: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
91:
92: open merged_records;

Line 134: 'MTL_CUSTOMER_ITEMS',

130: LAST_UPDATE_LOGIN,
131: LAST_UPDATE_DATE,
132: LAST_UPDATED_BY
133: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
134: 'MTL_CUSTOMER_ITEMS',
135: MERGE_HEADER_ID_LIST(I),
136: PRIMARY_KEY_ID_LIST(I),
137: NUM_COL1_ORIG_LIST(I),
138: NUM_COL1_NEW_LIST(I),

Line 153: -- constraint violation error in mtl_customer_items_U1.

149:
150: END IF;
151:
152: -- Bug 4135064. Delete the records which on update will result in unique
153: -- constraint violation error in mtl_customer_items_U1.
154: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
155: DELETE FROM MTL_CUSTOMER_ITEMS mci
156: WHERE CUSTOMER_ITEM_ID=PRIMARY_KEY_ID_LIST(I)
157: AND EXISTS (SELECT 1 FROM MTL_CUSTOMER_ITEMS yt

Line 155: DELETE FROM MTL_CUSTOMER_ITEMS mci

151:
152: -- Bug 4135064. Delete the records which on update will result in unique
153: -- constraint violation error in mtl_customer_items_U1.
154: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
155: DELETE FROM MTL_CUSTOMER_ITEMS mci
156: WHERE CUSTOMER_ITEM_ID=PRIMARY_KEY_ID_LIST(I)
157: AND EXISTS (SELECT 1 FROM MTL_CUSTOMER_ITEMS yt
158: WHERE yt.CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
159: AND NVL(yt.ADDRESS_ID, -999) = NVL(NUM_COL2_NEW_LIST(I), -999)

Line 157: AND EXISTS (SELECT 1 FROM MTL_CUSTOMER_ITEMS yt

153: -- constraint violation error in mtl_customer_items_U1.
154: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
155: DELETE FROM MTL_CUSTOMER_ITEMS mci
156: WHERE CUSTOMER_ITEM_ID=PRIMARY_KEY_ID_LIST(I)
157: AND EXISTS (SELECT 1 FROM MTL_CUSTOMER_ITEMS yt
158: WHERE yt.CUSTOMER_ID = NUM_COL1_NEW_LIST(I)
159: AND NVL(yt.ADDRESS_ID, -999) = NVL(NUM_COL2_NEW_LIST(I), -999)
160: AND yt.CUSTOMER_ITEM_NUMBER = CUST_ITEM_NUM_LIST(I)
161: AND NVL(yt.CUSTOMER_CATEGORY_CODE, '@@@') = NVL(CUST_CATEGORY_CODE_LIST(I), '@@@')

Line 168: UPDATE MTL_CUSTOMER_ITEMS yt SET

164: );
165:
166: /* customer level update */
167: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
168: UPDATE MTL_CUSTOMER_ITEMS yt SET
169: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
170: ,ADDRESS_ID=NUM_COL2_NEW_LIST(I)
171: , LAST_UPDATE_DATE=SYSDATE
172: , last_updated_by=arp_standard.profile.user_id