DBA Data[Home] [Help]

APPS.ASO_MERGE_PVT dependencies on RA_CUSTOMER_MERGES

Line 95: FROM ASO_QUOTE_HEADERS yt, ra_customer_merges m

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

Line 292: FROM ASO_QUOTE_LINES yt, ra_customer_merges m

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

Line 462: FROM ASO_SHIPMENTS yt, ra_customer_merges m

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