DBA Data[Home] [Help]

APPS.OKC_HZ_MERGE_PUB dependencies on HZ_CUSTOMER_MERGE_LOG_S

Line 494: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

490: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
491: MERGE_LOG_ID,
492: TABLE_NAME,
493: PRIMARY_KEY_ID1
494: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
495: 'OKC_K_PARTY_ROLES_B',
496: l_log_party_id
497: FROM DUAL;
498:

Line 621: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

617: CREATION_DATE,
618: LAST_UPDATE_LOGIN,
619: LAST_UPDATE_DATE,
620: LAST_UPDATED_BY
621: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
622: 'OKC_K_PARTY_ROLES_B',
623: CUSTOMER_MERGE_HEADER_ID,
624: kpr.ID,
625: kpr.object1_id1,

Line 698: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

694: CREATION_DATE,
695: LAST_UPDATE_LOGIN,
696: LAST_UPDATE_DATE,
697: LAST_UPDATED_BY
698: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
699: 'OKC_RULES_B',
700: CUSTOMER_MERGE_HEADER_ID,
701: rle.ID,
702: rle.object1_id1,

Line 775: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

771: CREATION_DATE,
772: LAST_UPDATE_LOGIN,
773: LAST_UPDATE_DATE,
774: LAST_UPDATED_BY
775: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
776: 'OKC_RULES_B',
777: CUSTOMER_MERGE_HEADER_ID,
778: rle.ID,
779: rle.object2_id1,

Line 852: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

848: CREATION_DATE,
849: LAST_UPDATE_LOGIN,
850: LAST_UPDATE_DATE,
851: LAST_UPDATED_BY
852: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
853: 'OKC_RULES_B',
854: CUSTOMER_MERGE_HEADER_ID,
855: rle.ID,
856: rle.object3_id1,

Line 930: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

926: CREATION_DATE,
927: LAST_UPDATE_LOGIN,
928: LAST_UPDATE_DATE,
929: LAST_UPDATED_BY
930: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
931: 'OKC_K_HEADERS_B',
932: CUSTOMER_MERGE_HEADER_ID,
933: okh.ID,
934: to_char(okh.cust_acct_id),

Line 1002: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

998: CREATION_DATE,
999: LAST_UPDATE_LOGIN,
1000: LAST_UPDATE_DATE,
1001: LAST_UPDATED_BY
1002: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1003: 'OKC_K_LINES_B',
1004: CUSTOMER_MERGE_HEADER_ID,
1005: okl.ID,
1006: to_char(okl.cust_acct_id),

Line 1080: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1076: CREATION_DATE,
1077: LAST_UPDATE_LOGIN,
1078: LAST_UPDATE_DATE,
1079: LAST_UPDATED_BY
1080: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1081: 'OKC_K_PARTY_ROLES_B',
1082: CUSTOMER_MERGE_HEADER_ID,
1083: okpr.ID,
1084: to_char(okpr.cust_acct_id),

Line 1151: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1147: CREATION_DATE,
1148: LAST_UPDATE_LOGIN,
1149: LAST_UPDATE_DATE,
1150: LAST_UPDATED_BY
1151: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1152: 'OKC_K_ITEMS',
1153: CUSTOMER_MERGE_HEADER_ID,
1154: cim.ID,
1155: cim.object1_id1,

Line 1314: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1310: CREATION_DATE,
1311: LAST_UPDATE_LOGIN,
1312: LAST_UPDATE_DATE,
1313: LAST_UPDATED_BY
1314: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1315: 'OKC_RULES_B',
1316: CUSTOMER_MERGE_HEADER_ID,
1317: rle.ID,
1318: rle.object1_id1,

Line 1392: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1388: CREATION_DATE,
1389: LAST_UPDATE_LOGIN,
1390: LAST_UPDATE_DATE,
1391: LAST_UPDATED_BY
1392: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1393: 'OKC_RULES_B',
1394: CUSTOMER_MERGE_HEADER_ID,
1395: rle.ID,
1396: rle.object2_id1,

Line 1469: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1465: CREATION_DATE,
1466: LAST_UPDATE_LOGIN,
1467: LAST_UPDATE_DATE,
1468: LAST_UPDATED_BY
1469: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1470: 'OKC_RULES_B',
1471: CUSTOMER_MERGE_HEADER_ID,
1472: rle.ID,
1473: rle.object3_id1,

Line 1549: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1545: CREATION_DATE,
1546: LAST_UPDATE_LOGIN,
1547: LAST_UPDATE_DATE,
1548: LAST_UPDATED_BY
1549: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1550: 'OKC_K_ITEMS',
1551: CUSTOMER_MERGE_HEADER_ID,
1552: cim.ID,
1553: cim.object1_id1,

Line 1636: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1632: CREATION_DATE,
1633: LAST_UPDATE_LOGIN,
1634: LAST_UPDATE_DATE,
1635: LAST_UPDATED_BY
1636: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1637: 'OKC_K_PARTY_ROLES_B',
1638: CUSTOMER_MERGE_HEADER_ID,
1639: rle.ID,
1640: rle.object1_id1,

Line 1729: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1725: CREATION_DATE,
1726: LAST_UPDATE_LOGIN,
1727: LAST_UPDATE_DATE,
1728: LAST_UPDATED_BY
1729: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1730: 'OKC_RULES_B',
1731: CUSTOMER_MERGE_HEADER_ID,
1732: rle.ID,
1733: rle.object1_id1,

Line 1805: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1801: CREATION_DATE,
1802: LAST_UPDATE_LOGIN,
1803: LAST_UPDATE_DATE,
1804: LAST_UPDATED_BY
1805: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1806: 'OKC_RULES_B',
1807: CUSTOMER_MERGE_HEADER_ID,
1808: rle.ID,
1809: rle.object2_id1,

Line 1882: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1878: CREATION_DATE,
1879: LAST_UPDATE_LOGIN,
1880: LAST_UPDATE_DATE,
1881: LAST_UPDATED_BY
1882: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1883: 'OKC_RULES_B',
1884: CUSTOMER_MERGE_HEADER_ID,
1885: rle.ID,
1886: rle.object3_id1,

Line 1960: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1956: CREATION_DATE,
1957: LAST_UPDATE_LOGIN,
1958: LAST_UPDATE_DATE,
1959: LAST_UPDATED_BY
1960: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1961: 'OKC_K_HEADERS_B',
1962: CUSTOMER_MERGE_HEADER_ID,
1963: okh.ID,
1964: to_char(okh.ship_to_site_use_id),

Line 2030: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2026: CREATION_DATE,
2027: LAST_UPDATE_LOGIN,
2028: LAST_UPDATE_DATE,
2029: LAST_UPDATED_BY
2030: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2031: 'OKC_K_HEADERS_B',
2032: CUSTOMER_MERGE_HEADER_ID,
2033: okh.ID,
2034: to_char(okh.bill_to_site_use_id),

Line 2099: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2095: CREATION_DATE,
2096: LAST_UPDATE_LOGIN,
2097: LAST_UPDATE_DATE,
2098: LAST_UPDATED_BY
2099: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2100: 'OKC_K_LINES_B',
2101: CUSTOMER_MERGE_HEADER_ID,
2102: okl.ID,
2103: to_char(okl.ship_to_site_use_id),

Line 2177: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2173: CREATION_DATE,
2174: LAST_UPDATE_LOGIN,
2175: LAST_UPDATE_DATE,
2176: LAST_UPDATED_BY
2177: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2178: 'OKC_K_LINES_B',
2179: CUSTOMER_MERGE_HEADER_ID,
2180: okl.ID,
2181: to_char(okl.bill_to_site_use_id),

Line 2247: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2243: CREATION_DATE,
2244: LAST_UPDATE_LOGIN,
2245: LAST_UPDATE_DATE,
2246: LAST_UPDATED_BY
2247: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2248: 'OKC_K_PARTY_ROLES_B',
2249: CUSTOMER_MERGE_HEADER_ID,
2250: okpr.ID,
2251: to_char(okpr.bill_to_site_use_id),

Line 2319: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2315: CREATION_DATE,
2316: LAST_UPDATE_LOGIN,
2317: LAST_UPDATE_DATE,
2318: LAST_UPDATED_BY
2319: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2320: 'OKC_K_ITEMS',
2321: CUSTOMER_MERGE_HEADER_ID,
2322: cim.ID,
2323: cim.object1_id1,