APPS.INVP_CMERGE_TXHI dependencies on MTL_UNIT_TRANSACTIONS

Line 15: FROM MTL_UNIT_TRANSACTIONS

11: procedure INV_MUT (req_id NUMBER, set_num NUMBER, process_mode VARCHAR2) is
12:
13: CURSOR C1 IS
14: SELECT NULL
15: FROM MTL_UNIT_TRANSACTIONS
16: WHERE customer_id in (select racm.duplicate_id
17: from ra_customer_merges racm
18: where racm.process_flag = 'N'
19: and racm.request_id = req_id

Line 27: MTL_UNIT_TRANSACTIONS or updation of customer_id in MTL_UNIT_TRANSACTIONS

23:
24: BEGIN
25: arp_message.set_line( 'INVP_CMERGE_TXHI.INV_MUT()+' );
26: /*Bug#5574255. Modified code in such a way that LOCKING of rows of
27: MTL_UNIT_TRANSACTIONS or updation of customer_id in MTL_UNIT_TRANSACTIONS
28: happens only if there is at least one row in MTL_UNIT_TRANSACTIONS with
29: non-zero and non-null customer_id.*/
30:
31: /*Bug 13795366 Added the index_ffs after SELECT to increase the performace significantly for

Line 28: happens only if there is at least one row in MTL_UNIT_TRANSACTIONS with

24: BEGIN
25: arp_message.set_line( 'INVP_CMERGE_TXHI.INV_MUT()+' );
26: /*Bug#5574255. Modified code in such a way that LOCKING of rows of
27: MTL_UNIT_TRANSACTIONS or updation of customer_id in MTL_UNIT_TRANSACTIONS
28: happens only if there is at least one row in MTL_UNIT_TRANSACTIONS with
29: non-zero and non-null customer_id.*/
30:
31: /*Bug 13795366 Added the index_ffs after SELECT to increase the performace significantly for
32: customer merge*/

Line 37: WHERE EXISTS ( SELECT /*+ index_ffs(MTL_UNIT_TRANSACTIONS MTL_UNIT_TRANSACTIONS_N3)*/ 1

33: BEGIN
34: SELECT 1
35: INTO mut_cust_flag
36: FROM dual
37: WHERE EXISTS ( SELECT /*+ index_ffs(MTL_UNIT_TRANSACTIONS MTL_UNIT_TRANSACTIONS_N3)*/ 1
38: FROM mtl_unit_transactions
39: WHERE customer_id <> 0);
40: EXCEPTION WHEN OTHERS THEN
41: mut_cust_flag := 0;

Line 38: FROM mtl_unit_transactions

34: SELECT 1
35: INTO mut_cust_flag
36: FROM dual
37: WHERE EXISTS ( SELECT /*+ index_ffs(MTL_UNIT_TRANSACTIONS MTL_UNIT_TRANSACTIONS_N3)*/ 1
38: FROM mtl_unit_transactions
39: WHERE customer_id <> 0);
40: EXCEPTION WHEN OTHERS THEN
41: mut_cust_flag := 0;
42: END;

Line 45: | MTL_UNIT_TRANSACTIONS |

41: mut_cust_flag := 0;
42: END;
43:
44: /*-----------------------+
45: | MTL_UNIT_TRANSACTIONS |
46: +-----------------------*/
47: /* try to lock the table first */
48: IF ( mut_cust_flag <> 0) THEN
49: IF (process_mode = 'LOCK') then

Line 51: arp_message.set_token( 'TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE );

47: /* try to lock the table first */
48: IF ( mut_cust_flag <> 0) THEN
49: IF (process_mode = 'LOCK') then
50: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
51: arp_message.set_token( 'TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE );
52:
53: OPEN C1;
54: CLOSE C1;
55:

Line 61: arp_message.set_token('TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE);

57:
58: /* customer level update */
59:
60: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
61: arp_message.set_token('TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE);
62: arp_message.set_line('customer level : customer_id');
63:
64: UPDATE MTL_UNIT_TRANSACTIONS yt
65: set customer_id = (select distinct racm.customer_id

Line 64: UPDATE MTL_UNIT_TRANSACTIONS yt

60: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
61: arp_message.set_token('TABLE_NAME', 'MTL_UNIT_TRANSACTIONS', FALSE);
62: arp_message.set_line('customer level : customer_id');
63:
64: UPDATE MTL_UNIT_TRANSACTIONS yt
65: set customer_id = (select distinct racm.customer_id
66: from ra_customer_merges racm
67: where yt.customer_id =
68: racm.duplicate_id