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 HZ_CUSTOMER_MERGE_LOG

Line 101: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

97: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
98: END LOOP;
99: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
100: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
101: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
102: MERGE_LOG_ID,
103: TABLE_NAME,
104: MERGE_HEADER_ID,
105: PRIMARY_KEY_ID1,

Line 119: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

115: CREATION_DATE,
116: LAST_UPDATE_LOGIN,
117: LAST_UPDATE_DATE,
118: LAST_UPDATED_BY
119: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
120: 'ozf_account_allocations',
121: MERGE_HEADER_ID_LIST(I),
122: PRIMARY_KEY_ID1_LIST(I),
123: NUM_COL1_ORIG_LIST(I),

Line 245: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

241: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
242: END LOOP;
243: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
244: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
245: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
246: MERGE_LOG_ID,
247: TABLE_NAME,
248: MERGE_HEADER_ID,
249: PRIMARY_KEY_ID1,

Line 261: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

257: CREATION_DATE,
258: LAST_UPDATE_LOGIN,
259: LAST_UPDATE_DATE,
260: LAST_UPDATED_BY
261: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
262: 'ozf_claim_lines',
263: MERGE_HEADER_ID_LIST(I),
264: PRIMARY_KEY_ID1_LIST(I),
265: NUM_COL1_ORIG_LIST(I),

Line 389: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

385: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
386: END LOOP;
387: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
388: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
389: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
390: MERGE_LOG_ID,
391: TABLE_NAME,
392: MERGE_HEADER_ID,
393: PRIMARY_KEY_ID1,

Line 405: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

401: CREATION_DATE,
402: LAST_UPDATE_LOGIN,
403: LAST_UPDATE_DATE,
404: LAST_UPDATED_BY
405: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
406: 'ozf_claim_lines_hist',
407: MERGE_HEADER_ID_LIST(I),
408: PRIMARY_KEY_ID1_LIST(I),
409: NUM_COL1_ORIG_LIST(I),

Line 573: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

569: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
570: END LOOP;
571: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
572: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
573: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
574: MERGE_LOG_ID,
575: TABLE_NAME,
576: MERGE_HEADER_ID,
577: PRIMARY_KEY_ID1,

Line 597: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

593: CREATION_DATE,
594: LAST_UPDATE_LOGIN,
595: LAST_UPDATE_DATE,
596: LAST_UPDATED_BY
597: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
598: 'ozf_claims',
599: MERGE_HEADER_ID_LIST(I),
600: PRIMARY_KEY_ID1_LIST(I),
601: NUM_COL1_ORIG_LIST(I),

Line 777: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

773: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
774: END LOOP;
775: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
776: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
777: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
778: MERGE_LOG_ID,
779: TABLE_NAME,
780: MERGE_HEADER_ID,
781: PRIMARY_KEY_ID1,

Line 801: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

797: CREATION_DATE,
798: LAST_UPDATE_LOGIN,
799: LAST_UPDATE_DATE,
800: LAST_UPDATED_BY
801: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
802: 'ozf_claims_history',
803: MERGE_HEADER_ID_LIST(I),
804: PRIMARY_KEY_ID1_LIST(I),
805: NUM_COL1_ORIG_LIST(I),

Line 931: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

927: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
928: END LOOP;
929: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
930: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
931: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
932: MERGE_LOG_ID,
933: TABLE_NAME,
934: MERGE_HEADER_ID,
935: PRIMARY_KEY_ID1,

Line 945: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

941: CREATION_DATE,
942: LAST_UPDATE_LOGIN,
943: LAST_UPDATE_DATE,
944: LAST_UPDATED_BY
945: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
946: 'ozf_code_conversions',
947: MERGE_HEADER_ID_LIST(I),
948: PRIMARY_KEY_ID1_LIST(I),
949: NUM_COL1_ORIG_LIST(I),

Line 1076: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1072: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1073: END LOOP;
1074: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1075: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1076: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1077: MERGE_LOG_ID,
1078: TABLE_NAME,
1079: MERGE_HEADER_ID,
1080: PRIMARY_KEY_ID1,

Line 1094: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

1090: CREATION_DATE,
1091: LAST_UPDATE_LOGIN,
1092: LAST_UPDATE_DATE,
1093: LAST_UPDATED_BY
1094: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1095: 'ozf_cust_daily_facts',
1096: MERGE_HEADER_ID_LIST(I),
1097: PRIMARY_KEY_ID1_LIST(I),
1098: NUM_COL1_ORIG_LIST(I),

Line 1220: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1216: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
1217: END LOOP;
1218: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1219: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1220: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1221: MERGE_LOG_ID,
1222: TABLE_NAME,
1223: MERGE_HEADER_ID,
1224: PRIMARY_KEY_ID1,

Line 1236: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

1232: CREATION_DATE,
1233: LAST_UPDATE_LOGIN,
1234: LAST_UPDATE_DATE,
1235: LAST_UPDATED_BY
1236: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1237: 'ozf_funds_utilized_all_b',
1238: MERGE_HEADER_ID_LIST(I),
1239: PRIMARY_KEY_ID1_LIST(I),
1240: NUM_COL1_ORIG_LIST(I),

Line 1372: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1368: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1369: END LOOP;
1370: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1371: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1372: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1373: MERGE_LOG_ID,
1374: TABLE_NAME,
1375: MERGE_HEADER_ID,
1376: PRIMARY_KEY1,

Line 1389: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

1385: CREATION_DATE,
1386: LAST_UPDATE_LOGIN,
1387: LAST_UPDATE_DATE,
1388: LAST_UPDATED_BY
1389: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1390: 'ozf_activity_customers',
1391: MERGE_HEADER_ID_LIST(I),
1392: PRIMARY_KEY1_LIST(I),
1393: PRIMARY_KEY2_LIST(I),

Line 1506: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1502:
1503: END LOOP;
1504: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1505: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1506: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1507: MERGE_LOG_ID,
1508: TABLE_NAME,
1509: MERGE_HEADER_ID,
1510: PRIMARY_KEY_ID1,

Line 1520: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

1516: CREATION_DATE,
1517: LAST_UPDATE_LOGIN,
1518: LAST_UPDATE_DATE,
1519: LAST_UPDATED_BY
1520: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1521: 'ozf_offers',
1522: MERGE_HEADER_ID_LIST(I),
1523: PRIMARY_KEY_ID1_LIST(I),
1524: NUM_COL1_ORIG_LIST(I),

Line 1651: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1647: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1648: END LOOP;
1649: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1650: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1651: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1652: MERGE_LOG_ID,
1653: TABLE_NAME,
1654: MERGE_HEADER_ID,
1655: PRIMARY_KEY_ID1,

Line 1669: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

1665: CREATION_DATE,
1666: LAST_UPDATE_LOGIN,
1667: LAST_UPDATE_DATE,
1668: LAST_UPDATED_BY
1669: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1670: 'ozf_request_headers_all_b',
1671: MERGE_HEADER_ID_LIST(I),
1672: PRIMARY_KEY_ID1_LIST(I),
1673: NUM_COL1_ORIG_LIST(I),

Line 1801: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1797: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1798: END LOOP;
1799: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1800: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1801: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1802: MERGE_LOG_ID,
1803: TABLE_NAME,
1804: MERGE_HEADER_ID,
1805: PRIMARY_KEY_ID1,

Line 1817: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

1813: CREATION_DATE,
1814: LAST_UPDATE_LOGIN,
1815: LAST_UPDATE_DATE,
1816: LAST_UPDATED_BY
1817: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1818: 'ozf_retail_price_points',
1819: MERGE_HEADER_ID_LIST(I),
1820: PRIMARY_KEY_ID1_LIST(I),
1821: NUM_COL1_ORIG_LIST(I),

Line 1941: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1937: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1938: END LOOP;
1939: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1940: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1941: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1942: MERGE_LOG_ID,
1943: TABLE_NAME,
1944: MERGE_HEADER_ID,
1945: PRIMARY_KEY_ID1,

Line 1957: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,

1953: CREATION_DATE,
1954: LAST_UPDATE_LOGIN,
1955: LAST_UPDATE_DATE,
1956: LAST_UPDATED_BY
1957: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1958: 'ozf_cust_trd_prfls',
1959: MERGE_HEADER_ID_LIST(I),
1960: PRIMARY_KEY_ID1_LIST(I),
1961: NUM_COL1_ORIG_LIST(I),