DBA Data[Home] [Help]

APPS.CSI_ACCT_MERGE_PKG dependencies on CSI_I_PARTIES

Line 107: CSI_I_PARTIES.INSTANCE_PARTY_ID%TYPE

103: NUM_COL1_ORIG_LIST PARTY_ACCT_ID_LIST_TYPE;
104: NUM_COL1_NEW_LIST PARTY_ACCT_ID_LIST_TYPE;
105:
106: TYPE INSTANCE_PARTY_ID_LIST_TYPE IS TABLE OF
107: CSI_I_PARTIES.INSTANCE_PARTY_ID%TYPE
108: INDEX BY BINARY_INTEGER;
109:
110: INSTANCE_PARTY_ID_LIST INSTANCE_PARTY_ID_LIST_TYPE;
111:

Line 172: , CSI_I_PARTIES CIP

168: , CIP.INSTANCE_PARTY_ID
169: , CIP.INSTANCE_ID
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 )

Line 195: , CSI_I_PARTIES CIP

191: , CIP.INSTANCE_ID
192: , cii.last_vld_organization_id
193:
194: FROM CSI_IP_ACCOUNTS YT
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