eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_CMERGE dependencies on RA_CUSTOMER_MERGES

Line 75: FROM FV_CUST_FINANCE_CHRGS yt, ra_customer_merges m

71: SELECT distinct CUSTOMER_MERGE_HEADER_ID
72: ,yt.CUSTOMER_ID
73: ,yt.CHARGE_ID
74: ,yt.CUSTOMER_ID
75: FROM FV_CUST_FINANCE_CHRGS yt, ra_customer_merges m
76: WHERE (
77: yt.CUSTOMER_ID = m.DUPLICATE_ID
78: ) AND m.process_flag = 'N'
79: AND m.request_id = req_id

Line 100: from ra_customer_merges racm,

96: --remove records from table that will be duplicates when merged.
97: delete from fv_cust_finance_chrgs
98: where (customer_id, charge_id) in
99: (select duplicate_id, charge_id
100: from ra_customer_merges racm,
101: fv_cust_finance_chrgs fcfc
102: where racm.process_flag = 'N'
103: and racm.request_id = req_id
104: and racm.set_number = set_num

Line 226: FROM FV_CUST_VEND_XREFS yt, ra_customer_merges m

222: CURSOR merged_records IS
223: SELECT distinct CUSTOMER_MERGE_HEADER_ID
224: ,CUST_VEND_XREF_ID
225: ,yt.CUSTOMER_ID
226: FROM FV_CUST_VEND_XREFS yt, ra_customer_merges m
227: WHERE (
228: yt.CUSTOMER_ID = m.DUPLICATE_ID
229: ) AND m.process_flag = 'N'
230: AND m.request_id = req_id

Line 250: from ra_customer_merges racm,

246:
247: -- remove the records that will be duplicates when merged.
248: delete from fv_cust_vend_xrefs
249: where customer_id IN (select duplicate_id
250: from ra_customer_merges racm,
251: fv_cust_vend_xrefs t
252: where racm.process_flag = 'N'
253: and racm.request_id = req_id
254: and racm.set_number = set_num

Line 376: FROM FV_INTERAGENCY_FUNDS yt, ra_customer_merges m

372: CURSOR merged_records IS
373: SELECT distinct CUSTOMER_MERGE_HEADER_ID
374: ,INTERAGENCY_FUND_ID
375: ,yt.CUSTOMER_ID
376: FROM FV_INTERAGENCY_FUNDS yt, ra_customer_merges m
377: WHERE (
378: yt.CUSTOMER_ID = m.DUPLICATE_ID
379: ) AND m.process_flag = 'N'
380: AND m.request_id = req_id

Line 530: FROM FV_INTERIM_CASH_RECEIPTS yt, ra_customer_merges m

526: ,CUSTOMER_TRX_ID
527: ,RECEIPT_NUMBER
528: ,yt.CUSTOMER_ID
529: ,yt.SITE_USE_ID
530: FROM FV_INTERIM_CASH_RECEIPTS yt, ra_customer_merges m
531: WHERE (
532: yt.CUSTOMER_ID = m.DUPLICATE_ID
533: OR yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
534: ) AND m.process_flag = 'N'

Line 693: FROM FV_INVOICE_FINANCE_CHRGS yt, ra_customer_merges m

689: ,CUSTOMER_TRX_ID
690: ,yt.CUSTOMER_ID
691: ,CHARGE_ID
692: ,yt.CUSTOMER_ID
693: FROM FV_INVOICE_FINANCE_CHRGS yt, ra_customer_merges m
694: WHERE (
695: yt.CUSTOMER_ID = m.DUPLICATE_ID
696: ) AND m.process_flag = 'N'
697: AND m.request_id = req_id

Line 833: FROM FV_IPAC_TRX yt, ra_customer_merges m

829: CURSOR merged_records IS
830: SELECT distinct CUSTOMER_MERGE_HEADER_ID
831: ,IPAC_BILLING_ID
832: ,yt.CUSTOMER_ID
833: FROM FV_IPAC_TRX yt, ra_customer_merges m
834: WHERE (
835: yt.CUSTOMER_ID = m.DUPLICATE_ID
836: ) AND m.process_flag = 'N'
837: AND m.request_id = req_id