APPS.CSI_ACCT_MERGE_PKG dependencies on RA_CUSTOMER_MERGES

Line 88: RA_CUSTOMER_MERGES.CUSTOMER_SITE_ID%TYPE

84:
85: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
86:
87: TYPE CUSTOMER_SITE_ID_LIST_TYPE IS TABLE OF
88: RA_CUSTOMER_MERGES.CUSTOMER_SITE_ID%TYPE
89: INDEX BY BINARY_INTEGER;
90:
91: INSTALL_CUSTOMER_SITE_ID_LIST CUSTOMER_SITE_ID_LIST_TYPE;
92:

Line 174: , RA_CUSTOMER_MERGES M

170: , cii.last_vld_organization_id
171: FROM CSI_IP_ACCOUNTS YT
172: , CSI_I_PARTIES CIP
173: , CSI_ITEM_INSTANCES CII
174: , RA_CUSTOMER_MERGES M
175: WHERE (YT.BILL_TO_ADDRESS = M.DUPLICATE_SITE_ID OR
176: YT.SHIP_TO_ADDRESS = M.DUPLICATE_SITE_ID )
177: AND YT.INSTANCE_PARTY_ID = CIP.INSTANCE_PARTY_ID
178: AND ( YT.ACTIVE_END_DATE IS NULL OR YT.ACTIVE_END_DATE > SYSDATE )

Line 199: FROM RA_CUSTOMER_MERGES M2

195: , CSI_I_PARTIES CIP
196: , CSI_ITEM_INSTANCES CII
197: , (SELECT DISTINCT M2.CUSTOMER_MERGE_HEADER_ID
198: ,M2.DUPLICATE_ID
199: FROM RA_CUSTOMER_MERGES M2
200: WHERE M2.PROCESS_FLAG = 'N'
201: AND M2.REQUEST_ID = req_id
202: AND M2.SET_NUMBER = set_num) M
203: WHERE YT.PARTY_ACCOUNT_ID = M.DUPLICATE_ID

Line 361: FROM RA_CUSTOMER_MERGES

357:
358: BEGIN
359: csi_t_gen_utility_pvt.add('MERGE_HEADER_ID_LIST : '||MERGE_HEADER_ID_LIST(I));
360: SELECT CUSTOMER_SITE_ID INTO l_install_customer_site_id
361: FROM RA_CUSTOMER_MERGES
362: WHERE CUSTOMER_MERGE_HEADER_ID=MERGE_HEADER_ID_LIST(I)
363: AND CUSTOMER_SITE_CODE='INSTALL_AT'
364: AND NVL(org_id,-9999)=ORG_ID_LIST(I);
365: csi_t_gen_utility_pvt.add('l_install_customer_site_id : '||l_install_customer_site_id);

Line 1506: RA_CUSTOMER_MERGES m

1502: yt.CUSTOMER_ID ,
1503: yt.BILL_TO_SITE_USE_ID ,
1504: yt.SHIP_TO_SITE_USE_ID
1505: FROM CSI_SYSTEMS_B yt,
1506: RA_CUSTOMER_MERGES m
1507: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID OR
1508: yt.BILL_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID OR
1509: yt.SHIP_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID )
1510: AND m.process_flag = 'N'

Line 1901: RA_CUSTOMER_MERGES m

1897: ACCOUNT_ID ,
1898: BILL_TO_ADDRESS_ID ,
1899: SHIP_TO_ADDRESS_ID
1900: FROM CSI_T_PARTY_ACCOUNTS yt,
1901: RA_CUSTOMER_MERGES m
1902: WHERE ( yt.ACCOUNT_ID = m.DUPLICATE_ID OR
1903: yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_SITE_ID OR
1904: yt.SHIP_TO_ADDRESS_ID = m.DUPLICATE_SITE_ID )
1905: AND m.process_flag = 'N'

Line 2098: RA_CUSTOMER_MERGES m

2094: yt.BILL_TO_SITE_USE_ID ,
2095: yt.SHIP_TO_SITE_USE_ID ,
2096: yt.INSTALL_SITE_USE_ID
2097: FROM CSI_T_TXN_SYSTEMS yt,
2098: RA_CUSTOMER_MERGES m
2099: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID OR
2100: yt.BILL_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID OR
2101: yt.SHIP_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID OR
2102: yt.INSTALL_SITE_USE_ID = m.DUPLICATE_SITE_ID )