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.

[Home] [Help]

APPS.RLM_CUST_MERGE dependencies on HZ_CUSTOMER_MERGE_LOG

Line 942: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

938: FOR cust_shipto_terms in cust_shipto_terms_cur
939: --
940: LOOP
941:
942: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
943: MERGE_LOG_ID,
944: TABLE_NAME,
945: MERGE_HEADER_ID,
946: DEL_COL1,

Line 1073: ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

1069: LAST_UPDATE_LOGIN,
1070: LAST_UPDATE_DATE,
1071: LAST_UPDATED_BY)
1072: Values
1073: ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1074: 'RLM_CUST_SHIPTO_TERMS',
1075: MERGE_HEADER_ID_LIST(I),
1076: cust_shipto_terms.CUST_SHIPTO_TERMS_ID,
1077: cust_shipto_terms.ADDRESS_ID,

Line 1350: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1346: FOR cust_item_terms in cust_item_terms_cur
1347: --
1348: LOOP
1349:
1350: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1351: MERGE_LOG_ID,
1352: TABLE_NAME,
1353: MERGE_HEADER_ID,
1354: DEL_COL1,

Line 1468: ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

1464: LAST_UPDATE_LOGIN,
1465: LAST_UPDATE_DATE,
1466: LAST_UPDATED_BY)
1467: Values
1468: ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1469: 'RLM_CUST_ITEM_TERMS',
1470: MERGE_HEADER_ID_LIST(I),
1471: cust_item_terms.CUST_ITEM_TERMS_ID,
1472: cust_item_terms.CUSTOMER_ITEM_ID,

Line 1924: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1920: VCHAR_COL2_NEW_LIST(I) := VCHAR_COL2_ORIG_LIST(I);
1921: END LOOP;
1922: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1923: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1924: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1925: MERGE_LOG_ID,
1926: TABLE_NAME,
1927: MERGE_HEADER_ID,
1928: PRIMARY_KEY_ID,

Line 1946: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

1942: CREATION_DATE,
1943: LAST_UPDATE_LOGIN,
1944: LAST_UPDATE_DATE,
1945: LAST_UPDATED_BY
1946: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1947: 'RLM_CUST_ITEM_CUM_KEYS',
1948: MERGE_HEADER_ID_LIST(I),
1949: PRIMARY_KEY_ID_LIST(I),
1950: NUM_COL1_ORIG_LIST(I),

Line 2077: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2073: VCHAR_COL2_NEW_LIST(I) := VCHAR_COL2_ORIG_LIST(I);
2074: END LOOP;
2075: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2076: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2077: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2078: MERGE_LOG_ID,
2079: TABLE_NAME,
2080: MERGE_HEADER_ID,
2081: PRIMARY_KEY_ID,

Line 2097: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

2093: CREATION_DATE,
2094: LAST_UPDATE_LOGIN,
2095: LAST_UPDATE_DATE,
2096: LAST_UPDATED_BY
2097: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
2098: 'RLM_INTERFACE_HEADERS',
2099: MERGE_HEADER_ID_LIST(I),
2100: PRIMARY_KEY_ID_LIST(I),
2101: NUM_COL1_ORIG_LIST(I),

Line 2255: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2251: VCHAR_COL1_NEW_LIST(I) := VCHAR_COL1_ORIG_LIST(I);
2252: END LOOP;
2253: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2254: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2255: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2256: MERGE_LOG_ID,
2257: TABLE_NAME,
2258: MERGE_HEADER_ID,
2259: PRIMARY_KEY_ID,

Line 2281: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

2277: CREATION_DATE,
2278: LAST_UPDATE_LOGIN,
2279: LAST_UPDATE_DATE,
2280: LAST_UPDATED_BY
2281: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
2282: 'RLM_INTERFACE_LINES',
2283: MERGE_HEADER_ID_LIST(I),
2284: PRIMARY_KEY_ID_LIST(I),
2285: NUM_COL1_ORIG_LIST(I),

Line 2416: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2412: VCHAR_COL2_NEW_LIST(I) := VCHAR_COL2_ORIG_LIST(I);
2413: END LOOP;
2414: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2415: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2416: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2417: MERGE_LOG_ID,
2418: TABLE_NAME,
2419: MERGE_HEADER_ID,
2420: PRIMARY_KEY_ID,

Line 2436: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

2432: CREATION_DATE,
2433: LAST_UPDATE_LOGIN,
2434: LAST_UPDATE_DATE,
2435: LAST_UPDATED_BY
2436: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
2437: 'RLM_SCHEDULE_HEADERS',
2438: MERGE_HEADER_ID_LIST(I),
2439: PRIMARY_KEY_ID_LIST(I),
2440: NUM_COL1_ORIG_LIST(I),

Line 2595: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2591: VCHAR_COL1_NEW_LIST(I) := VCHAR_COL1_ORIG_LIST(I);
2592: END LOOP;
2593: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2594: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2595: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2596: MERGE_LOG_ID,
2597: TABLE_NAME,
2598: MERGE_HEADER_ID,
2599: PRIMARY_KEY_ID,

Line 2621: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

2617: CREATION_DATE,
2618: LAST_UPDATE_LOGIN,
2619: LAST_UPDATE_DATE,
2620: LAST_UPDATED_BY
2621: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
2622: 'RLM_SCHEDULE_LINES',
2623: MERGE_HEADER_ID_LIST(I),
2624: PRIMARY_KEY_ID_LIST(I),
2625: NUM_COL1_ORIG_LIST(I),