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 168: RA_CUSTOMER_MERGES m

164: cip.INSTANCE_ID
165: FROM CSI_IP_ACCOUNTS yt,
166: CSI_I_PARTIES cip,
167: CSI_ITEM_INSTANCES cii,
168: RA_CUSTOMER_MERGES m
169: WHERE ( yt.PARTY_ACCOUNT_ID = m.DUPLICATE_ID OR
170: yt.BILL_TO_ADDRESS = m.DUPLICATE_SITE_ID OR
171: yt.SHIP_TO_ADDRESS = m.DUPLICATE_SITE_ID )
172: AND yt.instance_party_id = cip.instance_party_id

Line 319: FROM RA_CUSTOMER_MERGES

315:
316: BEGIN
317:
318: SELECT CUSTOMER_SITE_ID INTO l_install_customer_site_id
319: FROM RA_CUSTOMER_MERGES
320: WHERE CUSTOMER_MERGE_HEADER_ID=MERGE_HEADER_ID_LIST(I)
321: AND CUSTOMER_SITE_CODE='INSTALL_AT' ;
322:
323: EXCEPTION

Line 1474: RA_CUSTOMER_MERGES m

1470: yt.CUSTOMER_ID ,
1471: yt.BILL_TO_SITE_USE_ID ,
1472: yt.SHIP_TO_SITE_USE_ID
1473: FROM CSI_SYSTEMS_B yt,
1474: RA_CUSTOMER_MERGES m
1475: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID OR
1476: yt.BILL_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID OR
1477: yt.SHIP_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID )
1478: AND m.process_flag = 'N'

Line 1869: RA_CUSTOMER_MERGES m

1865: ACCOUNT_ID ,
1866: BILL_TO_ADDRESS_ID ,
1867: SHIP_TO_ADDRESS_ID
1868: FROM CSI_T_PARTY_ACCOUNTS yt,
1869: RA_CUSTOMER_MERGES m
1870: WHERE ( yt.ACCOUNT_ID = m.DUPLICATE_ID OR
1871: yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_SITE_ID OR
1872: yt.SHIP_TO_ADDRESS_ID = m.DUPLICATE_SITE_ID )
1873: AND m.process_flag = 'N'

Line 2066: RA_CUSTOMER_MERGES m

2062: yt.BILL_TO_SITE_USE_ID ,
2063: yt.SHIP_TO_SITE_USE_ID ,
2064: yt.INSTALL_SITE_USE_ID
2065: FROM CSI_T_TXN_SYSTEMS yt,
2066: RA_CUSTOMER_MERGES m
2067: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID OR
2068: yt.BILL_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID OR
2069: yt.SHIP_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID OR
2070: yt.INSTALL_SITE_USE_ID = m.DUPLICATE_SITE_ID )