DBA Data[Home] [Help]

APPS.ISC_DBI_ACCT_MERGE_PKG dependencies on RA_CUSTOMER_MERGES

Line 43: FROM ISC_BOOK_SUM2_PDUE_F yt, ra_customer_merges m

39: SELECT distinct CUSTOMER_MERGE_HEADER_ID
40: ,LINE_ID
41: ,SOLD_TO_ORG_ID
42: ,SHIP_TO_ORG_ID
43: FROM ISC_BOOK_SUM2_PDUE_F yt, ra_customer_merges m
44: WHERE (
45: yt.SOLD_TO_ORG_ID = m.DUPLICATE_ID
46: OR yt.SHIP_TO_ORG_ID = m.DUPLICATE_SITE_ID
47: ) AND m.process_flag = 'N'

Line 181: FROM ISC_BOOK_SUM2_PDUE2_F yt, ra_customer_merges m

177: SELECT distinct CUSTOMER_MERGE_HEADER_ID
178: ,LINE_ID
179: ,SOLD_TO_ORG_ID
180: ,SHIP_TO_ORG_ID
181: FROM ISC_BOOK_SUM2_PDUE2_F yt, ra_customer_merges m
182: WHERE (
183: yt.SOLD_TO_ORG_ID = m.DUPLICATE_ID
184: OR yt.SHIP_TO_ORG_ID = m.DUPLICATE_SITE_ID
185: ) AND m.process_flag = 'N'

Line 319: FROM ISC_BOOK_SUM2_BKORD_F yt, ra_customer_merges m

315: SELECT distinct CUSTOMER_MERGE_HEADER_ID
316: ,LINE_ID
317: ,SOLD_TO_ORG_ID
318: ,SHIP_TO_ORG_ID
319: FROM ISC_BOOK_SUM2_BKORD_F yt, ra_customer_merges m
320: WHERE (
321: yt.SOLD_TO_ORG_ID = m.DUPLICATE_ID
322: OR yt.SHIP_TO_ORG_ID = m.DUPLICATE_SITE_ID
323: ) AND m.process_flag = 'N'