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.OE_CUST_MERGE dependencies on HZ_CUSTOMER_MERGE_LOG_S

Line 343: HZ_CUSTOMER_MERGE_LOG_s.nextval,

339: LAST_UPDATE_LOGIN,
340: LAST_UPDATE_DATE,
341: LAST_UPDATED_BY
342: ) VALUES (
343: HZ_CUSTOMER_MERGE_LOG_s.nextval,
344: 'OE_ORDER_HEADERS_ALL',
345: MERGE_HEADER_ID_LIST(I),
346: hdr_header_id_tab(I),
347: old_hdr_sold_to_org_id_tab(I),

Line 1440: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1436: LAST_UPDATE_DATE,
1437: LAST_UPDATED_BY
1438: )
1439: select
1440: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1441: 'OE_HEADER_ACKS',
1442: m.CUSTOMER_MERGE_HEADER_ID,
1443: h.ORIG_SYS_DOCUMENT_REF,
1444: h.ship_to_org_id,

Line 1507: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1503: LAST_UPDATE_DATE,
1504: LAST_UPDATED_BY
1505: )
1506: select
1507: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1508: 'OE_HEADERS_ACKS',
1509: m.CUSTOMER_MERGE_HEADER_ID,
1510: h.ORIG_SYS_DOCUMENT_REF,
1511: h.invoice_to_org_id,

Line 1576: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1572: LAST_UPDATE_DATE,
1573: LAST_UPDATED_BY
1574: )
1575: select
1576: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1577: 'OE_HEADER_ACKS',
1578: m.CUSTOMER_MERGE_HEADER_ID,
1579: h.ORIG_SYS_DOCUMENT_REF,
1580: h.deliver_to_org_id,

Line 1647: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1643: LAST_UPDATE_DATE,
1644: LAST_UPDATED_BY
1645: )
1646: select
1647: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1648: 'OE_HEADER_ACKS',
1649: m.CUSTOMER_MERGE_HEADER_ID,
1650: h.ORIG_SYS_DOCUMENT_REF,
1651: h.sold_to_org_id,

Line 1719: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1715: LAST_UPDATE_DATE,
1716: LAST_UPDATED_BY
1717: )
1718: select
1719: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1720: 'OE_HEADER_ACKS',
1721: m.CUSTOMER_MERGE_HEADER_ID,
1722: h.ORIG_SYS_DOCUMENT_REF,
1723: h.sold_to_site_use_id,

Line 1792: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1788: LAST_UPDATE_DATE,
1789: LAST_UPDATED_BY
1790: )
1791: select
1792: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1793: 'OE_HEADER_ACKS',
1794: m.CUSTOMER_MERGE_HEADER_ID,
1795: h.ORIG_SYS_DOCUMENT_REF,
1796: h.end_customer_site_use_id,

Line 1865: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1861: LAST_UPDATE_DATE,
1862: LAST_UPDATED_BY
1863: )
1864: select
1865: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1866: 'OE_HEADER_ACKS',
1867: m.CUSTOMER_MERGE_HEADER_ID,
1868: h.ORIG_SYS_DOCUMENT_REF,
1869: h.end_customer_id,

Line 2308: HZ_CUSTOMER_MERGE_LOG_s.nextval,

2304: LAST_UPDATE_LOGIN,
2305: LAST_UPDATE_DATE,
2306: LAST_UPDATED_BY
2307: ) VALUES (
2308: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2309: 'OE_ORDER_LINES_ALL',
2310: MERGE_HEADER_ID_LIST(I),
2311: line_line_id_tab(I),
2312: line_sold_to_org_id_tab(I),

Line 3069: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3065: LAST_UPDATE_DATE,
3066: LAST_UPDATED_BY
3067: )
3068: select
3069: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3070: 'OE_LINE_ACKS',
3071: m.CUSTOMER_MERGE_HEADER_ID,
3072: a.ORIG_SYS_DOCUMENT_REF,
3073: a.ORIG_SYS_LINE_REF,

Line 3138: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3134: LAST_UPDATE_DATE,
3135: LAST_UPDATED_BY
3136: )
3137: select
3138: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3139: 'OE_LINE_ACKS',
3140: m.CUSTOMER_MERGE_HEADER_ID,
3141: a.ORIG_SYS_DOCUMENT_REF,
3142: a.ORIG_SYS_LINE_REF,

Line 3206: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3202: LAST_UPDATE_DATE,
3203: LAST_UPDATED_BY
3204: )
3205: select
3206: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3207: 'OE_LINE_ACKS',
3208: m.CUSTOMER_MERGE_HEADER_ID,
3209: a.ORIG_SYS_DOCUMENT_REF,
3210: a.ORIG_SYS_LINE_REF,

Line 3274: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3270: LAST_UPDATE_DATE,
3271: LAST_UPDATED_BY
3272: )
3273: select
3274: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3275: 'OE_LINE_ACKS',
3276: m.CUSTOMER_MERGE_HEADER_ID,
3277: a.ORIG_SYS_DOCUMENT_REF,
3278: a.ORIG_SYS_LINE_REF,

Line 3348: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3344: LAST_UPDATE_DATE,
3345: LAST_UPDATED_BY
3346: )
3347: select
3348: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3349: 'OE_LINE_ACKS',
3350: m.CUSTOMER_MERGE_HEADER_ID,
3351: a.ORIG_SYS_DOCUMENT_REF,
3352: a.ORIG_SYS_LINE_REF,

Line 3425: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3421: LAST_UPDATE_DATE,
3422: LAST_UPDATED_BY
3423: )
3424: select
3425: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3426: 'OE_LINE_ACKS',
3427: m.CUSTOMER_MERGE_HEADER_ID,
3428: a.ORIG_SYS_DOCUMENT_REF,
3429: a.ORIG_SYS_LINE_REF,

Line 3500: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3496: LAST_UPDATE_DATE,
3497: LAST_UPDATED_BY
3498: )
3499: select
3500: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3501: 'OE_LINE_ACKS',
3502: m.CUSTOMER_MERGE_HEADER_ID,
3503: a.ORIG_SYS_DOCUMENT_REF,
3504: a.ORIG_SYS_LINE_REF,

Line 3699: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3695: LAST_UPDATE_DATE,
3696: LAST_UPDATED_BY
3697: )
3698: select
3699: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3700: 'OE_ATTACHMENT_RULE_ELEMENTS',
3701: m.customer_merge_header_id,
3702: a.rule_element_id,
3703: a.attribute_value,

Line 3767: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3763: LAST_UPDATE_DATE,
3764: LAST_UPDATED_BY
3765: )
3766: select
3767: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3768: 'OE_ATTACHMENT_RULE_ELEMENTS',
3769: m.customer_merge_header_id,
3770: a.rule_element_id,
3771: a.attribute_value,

Line 3836: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3832: LAST_UPDATE_DATE,
3833: LAST_UPDATED_BY
3834: )
3835: select
3836: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3837: 'OE_ATTACHMENT_RULE_ELEMENTS',
3838: m.customer_merge_header_id,
3839: a.rule_element_id,
3840: a.attribute_value,

Line 4056: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4052: LAST_UPDATE_DATE,
4053: LAST_UPDATED_BY
4054: )
4055: select
4056: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4057: 'OE_DEF_CONDN_ELEMS',
4058: m.customer_merge_header_id,
4059: a.condition_element_id,
4060: a.value_string,

Line 4123: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4119: LAST_UPDATE_DATE,
4120: LAST_UPDATED_BY
4121: )
4122: select
4123: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4124: 'OE_DEF_CONDN_ELEMS',
4125: m.customer_merge_header_id,
4126: a.condition_element_id,
4127: a.value_string,

Line 4192: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4188: LAST_UPDATE_DATE,
4189: LAST_UPDATED_BY
4190: )
4191: select
4192: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4193: 'OE_DEF_CONDN_ELEMS',
4194: m.customer_merge_header_id,
4195: a.condition_element_id,
4196: a.value_string,

Line 4260: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4256: LAST_UPDATE_DATE,
4257: LAST_UPDATED_BY
4258: )
4259: select
4260: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4261: 'OE_DEF_CONDN_ELEMS',
4262: m.customer_merge_header_id,
4263: a.condition_element_id,
4264: a.value_string,

Line 4330: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4326: LAST_UPDATE_DATE,
4327: LAST_UPDATED_BY
4328: )
4329: select
4330: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4331: 'OE_DEF_ATTR_DEF_RULES',
4332: m.customer_merge_header_id,
4333: a.attr_def_rule_id,
4334: a.src_constant_value,

Line 4400: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4396: LAST_UPDATE_DATE,
4397: LAST_UPDATED_BY
4398: )
4399: select
4400: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4401: 'OE_DEF_ATTR_DEF_RULES',
4402: m.customer_merge_header_id,
4403: a.attr_def_rule_id,
4404: a.src_constant_value,

Line 4468: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4464: LAST_UPDATE_DATE,
4465: LAST_UPDATED_BY
4466: )
4467: select
4468: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4469: 'OE_DEF_ATTR_DEF_RULES',
4470: m.customer_merge_header_id,
4471: a.attr_def_rule_id,
4472: a.src_constant_value,

Line 4537: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4533: LAST_UPDATE_DATE,
4534: LAST_UPDATED_BY
4535: )
4536: select
4537: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4538: 'OE_DEF_ATTR_DEF_RULES',
4539: m.customer_merge_header_id,
4540: a.attr_def_rule_id,
4541: a.src_constant_value,

Line 4705: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4701: LAST_UPDATE_DATE,
4702: LAST_UPDATED_BY
4703: )
4704: select
4705: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4706: 'OE_PC_VTMPLT_COLS',
4707: m.customer_merge_header_id,
4708: a.validation_tmplt_id,
4709: a.value_string,

Line 4773: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4769: LAST_UPDATE_DATE,
4770: LAST_UPDATED_BY
4771: )
4772: select
4773: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4774: 'OE_PC_VTMPLT_COLS',
4775: m.customer_merge_header_id,
4776: a.validation_tmplt_id,
4777: a.value_string,

Line 4841: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4837: LAST_UPDATE_DATE,
4838: LAST_UPDATED_BY
4839: )
4840: select
4841: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4842: 'OE_PC_VTMPLT_COLS',
4843: m.customer_merge_header_id,
4844: a.validation_tmplt_id,
4845: a.value_string,

Line 4910: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4906: LAST_UPDATE_DATE,
4907: LAST_UPDATED_BY
4908: )
4909: select
4910: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4911: 'OE_PC_VTMPLT_COLS',
4912: m.customer_merge_header_id,
4913: a.validation_tmplt_id,
4914: a.value_string,

Line 5062: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5058: LAST_UPDATE_DATE,
5059: LAST_UPDATED_BY
5060: )
5061: select
5062: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5063: 'OE_HOLD_SOURCES',
5064: m.customer_merge_header_id,
5065: a.hold_source_id,
5066: to_char(a.hold_entity_id),

Line 5130: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5126: LAST_UPDATE_DATE,
5127: LAST_UPDATED_BY
5128: )
5129: select
5130: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5131: 'OE_HOLD_SOURCES',
5132: m.customer_merge_header_id,
5133: a.hold_source_id,
5134: to_char(a.hold_entity_id),

Line 5199: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5195: LAST_UPDATE_DATE,
5196: LAST_UPDATED_BY
5197: )
5198: select
5199: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5200: 'OE_HOLD_SOURCES',
5201: m.customer_merge_header_id,
5202: a.hold_source_id,
5203: to_char(a.hold_entity_id),

Line 5313: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5309: LAST_UPDATE_DATE,
5310: LAST_UPDATED_BY
5311: )
5312: select
5313: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5314: 'OE_DROP_SHIP_SOURCES',
5315: m.customer_merge_header_id,
5316: a.drop_ship_source_id,
5317: to_char(a.line_location_id),

Line 5437: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5433: LAST_UPDATE_DATE,
5434: LAST_UPDATED_BY
5435: )
5436: select
5437: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5438: 'OE_CUST_ITEM_SETTINGS',
5439: m.customer_merge_header_id,
5440: a.cust_item_setting_id,
5441: a.site_use_id,

Line 5499: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5495: LAST_UPDATE_DATE,
5496: LAST_UPDATED_BY
5497: )
5498: select
5499: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5500: 'OE_CUST_ITEM_SETTINGS',
5501: m.customer_merge_header_id,
5502: a.cust_item_setting_id,
5503: a.customer_id,

Line 5638: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5634: LAST_UPDATE_LOGIN,
5635: LAST_UPDATE_DATE,
5636: LAST_UPDATED_BY
5637: ) VALUES (
5638: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5639: 'OE_SETS',
5640: MERGE_HEADER_ID_LIST(I),
5641: sets_set_id_tab(I),
5642: sets_ship_to_org_id_tab(I),

Line 5806: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5802: LAST_UPDATE_LOGIN,
5803: LAST_UPDATE_DATE,
5804: LAST_UPDATED_BY
5805: ) VALUES (
5806: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5807: 'OE_PRICE_ADJ_ATTRIBS',
5808: MERGE_HEADER_ID_LIST(I),
5809: attrib_id_tab(I),
5810: pricing_attr_value_from_tab(I),

Line 6108: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6104: LAST_UPDATE_LOGIN,
6105: LAST_UPDATE_DATE,
6106: LAST_UPDATED_BY
6107: ) VALUES (
6108: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6109: 'OE_BLANKET_HEADERS_ALL',
6110: MERGE_HEADER_ID_LIST(I),
6111: hdr_header_id_tab(I),
6112: old_hdr_sold_to_org_id_tab(I),

Line 6328: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6324: LAST_UPDATE_DATE,
6325: LAST_UPDATED_BY
6326: )
6327: select
6328: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6329: 'OE_BLANKET_HEADERS_HIST',
6330: m.customer_merge_header_id,
6331: h.header_id,
6332: h.version_number,

Line 6395: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6391: LAST_UPDATE_DATE,
6392: LAST_UPDATED_BY
6393: )
6394: select
6395: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6396: 'OE_BLANKET_HEADERS_HIST',
6397: m.CUSTOMER_MERGE_HEADER_ID,
6398: h.version_number,
6399: h.header_id,

Line 6462: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6458: LAST_UPDATE_DATE,
6459: LAST_UPDATED_BY
6460: )
6461: select
6462: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6463: 'OE_BLANKET_HEADERS_HIST',
6464: m.CUSTOMER_MERGE_HEADER_ID,
6465: h.header_id,
6466: h.version_number,

Line 6531: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6527: LAST_UPDATE_DATE,
6528: LAST_UPDATED_BY
6529: )
6530: select
6531: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6532: 'OE_BLANKET_HEADERS_HIST',
6533: m.customer_merge_header_id,
6534: h.header_id,
6535: h.version_number,

Line 6604: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6600: LAST_UPDATE_DATE,
6601: LAST_UPDATED_BY
6602: )
6603: select
6604: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6605: 'OE_BLANKET_HEADERS_HIST',
6606: m.customer_merge_header_id,
6607: h.header_id,
6608: h.version_number,

Line 6907: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6903: LAST_UPDATE_LOGIN,
6904: LAST_UPDATE_DATE,
6905: LAST_UPDATED_BY
6906: ) VALUES (
6907: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6908: 'OE_BLANKET_LINES_ALL',
6909: MERGE_HEADER_ID_LIST(I),
6910: line_line_id_tab(I),
6911: line_sold_to_org_id_tab(I),

Line 7244: HZ_CUSTOMER_MERGE_LOG_s.nextval,

7240: LAST_UPDATE_LOGIN,
7241: LAST_UPDATE_DATE,
7242: LAST_UPDATED_BY
7243: ) VALUES (
7244: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7245: 'OE_BLANKET_LINES_HIST',
7246: MERGE_HEADER_ID_LIST(I),
7247: lhst_line_id_tab(I),
7248: lhst_version_number_tab(I),

Line 7401: HZ_CUSTOMER_MERGE_LOG_s.nextval,

7397: LAST_UPDATE_DATE,
7398: LAST_UPDATED_BY)
7399:
7400: SELECT
7401: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7402: 'OE_EM_INFORMATION_ALL',
7403: m.CUSTOMER_MERGE_HEADER_ID,
7404: h.ORIG_SYS_DOCUMENT_REF,
7405: h.sold_to_org_id,