APPS.IBE_MERGE_PVT dependencies on RA_CUSTOMER_MERGES

Line 128: FROM IBE_ORD_ONECLICK_ALL yt, ra_customer_merges m

124: SELECT distinct CUSTOMER_MERGE_HEADER_ID
125: ,yt.ord_oneclick_id
126: ,yt.CUST_ACCOUNT_ID
127: ,yt.party_id
128: FROM IBE_ORD_ONECLICK_ALL yt, ra_customer_merges m
129: WHERE
130: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
131: AND m.process_flag = 'N'
132: AND m.request_id = req_id

Line 249: FROM IBE_SH_SHP_LISTS_ALL yt, ra_customer_merges m

245: SELECT distinct CUSTOMER_MERGE_HEADER_ID
246: ,yt.SHP_LIST_ID
247: ,yt.CUST_ACCOUNT_ID
248: ,yt.party_id
249: FROM IBE_SH_SHP_LISTS_ALL yt, ra_customer_merges m
250: WHERE
251: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
252: AND m.process_flag = 'N'
253: AND m.request_id = req_id

Line 407: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b, RA_CUSTOMER_MERGES RACM

403:
404: --cursor to get account and party IDs, quote name and quote_header_id
405: Cursor C_ACTIVE_QUOTE_FROM is
406: Select a.quote_header_id, a.cust_account_id, a.party_id, b.quote_name, racm.customer_merge_id
407: from IBE_ACTIVE_QUOTES_ALL a, ASO_QUOTE_HEADERS_ALL b, RA_CUSTOMER_MERGES RACM
408: Where a.quote_header_id = b.quote_header_id (+)
409: and a.party_id = b.party_id (+)
410: and a.cust_account_id = b.cust_account_id (+)
411: and a.cust_account_id = racm.duplicate_id

Line 561: from IBE_SH_QUOTE_ACCESS i, RA_CUSTOMER_MERGES RACM

557: /*retrive account shared carts*/
558: Cursor C_SHARED_QUOTE_FROM is
559: Select distinct customer_merge_header_id,quote_header_id,
560: i.party_id, RACM.DUPLICATE_ID, RACM.CUSTOMER_ID,quote_sharee_id
561: from IBE_SH_QUOTE_ACCESS i, RA_CUSTOMER_MERGES RACM
562: Where i.cust_account_id = RACM.DUPLICATE_ID
563: AND RACM.PROCESS_FLAG='N'
564: AND RACM.REQUEST_ID = req_id
565: AND RACM.SET_NUMBER = set_num;

Line 719: p_customer_id RA_CUSTOMER_MERGES.CUSTOMER_ID%TYPE;

715: IS
716:
717: g_count NUMBER;
718: p_request_id NUMBER;
719: p_customer_id RA_CUSTOMER_MERGES.CUSTOMER_ID%TYPE;
720: p_duplicate_id RA_CUSTOMER_MERGES.DUPLICATE_ID%TYPE;
721: p_allow_merge VARCHAR2(1) := 'Y';
722: p_customer_type RA_CUSTOMER_MERGES.CUSTOMER_TYPE%TYPE;
723: l_from_quote_id NUMBER;

Line 720: p_duplicate_id RA_CUSTOMER_MERGES.DUPLICATE_ID%TYPE;

716:
717: g_count NUMBER;
718: p_request_id NUMBER;
719: p_customer_id RA_CUSTOMER_MERGES.CUSTOMER_ID%TYPE;
720: p_duplicate_id RA_CUSTOMER_MERGES.DUPLICATE_ID%TYPE;
721: p_allow_merge VARCHAR2(1) := 'Y';
722: p_customer_type RA_CUSTOMER_MERGES.CUSTOMER_TYPE%TYPE;
723: l_from_quote_id NUMBER;
724: l_from_party_id NUMBER;

Line 722: p_customer_type RA_CUSTOMER_MERGES.CUSTOMER_TYPE%TYPE;

718: p_request_id NUMBER;
719: p_customer_id RA_CUSTOMER_MERGES.CUSTOMER_ID%TYPE;
720: p_duplicate_id RA_CUSTOMER_MERGES.DUPLICATE_ID%TYPE;
721: p_allow_merge VARCHAR2(1) := 'Y';
722: p_customer_type RA_CUSTOMER_MERGES.CUSTOMER_TYPE%TYPE;
723: l_from_quote_id NUMBER;
724: l_from_party_id NUMBER;
725: l_from_acct_id NUMBER;
726: l_to_acct_id NUMBER;

Line 736: FROM RA_CUSTOMER_MERGES RACM

732:
733: --2940366 add customer type, change requestID
734: CURSOR C_CUST (req_id NUMBER) is
735: SELECT RACM.CUSTOMER_ID,RACM.DUPLICATE_ID,RACM.CUSTOMER_TYPE
736: FROM RA_CUSTOMER_MERGES RACM
737: WHERE RACM.PROCESS_FLAG='N'
738: AND RACM.REQUEST_ID = req_id
739: AND RACM.SET_NUMBER = set_number;
740: