APPS.OKS_HZ_MERGE_PUB dependencies on RA_CUSTOMER_MERGES

Line 76: FROM ra_customer_merges cme

72: CURSOR c_lock_bpe IS
73: SELECT 1
74: FROM oks_billing_profiles_b bpe
75: WHERE bpe.dependent_cust_acct_id1 IN (SELECT cme.duplicate_id
76: FROM ra_customer_merges cme
77: WHERE cme.process_flag = 'N'
78: AND cme.request_id = req_id
79: AND cme.set_number = set_number
80: )

Line 135: FROM OKS_BILLING_PROFILES_B yt, ra_customer_merges m

131: SELECT distinct CUSTOMER_MERGE_HEADER_ID
132: ,ID
133: ,DEPENDENT_CUST_ACCT_ID1
134: ,OBJECT_VERSION_NUMBER
135: FROM OKS_BILLING_PROFILES_B yt, ra_customer_merges m
136: WHERE (
137: yt.DEPENDENT_CUST_ACCT_ID1 = m.DUPLICATE_ID
138: OR yt.OBJECT_VERSION_NUMBER = m.DUPLICATE_SITE_ID
139: ) AND m.process_flag = 'N'

Line 245: FROM OKS_BILLING_PROFILES_B yt, ra_customer_merges m

241: decode(yt.DEPENDENT_CUST_ACCT_ID1,m.DUPLICATE_ID,m.CUSTOMER_ID,yt.DEPENDENT_CUST_ACCT_ID1),
242: OBJECT_VERSION_NUMBER,
243: OBJECT_VERSION_NUMBER,
244: request_id
245: FROM OKS_BILLING_PROFILES_B yt, ra_customer_merges m
246: WHERE (
247: yt.DEPENDENT_CUST_ACCT_ID1 = m.DUPLICATE_ID
248: -- OR yt.BILL_TO_ADDRESS_ID1 = m.DUPLICATE_SITE_ID
249: ) AND m.process_flag = 'N'

Line 268: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h

264: , last_updated_by=arp_standard.profile.user_id
265: , last_update_login=arp_standard.profile.last_update_login
266: WHERE (ID) in (
267: SELECT PRIMARY_KEY_ID
268: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h
269: WHERE h.CUSTOMER_MERGE_HEADER_ID = l1.MERGE_HEADER_ID
270: AND l1.TABLE_NAME = 'OKS_BILLING_PROFILES_B'
271: AND l1.REQUEST_ID = req_id
272: AND h.set_number = set_number);

Line 332: FROM OKS_BILLING_PROFILES_B yt, ra_customer_merges m

328: SELECT distinct CUSTOMER_MERGE_HEADER_ID
329: ,ID
330: ,BILL_TO_ADDRESS_ID1
331: ,OBJECT_VERSION_NUMBER
332: FROM OKS_BILLING_PROFILES_B yt, ra_customer_merges m
333: WHERE (
334: yt.BILL_TO_ADDRESS_ID1 = m.DUPLICATE_SITE_ID
335: ) AND m.process_flag = 'N'
336: AND m.request_id = req_id

Line 346: FROM OKS_K_HEADERS_B hdr, ra_customer_merges m

342: SELECT distinct CUSTOMER_MERGE_HEADER_ID
343: ,ID
344: ,QUOTE_TO_SITE_ID
345: ,OBJECT_VERSION_NUMBER
346: FROM OKS_K_HEADERS_B hdr, ra_customer_merges m
347: WHERE (
348: hdr.QUOTE_TO_SITE_ID = m.DUPLICATE_ADDRESS_ID
349: ) AND m.process_flag = 'N'
350: AND m.request_id = req_id

Line 535: ,ra_customer_merges cme

531: --
532: CURSOR c_reason IS
533: SELECT cmh.merge_reason_code
534: FROM ra_customer_merge_headers cmh
535: ,ra_customer_merges cme
536: WHERE cmh.customer_merge_header_id = cme.customer_merge_header_id
537: AND cme.request_id = req_id
538: AND cme.set_number = set_number
539: AND cme.process_flag = 'N'

Line 548: FROM ra_customer_merges cme

544: -- or a site merge within the same account
545: --
546: CURSOR c_site_merge(b_request_id NUMBER, b_set_number NUMBER) IS
547: SELECT customer_id, duplicate_id
548: FROM ra_customer_merges cme
549: WHERE cme.request_id = req_id
550: AND cme.set_number = set_number
551: AND cme.process_flag = 'N'
552: ;