DBA Data[Home] [Help]

APPS.ASO_MERGE_PVT dependencies on RA_CUSTOMER_MERGES

Line 94: FROM ASO_QUOTE_HEADERS yt, ra_customer_merges m

90: ,QUOTE_HEADER_ID
91: ,CUST_ACCOUNT_ID
92: ,INVOICE_TO_CUST_ACCOUNT_ID
93: ,END_CUSTOMER_CUST_ACCOUNT_ID
94: FROM ASO_QUOTE_HEADERS yt, ra_customer_merges m
95: WHERE (
96: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
97: OR yt.INVOICE_TO_CUST_ACCOUNT_ID = m.DUPLICATE_ID
98: OR yt.END_CUSTOMER_CUST_ACCOUNT_ID = m.DUPLICATE_ID

Line 291: FROM ASO_QUOTE_LINES yt, ra_customer_merges m

287: SELECT distinct CUSTOMER_MERGE_HEADER_ID
288: ,QUOTE_LINE_ID
289: ,INVOICE_TO_CUST_ACCOUNT_ID
290: ,END_CUSTOMER_CUST_ACCOUNT_ID
291: FROM ASO_QUOTE_LINES yt, ra_customer_merges m
292: WHERE (
293: yt.INVOICE_TO_CUST_ACCOUNT_ID = m.DUPLICATE_ID
294: OR yt.END_CUSTOMER_CUST_ACCOUNT_ID = m.DUPLICATE_ID
295: ) AND m.process_flag = 'N'

Line 461: FROM ASO_SHIPMENTS yt, ra_customer_merges m

457: CURSOR merged_records IS
458: SELECT distinct CUSTOMER_MERGE_HEADER_ID
459: ,SHIPMENT_ID
460: ,SHIP_TO_CUST_ACCOUNT_ID
461: FROM ASO_SHIPMENTS yt, ra_customer_merges m
462: WHERE (
463: yt.SHIP_TO_CUST_ACCOUNT_ID = m.DUPLICATE_ID
464: ) AND m.process_flag = 'N'
465: AND m.request_id = req_id