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 507: HZ_CUSTOMER_MERGE_LOG_s.nextval,

503: LAST_UPDATE_LOGIN,
504: LAST_UPDATE_DATE,
505: LAST_UPDATED_BY
506: ) VALUES (
507: HZ_CUSTOMER_MERGE_LOG_s.nextval,
508: 'OE_ORDER_HEADERS_ALL',
509: MERGE_HEADER_ID_LIST(I),
510: hdr_header_id_tab(I),
511: old_hdr_sold_to_org_id_tab(I),

Line 1738: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1734: LAST_UPDATE_DATE,
1735: LAST_UPDATED_BY
1736: )
1737: select
1738: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1739: 'OE_HEADER_ACKS',
1740: m.CUSTOMER_MERGE_HEADER_ID,
1741: h.ORIG_SYS_DOCUMENT_REF,
1742: h.ship_to_org_id,

Line 1805: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1801: LAST_UPDATE_DATE,
1802: LAST_UPDATED_BY
1803: )
1804: select
1805: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1806: 'OE_HEADERS_ACKS',
1807: m.CUSTOMER_MERGE_HEADER_ID,
1808: h.ORIG_SYS_DOCUMENT_REF,
1809: h.invoice_to_org_id,

Line 1874: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1870: LAST_UPDATE_DATE,
1871: LAST_UPDATED_BY
1872: )
1873: select
1874: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1875: 'OE_HEADER_ACKS',
1876: m.CUSTOMER_MERGE_HEADER_ID,
1877: h.ORIG_SYS_DOCUMENT_REF,
1878: h.deliver_to_org_id,

Line 1945: HZ_CUSTOMER_MERGE_LOG_s.nextval,

1941: LAST_UPDATE_DATE,
1942: LAST_UPDATED_BY
1943: )
1944: select
1945: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1946: 'OE_HEADER_ACKS',
1947: m.CUSTOMER_MERGE_HEADER_ID,
1948: h.ORIG_SYS_DOCUMENT_REF,
1949: h.sold_to_org_id,

Line 2017: HZ_CUSTOMER_MERGE_LOG_s.nextval,

2013: LAST_UPDATE_DATE,
2014: LAST_UPDATED_BY
2015: )
2016: select
2017: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2018: 'OE_HEADER_ACKS',
2019: m.CUSTOMER_MERGE_HEADER_ID,
2020: h.ORIG_SYS_DOCUMENT_REF,
2021: h.sold_to_site_use_id,

Line 2090: HZ_CUSTOMER_MERGE_LOG_s.nextval,

2086: LAST_UPDATE_DATE,
2087: LAST_UPDATED_BY
2088: )
2089: select
2090: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2091: 'OE_HEADER_ACKS',
2092: m.CUSTOMER_MERGE_HEADER_ID,
2093: h.ORIG_SYS_DOCUMENT_REF,
2094: h.end_customer_site_use_id,

Line 2163: HZ_CUSTOMER_MERGE_LOG_s.nextval,

2159: LAST_UPDATE_DATE,
2160: LAST_UPDATED_BY
2161: )
2162: select
2163: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2164: 'OE_HEADER_ACKS',
2165: m.CUSTOMER_MERGE_HEADER_ID,
2166: h.ORIG_SYS_DOCUMENT_REF,
2167: h.end_customer_id,

Line 2724: HZ_CUSTOMER_MERGE_LOG_s.nextval,

2720: LAST_UPDATE_LOGIN,
2721: LAST_UPDATE_DATE,
2722: LAST_UPDATED_BY
2723: ) VALUES (
2724: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2725: 'OE_ORDER_LINES_ALL',
2726: MERGE_HEADER_ID_LIST(I),
2727: line_line_id_tab(I),
2728: line_sold_to_org_id_tab(I),

Line 3608: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3604: LAST_UPDATE_DATE,
3605: LAST_UPDATED_BY
3606: )
3607: select
3608: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3609: 'OE_LINE_ACKS',
3610: m.CUSTOMER_MERGE_HEADER_ID,
3611: a.ORIG_SYS_DOCUMENT_REF,
3612: a.ORIG_SYS_LINE_REF,

Line 3677: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3673: LAST_UPDATE_DATE,
3674: LAST_UPDATED_BY
3675: )
3676: select
3677: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3678: 'OE_LINE_ACKS',
3679: m.CUSTOMER_MERGE_HEADER_ID,
3680: a.ORIG_SYS_DOCUMENT_REF,
3681: a.ORIG_SYS_LINE_REF,

Line 3745: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3741: LAST_UPDATE_DATE,
3742: LAST_UPDATED_BY
3743: )
3744: select
3745: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3746: 'OE_LINE_ACKS',
3747: m.CUSTOMER_MERGE_HEADER_ID,
3748: a.ORIG_SYS_DOCUMENT_REF,
3749: a.ORIG_SYS_LINE_REF,

Line 3813: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3809: LAST_UPDATE_DATE,
3810: LAST_UPDATED_BY
3811: )
3812: select
3813: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3814: 'OE_LINE_ACKS',
3815: m.CUSTOMER_MERGE_HEADER_ID,
3816: a.ORIG_SYS_DOCUMENT_REF,
3817: a.ORIG_SYS_LINE_REF,

Line 3887: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3883: LAST_UPDATE_DATE,
3884: LAST_UPDATED_BY
3885: )
3886: select
3887: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3888: 'OE_LINE_ACKS',
3889: m.CUSTOMER_MERGE_HEADER_ID,
3890: a.ORIG_SYS_DOCUMENT_REF,
3891: a.ORIG_SYS_LINE_REF,

Line 3964: HZ_CUSTOMER_MERGE_LOG_s.nextval,

3960: LAST_UPDATE_DATE,
3961: LAST_UPDATED_BY
3962: )
3963: select
3964: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3965: 'OE_LINE_ACKS',
3966: m.CUSTOMER_MERGE_HEADER_ID,
3967: a.ORIG_SYS_DOCUMENT_REF,
3968: a.ORIG_SYS_LINE_REF,

Line 4039: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4035: LAST_UPDATE_DATE,
4036: LAST_UPDATED_BY
4037: )
4038: select
4039: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4040: 'OE_LINE_ACKS',
4041: m.CUSTOMER_MERGE_HEADER_ID,
4042: a.ORIG_SYS_DOCUMENT_REF,
4043: a.ORIG_SYS_LINE_REF,

Line 4242: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4238: LAST_UPDATE_DATE,
4239: LAST_UPDATED_BY
4240: )
4241: select
4242: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4243: 'OE_ATTACHMENT_RULE_ELEMENTS',
4244: m.customer_merge_header_id,
4245: a.rule_element_id,
4246: a.attribute_value,

Line 4310: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4306: LAST_UPDATE_DATE,
4307: LAST_UPDATED_BY
4308: )
4309: select
4310: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4311: 'OE_ATTACHMENT_RULE_ELEMENTS',
4312: m.customer_merge_header_id,
4313: a.rule_element_id,
4314: a.attribute_value,

Line 4379: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4375: LAST_UPDATE_DATE,
4376: LAST_UPDATED_BY
4377: )
4378: select
4379: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4380: 'OE_ATTACHMENT_RULE_ELEMENTS',
4381: m.customer_merge_header_id,
4382: a.rule_element_id,
4383: a.attribute_value,

Line 4599: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4595: LAST_UPDATE_DATE,
4596: LAST_UPDATED_BY
4597: )
4598: select
4599: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4600: 'OE_DEF_CONDN_ELEMS',
4601: m.customer_merge_header_id,
4602: a.condition_element_id,
4603: a.value_string,

Line 4666: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4662: LAST_UPDATE_DATE,
4663: LAST_UPDATED_BY
4664: )
4665: select
4666: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4667: 'OE_DEF_CONDN_ELEMS',
4668: m.customer_merge_header_id,
4669: a.condition_element_id,
4670: a.value_string,

Line 4735: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4731: LAST_UPDATE_DATE,
4732: LAST_UPDATED_BY
4733: )
4734: select
4735: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4736: 'OE_DEF_CONDN_ELEMS',
4737: m.customer_merge_header_id,
4738: a.condition_element_id,
4739: a.value_string,

Line 4803: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4799: LAST_UPDATE_DATE,
4800: LAST_UPDATED_BY
4801: )
4802: select
4803: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4804: 'OE_DEF_CONDN_ELEMS',
4805: m.customer_merge_header_id,
4806: a.condition_element_id,
4807: a.value_string,

Line 4873: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4869: LAST_UPDATE_DATE,
4870: LAST_UPDATED_BY
4871: )
4872: select
4873: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4874: 'OE_DEF_ATTR_DEF_RULES',
4875: m.customer_merge_header_id,
4876: a.attr_def_rule_id,
4877: a.src_constant_value,

Line 4943: HZ_CUSTOMER_MERGE_LOG_s.nextval,

4939: LAST_UPDATE_DATE,
4940: LAST_UPDATED_BY
4941: )
4942: select
4943: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4944: 'OE_DEF_ATTR_DEF_RULES',
4945: m.customer_merge_header_id,
4946: a.attr_def_rule_id,
4947: a.src_constant_value,

Line 5011: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5007: LAST_UPDATE_DATE,
5008: LAST_UPDATED_BY
5009: )
5010: select
5011: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5012: 'OE_DEF_ATTR_DEF_RULES',
5013: m.customer_merge_header_id,
5014: a.attr_def_rule_id,
5015: a.src_constant_value,

Line 5080: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5076: LAST_UPDATE_DATE,
5077: LAST_UPDATED_BY
5078: )
5079: select
5080: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5081: 'OE_DEF_ATTR_DEF_RULES',
5082: m.customer_merge_header_id,
5083: a.attr_def_rule_id,
5084: a.src_constant_value,

Line 5248: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5244: LAST_UPDATE_DATE,
5245: LAST_UPDATED_BY
5246: )
5247: select
5248: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5249: 'OE_PC_VTMPLT_COLS',
5250: m.customer_merge_header_id,
5251: a.validation_tmplt_id,
5252: a.value_string,

Line 5316: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5312: LAST_UPDATE_DATE,
5313: LAST_UPDATED_BY
5314: )
5315: select
5316: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5317: 'OE_PC_VTMPLT_COLS',
5318: m.customer_merge_header_id,
5319: a.validation_tmplt_id,
5320: a.value_string,

Line 5384: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5380: LAST_UPDATE_DATE,
5381: LAST_UPDATED_BY
5382: )
5383: select
5384: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5385: 'OE_PC_VTMPLT_COLS',
5386: m.customer_merge_header_id,
5387: a.validation_tmplt_id,
5388: a.value_string,

Line 5453: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5449: LAST_UPDATE_DATE,
5450: LAST_UPDATED_BY
5451: )
5452: select
5453: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5454: 'OE_PC_VTMPLT_COLS',
5455: m.customer_merge_header_id,
5456: a.validation_tmplt_id,
5457: a.value_string,

Line 5605: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5601: LAST_UPDATE_DATE,
5602: LAST_UPDATED_BY
5603: )
5604: select
5605: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5606: 'OE_HOLD_SOURCES',
5607: m.customer_merge_header_id,
5608: a.hold_source_id,
5609: to_char(a.hold_entity_id),

Line 5673: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5669: LAST_UPDATE_DATE,
5670: LAST_UPDATED_BY
5671: )
5672: select
5673: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5674: 'OE_HOLD_SOURCES',
5675: m.customer_merge_header_id,
5676: a.hold_source_id,
5677: to_char(a.hold_entity_id),

Line 5744: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5740: LAST_UPDATE_DATE,
5741: LAST_UPDATED_BY
5742: )
5743: select
5744: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5745: 'OE_HOLD_SOURCES',
5746: m.customer_merge_header_id,
5747: a.hold_source_id,
5748: to_char(a.hold_entity_id),

Line 5861: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5857: LAST_UPDATE_DATE,
5858: LAST_UPDATED_BY
5859: )
5860: select
5861: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5862: 'OE_DROP_SHIP_SOURCES',
5863: m.customer_merge_header_id,
5864: a.drop_ship_source_id,
5865: to_char(a.line_location_id),

Line 5985: HZ_CUSTOMER_MERGE_LOG_s.nextval,

5981: LAST_UPDATE_DATE,
5982: LAST_UPDATED_BY
5983: )
5984: select
5985: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5986: 'OE_CUST_ITEM_SETTINGS',
5987: m.customer_merge_header_id,
5988: a.cust_item_setting_id,
5989: a.site_use_id,

Line 6047: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6043: LAST_UPDATE_DATE,
6044: LAST_UPDATED_BY
6045: )
6046: select
6047: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6048: 'OE_CUST_ITEM_SETTINGS',
6049: m.customer_merge_header_id,
6050: a.cust_item_setting_id,
6051: a.customer_id,

Line 6211: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6207: LAST_UPDATE_LOGIN,
6208: LAST_UPDATE_DATE,
6209: LAST_UPDATED_BY
6210: ) VALUES (
6211: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6212: 'OE_SETS',
6213: MERGE_HEADER_ID_LIST(I),
6214: sets_set_id_tab(I),
6215: sets_ship_to_org_id_tab(I),

Line 6387: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6383: LAST_UPDATE_LOGIN,
6384: LAST_UPDATE_DATE,
6385: LAST_UPDATED_BY
6386: ) VALUES (
6387: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6388: 'OE_PRICE_ADJ_ATTRIBS',
6389: MERGE_HEADER_ID_LIST(I),
6390: attrib_id_tab(I),
6391: pricing_attr_value_from_tab(I),

Line 6766: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6762: LAST_UPDATE_LOGIN,
6763: LAST_UPDATE_DATE,
6764: LAST_UPDATED_BY
6765: ) VALUES (
6766: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6767: 'OE_BLANKET_HEADERS_ALL',
6768: MERGE_HEADER_ID_LIST(I),
6769: hdr_header_id_tab(I),
6770: old_hdr_sold_to_org_id_tab(I),

Line 6997: HZ_CUSTOMER_MERGE_LOG_s.nextval,

6993: LAST_UPDATE_DATE,
6994: LAST_UPDATED_BY
6995: )
6996: select
6997: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6998: 'OE_BLANKET_HEADERS_HIST',
6999: m.customer_merge_header_id,
7000: h.header_id,
7001: h.version_number,

Line 7064: HZ_CUSTOMER_MERGE_LOG_s.nextval,

7060: LAST_UPDATE_DATE,
7061: LAST_UPDATED_BY
7062: )
7063: select
7064: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7065: 'OE_BLANKET_HEADERS_HIST',
7066: m.CUSTOMER_MERGE_HEADER_ID,
7067: h.version_number,
7068: h.header_id,

Line 7131: HZ_CUSTOMER_MERGE_LOG_s.nextval,

7127: LAST_UPDATE_DATE,
7128: LAST_UPDATED_BY
7129: )
7130: select
7131: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7132: 'OE_BLANKET_HEADERS_HIST',
7133: m.CUSTOMER_MERGE_HEADER_ID,
7134: h.header_id,
7135: h.version_number,

Line 7200: HZ_CUSTOMER_MERGE_LOG_s.nextval,

7196: LAST_UPDATE_DATE,
7197: LAST_UPDATED_BY
7198: )
7199: select
7200: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7201: 'OE_BLANKET_HEADERS_HIST',
7202: m.customer_merge_header_id,
7203: h.header_id,
7204: h.version_number,

Line 7273: HZ_CUSTOMER_MERGE_LOG_s.nextval,

7269: LAST_UPDATE_DATE,
7270: LAST_UPDATED_BY
7271: )
7272: select
7273: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7274: 'OE_BLANKET_HEADERS_HIST',
7275: m.customer_merge_header_id,
7276: h.header_id,
7277: h.version_number,

Line 7663: HZ_CUSTOMER_MERGE_LOG_s.nextval,

7659: LAST_UPDATE_LOGIN,
7660: LAST_UPDATE_DATE,
7661: LAST_UPDATED_BY
7662: ) VALUES (
7663: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7664: 'OE_BLANKET_LINES_ALL',
7665: MERGE_HEADER_ID_LIST(I),
7666: line_line_id_tab(I),
7667: line_sold_to_org_id_tab(I),

Line 8092: HZ_CUSTOMER_MERGE_LOG_s.nextval,

8088: LAST_UPDATE_LOGIN,
8089: LAST_UPDATE_DATE,
8090: LAST_UPDATED_BY
8091: ) VALUES (
8092: HZ_CUSTOMER_MERGE_LOG_s.nextval,
8093: 'OE_BLANKET_LINES_HIST',
8094: MERGE_HEADER_ID_LIST(I),
8095: lhst_line_id_tab(I),
8096: lhst_version_number_tab(I),

Line 8262: HZ_CUSTOMER_MERGE_LOG_s.nextval,

8258: LAST_UPDATE_DATE,
8259: LAST_UPDATED_BY)
8260:
8261: SELECT
8262: HZ_CUSTOMER_MERGE_LOG_s.nextval,
8263: 'OE_EM_INFORMATION_ALL',
8264: m.CUSTOMER_MERGE_HEADER_ID,
8265: h.ORIG_SYS_DOCUMENT_REF,
8266: h.sold_to_org_id,