APPS.GMS_CMERGE dependencies on RA_CUSTOMER_MERGES

Line 75: FROM GMS_AWARDS yt, ra_customer_merges m

71: ,LOC_BILL_TO_ADDRESS_ID
72: ,LOC_SHIP_TO_ADDRESS_ID
73: ,BILL_TO_CUSTOMER_ID
74: ,FUNDING_SOURCE_ID
75: FROM GMS_AWARDS yt, ra_customer_merges m
76: WHERE (
77: yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
78: OR yt.SHIP_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
79: OR yt.LOC_BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID

Line 258: FROM GMS_AWARDS_CONTACTS yt, ra_customer_merges m

254: ,yt.CUSTOMER_ID
255: ,yt.CONTACT_ID
256: ,yt.USAGE_CODE
257: ,yt.CUSTOMER_ID
258: FROM GMS_AWARDS_CONTACTS yt, ra_customer_merges m
259: WHERE (
260: yt.CUSTOMER_ID = m.DUPLICATE_ID
261: ) AND m.process_flag = 'N'
262: AND m.request_id = req_id

Line 394: FROM GMS_REPORTS yt, ra_customer_merges m

390: CURSOR merged_records IS
391: SELECT distinct CUSTOMER_MERGE_HEADER_ID
392: ,REPORT_ID
393: ,SITE_USE_ID
394: FROM GMS_REPORTS yt, ra_customer_merges m
395: WHERE (
396: yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
397: ) AND m.process_flag = 'N'
398: AND m.request_id = req_id

Line 518: FROM GMS_DEFAULT_REPORTS yt, ra_customer_merges m

514: CURSOR merged_records IS
515: SELECT distinct CUSTOMER_MERGE_HEADER_ID
516: ,DEFAULT_REPORT_ID
517: ,SITE_USE_ID
518: FROM GMS_DEFAULT_REPORTS yt, ra_customer_merges m
519: WHERE (
520: yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
521: ) AND m.process_flag = 'N'
522: AND m.request_id = req_id