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

Line 44: FROM ra_customer_merges

40: duplicate_site_id, customer_site_id
41: BULK COLLECT INTO l_duplicateIdTab, l_customerIdTab,
42: l_duplicateAddressIdTab, l_customerAddressIdTab,
43: l_duplicateSiteIdTab, l_customerSiteIdTab
44: FROM ra_customer_merges
45: WHERE process_flag = 'N'
46: AND request_id = Req_Id
47: AND set_number = Set_Num;
48: END IF;

Line 103: RA_CUSTOMER_MERGES m

99: ck.cum_note_text,
100: m.duplicate_address_id,
101: m.customer_address_id
102: FROM RLM_CUST_ITEM_CUM_KEYS ck,
103: RA_CUSTOMER_MERGES m
104: WHERE m.process_flag = 'N'
105: AND m.request_id = req_id
106: AND m.set_number = set_num
107: AND (ck.intrmd_ship_to_id = m.duplicate_address_id

Line 247: RA_CUSTOMER_MERGES m

243: m.customer_address_id,
244: --bug 2171856
245: m.customer_name
246: FROM RLM_INTERFACE_HEADERS ih,
247: RA_CUSTOMER_MERGES m
248: WHERE m.process_flag = 'N'
249: AND m.request_id = req_id
250: AND m.set_number = set_num
251: AND (ih.customer_id = m.duplicate_id

Line 392: RA_CUSTOMER_MERGES m

388: m.customer_site_id,
389: m.duplicate_id,
390: m.customer_id
391: FROM RLM_INTERFACE_LINES il,
392: RA_CUSTOMER_MERGES m
393: WHERE m.process_flag = 'N'
394: AND m.request_id = req_id
395: AND m.set_number = set_num
396: AND (il.bill_to_address_id = m.duplicate_address_id

Line 557: RA_CUSTOMER_MERGES m

553: m.duplicate_address_id,
554: m.customer_address_id,
555: m.customer_name
556: FROM RLM_SCHEDULE_HEADERS sh,
557: RA_CUSTOMER_MERGES m
558: WHERE m.process_flag = 'N'
559: AND m.request_id = req_id
560: AND m.set_number = set_num
561: AND (sh.customer_id = m.duplicate_id

Line 699: RA_CUSTOMER_MERGES m

695: m.customer_site_id,
696: m.duplicate_id,
697: m.customer_id
698: FROM RLM_SCHEDULE_LINES il,
699: RA_CUSTOMER_MERGES m
700: WHERE m.process_flag = 'N'
701: AND m.request_id = req_id
702: AND m.set_number = set_num
703: AND (il.bill_to_address_id = m.duplicate_address_id

Line 857: from ra_customer_merges m

853: customer_id
854: FROM RLM_CUST_SHIPTO_TERMS
855: WHERE customer_id in
856: (select m.duplicate_id
857: from ra_customer_merges m
858: where m.process_flag = 'N'
859: and m.request_id = req_id
860: and m.set_number = set_num)
861: OR address_id in

Line 863: from ra_customer_merges m

859: and m.request_id = req_id
860: and m.set_number = set_num)
861: OR address_id in
862: (select m.duplicate_address_id
863: from ra_customer_merges m
864: where m.process_flag = 'N'
865: and m.request_id = req_id
866: and m.set_number = set_num)
867: FOR update nowait;

Line 872: FROM rlm_cust_shipto_terms yt,ra_customer_merges m

868:
869: /*2447493*/
870: CURSOR merge_records_cur IS
871: SELECT distinct CUSTOMER_MERGE_HEADER_ID
872: FROM rlm_cust_shipto_terms yt,ra_customer_merges m
873: where yt.customer_id = m.duplicate_id
874: AND m.process_flag = 'N'
875: AND m.request_id = req_id
876: AND m.set_number = set_num;

Line 882: from ra_customer_merges m

878: CURSOR cust_shipto_terms_cur is
879: SELECT * from rlm_cust_shipto_terms
880: where customer_id in
881: (select m.duplicate_id
882: from ra_customer_merges m
883: where m.process_flag = 'N'
884: and m.request_id = req_id
885: and m.set_number = set_num)
886: OR address_id in

Line 888: from ra_customer_merges m

884: and m.request_id = req_id
885: and m.set_number = set_num)
886: OR address_id in
887: (select m.duplicate_address_id
888: from ra_customer_merges m
889: where m.process_flag = 'N'
890: and m.request_id = req_id
891: and m.set_number = set_num)
892: FOR update nowait;

Line 1262: from ra_customer_merges m

1258: customer_id
1259: FROM RLM_CUST_ITEM_TERMS
1260: WHERE customer_id in
1261: (select m.duplicate_id
1262: from ra_customer_merges m
1263: where m.process_flag = 'N'
1264: and m.request_id = req_id
1265: and m.set_number = set_num)
1266: OR address_id in

Line 1268: from ra_customer_merges m

1264: and m.request_id = req_id
1265: and m.set_number = set_num)
1266: OR address_id in
1267: (select m.duplicate_address_id
1268: from ra_customer_merges m
1269: where m.process_flag = 'N'
1270: and m.request_id = req_id
1271: and m.set_number = set_num)
1272: FOR update nowait;

Line 1277: FROM rlm_cust_shipto_terms yt,ra_customer_merges m

1273:
1274: /*2447493*/
1275: CURSOR merge_records_cur IS
1276: SELECT distinct CUSTOMER_MERGE_HEADER_ID
1277: FROM rlm_cust_shipto_terms yt,ra_customer_merges m
1278: where yt.customer_id = m.duplicate_id
1279: AND m.process_flag = 'N'
1280: AND m.request_id = req_id
1281: AND m.set_number = set_num;

Line 1287: from ra_customer_merges m

1283: CURSOR cust_item_terms_cur is
1284: SELECT * from rlm_cust_item_terms
1285: where customer_id in
1286: (select m.duplicate_id
1287: from ra_customer_merges m
1288: where m.process_flag = 'N'
1289: and m.request_id = req_id
1290: and m.set_number = set_num)
1291: OR address_id in

Line 1293: from ra_customer_merges m

1289: and m.request_id = req_id
1290: and m.set_number = set_num)
1291: OR address_id in
1292: (select m.duplicate_address_id
1293: from ra_customer_merges m
1294: where m.process_flag = 'N'
1295: and m.request_id = req_id
1296: and m.set_number = set_num)
1297: FOR update nowait;

Line 1876: FROM RLM_CUST_ITEM_CUM_KEYS yt, ra_customer_merges m

1872: ,SHIP_TO_ADDRESS_ID
1873: ,BILL_TO_ADDRESS_ID
1874: ,CUM_NOTE_TEXT
1875: ,INACTIVE_FLAG
1876: FROM RLM_CUST_ITEM_CUM_KEYS yt, ra_customer_merges m
1877: WHERE (
1878: yt.INTRMD_SHIP_TO_ID = m.DUPLICATE_ADDRESS_ID
1879: OR yt.SHIP_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
1880: OR yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID

Line 2030: FROM RLM_INTERFACE_HEADERS yt, ra_customer_merges m

2026: ,yt.CUSTOMER_ID
2027: ,ECE_PRIMARY_ADDRESS_ID
2028: ,CUST_NAME_EXT
2029: ,HEADER_NOTE_TEXT
2030: FROM RLM_INTERFACE_HEADERS yt, ra_customer_merges m
2031: WHERE (
2032: yt.CUSTOMER_ID = m.DUPLICATE_ID
2033: OR yt.ECE_PRIMARY_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
2034: ) AND m.process_flag = 'N'

Line 2068: from ra_customer_merges

2064: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2065: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2066:
2067: select distinct customer_name into cust_name
2068: from ra_customer_merges
2069: where customer_id = NUM_COL1_NEW_LIST(I)
2070: and request_id = req_id;
2071:
2072: VCHAR_COL1_NEW_LIST(I) := cust_name;

Line 2198: FROM RLM_INTERFACE_LINES yt, ra_customer_merges m

2194: ,SHIP_TO_ORG_ID
2195: ,INVOICE_TO_ORG_ID
2196: ,INTMED_SHIP_TO_ORG_ID
2197: ,ITEM_NOTE_TEXT
2198: FROM RLM_INTERFACE_LINES yt, ra_customer_merges m
2199: WHERE (
2200: yt.INTRMD_SHIP_TO_ID = m.DUPLICATE_ADDRESS_ID
2201: OR yt.SHIP_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
2202: OR yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID

Line 2369: FROM RLM_SCHEDULE_HEADERS yt, ra_customer_merges m

2365: ,yt.CUSTOMER_ID
2366: ,ECE_PRIMARY_ADDRESS_ID
2367: ,CUST_NAME_EXT
2368: ,HEADER_NOTE_TEXT
2369: FROM RLM_SCHEDULE_HEADERS yt, ra_customer_merges m
2370: WHERE (
2371: yt.CUSTOMER_ID = m.DUPLICATE_ID
2372: OR yt.ECE_PRIMARY_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
2373: ) AND m.process_flag = 'N'

Line 2407: from ra_customer_merges

2403: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
2404: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
2405:
2406: select distinct customer_name into cust_name
2407: from ra_customer_merges
2408: where customer_id = NUM_COL1_NEW_LIST(I)
2409: and request_id = req_id;
2410:
2411: VCHAR_COL1_NEW_LIST(I) := cust_name;

Line 2538: FROM RLM_SCHEDULE_LINES yt, ra_customer_merges m

2534: ,SHIP_TO_ORG_ID
2535: ,INVOICE_TO_ORG_ID
2536: ,INTMED_SHIP_TO_ORG_ID
2537: ,ITEM_NOTE_TEXT
2538: FROM RLM_SCHEDULE_LINES yt, ra_customer_merges m
2539: WHERE (
2540: yt.INTRMD_SHIP_TO_ID = m.DUPLICATE_ADDRESS_ID
2541: OR yt.SHIP_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID
2542: OR yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID