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.OZF_ACCOUNT_MERGE_PKG dependencies on RA_CUSTOMER_MERGES

Line 59: FROM ozf_account_allocations yt, ra_customer_merges m

55: ,account_allocation_id
56: ,cust_account_id
57: ,bill_to_site_use_id
58: ,site_use_id
59: FROM ozf_account_allocations yt, ra_customer_merges m
60: WHERE (
61: yt.cust_account_id = m.DUPLICATE_ADDRESS_ID
62: OR yt.bill_to_site_use_id = m.DUPLICATE_SITE_ID
63: OR yt.site_use_id = m.DUPLICATE_SITE_ID

Line 207: FROM ozf_claim_lines yt, ra_customer_merges m

203: SELECT distinct CUSTOMER_MERGE_HEADER_ID
204: ,claim_line_id
205: ,related_cust_account_id
206: ,buy_group_cust_account_id
207: FROM ozf_claim_lines yt, ra_customer_merges m
208: WHERE (
209: yt.related_cust_account_id = m.DUPLICATE_ID
210: OR yt.buy_group_cust_account_id = m.DUPLICATE_ID
211: ) AND m.process_flag = 'N'

Line 351: FROM ozf_claim_lines_hist yt, ra_customer_merges m

347: SELECT distinct CUSTOMER_MERGE_HEADER_ID
348: ,claim_line_history_id
349: ,related_cust_account_id
350: ,buy_group_cust_account_id
351: FROM ozf_claim_lines_hist yt, ra_customer_merges m
352: WHERE (
353: yt.related_cust_account_id = m.DUPLICATE_ID
354: OR yt.buy_group_cust_account_id = m.DUPLICATE_ID
355: ) AND m.process_flag = 'N'

Line 523: FROM ozf_claims yt, ra_customer_merges m

519: ,cust_billto_acct_site_id
520: ,cust_shipto_acct_site_id
521: ,related_cust_account_id
522: ,related_site_use_id
523: FROM ozf_claims yt, ra_customer_merges m
524: WHERE (
525: yt.cust_account_id = m.DUPLICATE_ID
526: OR yt.ship_to_cust_account_id = m.DUPLICATE_ID
527: OR yt.cust_billto_acct_site_id = m.DUPLICATE_SITE_ID

Line 727: FROM ozf_claims_history yt, ra_customer_merges m

723: ,cust_billto_acct_site_id
724: ,cust_shipto_acct_site_id
725: ,related_cust_account_id
726: ,related_site_use_id
727: FROM ozf_claims_history yt, ra_customer_merges m
728: WHERE (
729: yt.cust_account_id = m.DUPLICATE_ID
730: OR yt.ship_to_cust_account_id = m.DUPLICATE_ID
731: OR yt.cust_billto_acct_site_id = m.DUPLICATE_SITE_ID

Line 896: FROM ozf_code_conversions yt, ra_customer_merges m

892: CURSOR merged_records IS
893: SELECT distinct CUSTOMER_MERGE_HEADER_ID
894: ,code_conversion_id
895: ,cust_account_id
896: FROM ozf_code_conversions yt, ra_customer_merges m
897: WHERE (
898: yt.cust_account_id = m.DUPLICATE_ID
899: ) AND m.process_flag = 'N'
900: AND m.request_id = req_id

Line 1034: FROM ozf_cust_daily_facts yt, ra_customer_merges m

1030: ,cust_daily_fact_id
1031: ,cust_account_id
1032: ,bill_to_site_use_id
1033: ,ship_to_site_use_id
1034: FROM ozf_cust_daily_facts yt, ra_customer_merges m
1035: WHERE (
1036: yt.cust_account_id = m.DUPLICATE_ADDRESS_ID
1037: OR yt.bill_to_site_use_id = m.DUPLICATE_SITE_ID
1038: OR yt.ship_to_site_use_id = m.DUPLICATE_SITE_ID

Line 1182: FROM ozf_funds_utilized_all_b yt, ra_customer_merges m

1178: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1179: ,utilization_id
1180: ,cust_account_id
1181: ,billto_cust_account_id
1182: FROM ozf_funds_utilized_all_b yt, ra_customer_merges m
1183: WHERE (
1184: yt.cust_account_id = m.DUPLICATE_ID
1185: OR yt.billto_cust_account_id = m.DUPLICATE_ID
1186: ) AND m.process_flag = 'N'

Line 1332: FROM ozf_activity_customers yt, ra_customer_merges m

1328: ,object_class
1329: ,object_id
1330: ,cust_account_id
1331: ,site_use_id
1332: FROM ozf_activity_customers yt, ra_customer_merges m
1333: WHERE (
1334: yt.cust_account_id = m.DUPLICATE_ADDRESS_ID
1335: OR yt.site_use_id = m.DUPLICATE_SITE_ID
1336: ) AND m.process_flag = 'N'

Line 1470: FROM ozf_offers yt, ra_customer_merges m

1466: CURSOR merged_records IS
1467: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1468: ,qp_list_header_id
1469: ,beneficiary_account_id
1470: FROM ozf_offers yt, ra_customer_merges m
1471: WHERE (
1472: yt.beneficiary_account_id = m.DUPLICATE_ADDRESS_ID
1473: ) AND m.process_flag = 'N'
1474: AND m.request_id = req_id

Line 1610: FROM ozf_request_headers_all_b yt, ra_customer_merges m

1606: ,request_header_id
1607: ,reseller_site_use_id
1608: ,end_cust_site_use_id
1609: ,partner_site_use_id
1610: FROM ozf_request_headers_all_b yt, ra_customer_merges m
1611: WHERE (
1612: yt.reseller_site_use_id = m.DUPLICATE_SITE_ID
1613: OR yt.end_cust_site_use_id = m.DUPLICATE_SITE_ID
1614: OR yt.partner_site_use_id = m.DUPLICATE_SITE_ID

Line 1762: FROM ozf_retail_price_points yt, ra_customer_merges m

1758: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1759: ,retail_price_point_id
1760: ,cust_account_id
1761: ,site_use_id
1762: FROM ozf_retail_price_points yt, ra_customer_merges m
1763: WHERE (
1764: yt.cust_account_id = m.DUPLICATE_ADDRESS_ID
1765: OR yt.site_use_id = m.DUPLICATE_SITE_ID
1766: ) AND m.process_flag = 'N'

Line 1903: FROM ozf_cust_trd_prfls yt, ra_customer_merges m

1899: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1900: ,trade_profile_id
1901: ,cust_account_id
1902: ,cust_acct_site_id
1903: FROM ozf_cust_trd_prfls yt, ra_customer_merges m
1904: WHERE (
1905: yt.cust_account_id = m.DUPLICATE_ID
1906: OR yt.cust_acct_site_id = m.DUPLICATE_SITE_ID
1907: ) AND m.process_flag = 'N'