DBA Data[Home] [Help]

APPS.OKC_HZ_MERGE_PUB dependencies on HZ_CUSTOMER_MERGE_LOG_S

Line 487: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

483: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
484: MERGE_LOG_ID,
485: TABLE_NAME,
486: PRIMARY_KEY_ID1
487: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
488: 'OKC_K_PARTY_ROLES_B',
489: l_log_party_id
490: FROM DUAL;
491:

Line 600: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

596: CREATION_DATE,
597: LAST_UPDATE_LOGIN,
598: LAST_UPDATE_DATE,
599: LAST_UPDATED_BY
600: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
601: 'OKC_K_PARTY_ROLES_B',
602: CUSTOMER_MERGE_HEADER_ID,
603: kpr.ID,
604: kpr.object1_id1,

Line 676: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

672: CREATION_DATE,
673: LAST_UPDATE_LOGIN,
674: LAST_UPDATE_DATE,
675: LAST_UPDATED_BY
676: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
677: 'OKC_RULES_B',
678: CUSTOMER_MERGE_HEADER_ID,
679: rle.ID,
680: rle.object1_id1,

Line 753: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

749: CREATION_DATE,
750: LAST_UPDATE_LOGIN,
751: LAST_UPDATE_DATE,
752: LAST_UPDATED_BY
753: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
754: 'OKC_RULES_B',
755: CUSTOMER_MERGE_HEADER_ID,
756: rle.ID,
757: rle.object2_id1,

Line 830: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

826: CREATION_DATE,
827: LAST_UPDATE_LOGIN,
828: LAST_UPDATE_DATE,
829: LAST_UPDATED_BY
830: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
831: 'OKC_RULES_B',
832: CUSTOMER_MERGE_HEADER_ID,
833: rle.ID,
834: rle.object3_id1,

Line 908: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

904: CREATION_DATE,
905: LAST_UPDATE_LOGIN,
906: LAST_UPDATE_DATE,
907: LAST_UPDATED_BY
908: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
909: 'OKC_K_HEADERS_B',
910: CUSTOMER_MERGE_HEADER_ID,
911: okh.ID,
912: to_char(okh.cust_acct_id),

Line 979: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

975: CREATION_DATE,
976: LAST_UPDATE_LOGIN,
977: LAST_UPDATE_DATE,
978: LAST_UPDATED_BY
979: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
980: 'OKC_K_LINES_B',
981: CUSTOMER_MERGE_HEADER_ID,
982: okl.ID,
983: to_char(okl.cust_acct_id),

Line 1048: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1044: CREATION_DATE,
1045: LAST_UPDATE_LOGIN,
1046: LAST_UPDATE_DATE,
1047: LAST_UPDATED_BY
1048: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1049: 'OKC_K_PARTY_ROLES_B',
1050: CUSTOMER_MERGE_HEADER_ID,
1051: okpr.ID,
1052: to_char(okpr.cust_acct_id),

Line 1118: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1114: CREATION_DATE,
1115: LAST_UPDATE_LOGIN,
1116: LAST_UPDATE_DATE,
1117: LAST_UPDATED_BY
1118: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1119: 'OKC_K_ITEMS',
1120: CUSTOMER_MERGE_HEADER_ID,
1121: cim.ID,
1122: cim.object1_id1,

Line 1217: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1213: CREATION_DATE,
1214: LAST_UPDATE_LOGIN,
1215: LAST_UPDATE_DATE,
1216: LAST_UPDATED_BY
1217: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1218: 'OKC_RULES_B',
1219: CUSTOMER_MERGE_HEADER_ID,
1220: rle.ID,
1221: rle.object1_id1,

Line 1295: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1291: CREATION_DATE,
1292: LAST_UPDATE_LOGIN,
1293: LAST_UPDATE_DATE,
1294: LAST_UPDATED_BY
1295: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1296: 'OKC_RULES_B',
1297: CUSTOMER_MERGE_HEADER_ID,
1298: rle.ID,
1299: rle.object2_id1,

Line 1372: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1368: CREATION_DATE,
1369: LAST_UPDATE_LOGIN,
1370: LAST_UPDATE_DATE,
1371: LAST_UPDATED_BY
1372: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1373: 'OKC_RULES_B',
1374: CUSTOMER_MERGE_HEADER_ID,
1375: rle.ID,
1376: rle.object3_id1,

Line 1452: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1448: CREATION_DATE,
1449: LAST_UPDATE_LOGIN,
1450: LAST_UPDATE_DATE,
1451: LAST_UPDATED_BY
1452: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1453: 'OKC_K_ITEMS',
1454: CUSTOMER_MERGE_HEADER_ID,
1455: cim.ID,
1456: cim.object1_id1,

Line 1539: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1535: CREATION_DATE,
1536: LAST_UPDATE_LOGIN,
1537: LAST_UPDATE_DATE,
1538: LAST_UPDATED_BY
1539: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1540: 'OKC_K_PARTY_ROLES_B',
1541: CUSTOMER_MERGE_HEADER_ID,
1542: rle.ID,
1543: rle.object1_id1,

Line 1632: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1628: CREATION_DATE,
1629: LAST_UPDATE_LOGIN,
1630: LAST_UPDATE_DATE,
1631: LAST_UPDATED_BY
1632: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1633: 'OKC_RULES_B',
1634: CUSTOMER_MERGE_HEADER_ID,
1635: rle.ID,
1636: rle.object1_id1,

Line 1708: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1704: CREATION_DATE,
1705: LAST_UPDATE_LOGIN,
1706: LAST_UPDATE_DATE,
1707: LAST_UPDATED_BY
1708: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1709: 'OKC_RULES_B',
1710: CUSTOMER_MERGE_HEADER_ID,
1711: rle.ID,
1712: rle.object2_id1,

Line 1785: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1781: CREATION_DATE,
1782: LAST_UPDATE_LOGIN,
1783: LAST_UPDATE_DATE,
1784: LAST_UPDATED_BY
1785: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1786: 'OKC_RULES_B',
1787: CUSTOMER_MERGE_HEADER_ID,
1788: rle.ID,
1789: rle.object3_id1,

Line 1863: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1859: CREATION_DATE,
1860: LAST_UPDATE_LOGIN,
1861: LAST_UPDATE_DATE,
1862: LAST_UPDATED_BY
1863: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1864: 'OKC_K_HEADERS_B',
1865: CUSTOMER_MERGE_HEADER_ID,
1866: okh.ID,
1867: to_char(okh.ship_to_site_use_id),

Line 1932: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1928: CREATION_DATE,
1929: LAST_UPDATE_LOGIN,
1930: LAST_UPDATE_DATE,
1931: LAST_UPDATED_BY
1932: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1933: 'OKC_K_HEADERS_B',
1934: CUSTOMER_MERGE_HEADER_ID,
1935: okh.ID,
1936: to_char(okh.bill_to_site_use_id),

Line 2000: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1996: CREATION_DATE,
1997: LAST_UPDATE_LOGIN,
1998: LAST_UPDATE_DATE,
1999: LAST_UPDATED_BY
2000: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2001: 'OKC_K_LINES_B',
2002: CUSTOMER_MERGE_HEADER_ID,
2003: okl.ID,
2004: to_char(okl.ship_to_site_use_id),

Line 2069: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2065: CREATION_DATE,
2066: LAST_UPDATE_LOGIN,
2067: LAST_UPDATE_DATE,
2068: LAST_UPDATED_BY
2069: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2070: 'OKC_K_LINES_B',
2071: CUSTOMER_MERGE_HEADER_ID,
2072: okl.ID,
2073: to_char(okl.bill_to_site_use_id),

Line 2138: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2134: CREATION_DATE,
2135: LAST_UPDATE_LOGIN,
2136: LAST_UPDATE_DATE,
2137: LAST_UPDATED_BY
2138: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2139: 'OKC_K_PARTY_ROLES_B',
2140: CUSTOMER_MERGE_HEADER_ID,
2141: okpr.ID,
2142: to_char(okpr.bill_to_site_use_id),

Line 2209: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2205: CREATION_DATE,
2206: LAST_UPDATE_LOGIN,
2207: LAST_UPDATE_DATE,
2208: LAST_UPDATED_BY
2209: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2210: 'OKC_K_ITEMS',
2211: CUSTOMER_MERGE_HEADER_ID,
2212: cim.ID,
2213: cim.object1_id1,