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 OE_DEF_ATTR_DEF_RULES

Line 4495: from oe_def_attr_def_rules

4491: for update nowait;
4492:
4493: CURSOR c5 is
4494: select ATTR_DEF_RULE_ID
4495: from oe_def_attr_def_rules
4496: where src_constant_value in (select to_char(m.duplicate_site_id)
4497: from ra_customer_merges m
4498: where m.process_flag = 'N'
4499: and m.request_id = req_id

Line 4506: from oe_def_attr_def_rules

4502: for update nowait;
4503:
4504: CURSOR c6 is
4505: select ATTR_DEF_RULE_ID
4506: from oe_def_attr_def_rules
4507: where src_constant_value in (select to_char(m.duplicate_site_id)
4508: from ra_customer_merges m
4509: where m.process_flag = 'N'
4510: and m.request_id = req_id

Line 4517: from oe_def_attr_def_rules

4513: for update nowait;
4514:
4515: CURSOR c7 is
4516: select ATTR_DEF_RULE_ID
4517: from oe_def_attr_def_rules
4518: where src_constant_value in (select to_char(m.duplicate_site_id)
4519: from ra_customer_merges m
4520: where m.process_flag = 'N'
4521: and m.request_id = req_id

Line 4528: from oe_def_attr_def_rules

4524: for update nowait;
4525:
4526: CURSOR c8 is
4527: select ATTR_DEF_RULE_ID
4528: from oe_def_attr_def_rules
4529: where src_constant_value in (select to_char(m.duplicate_id)
4530: from ra_customer_merges m
4531: where m.process_flag = 'N'
4532: and m.request_id = req_id

Line 4874: 'OE_DEF_ATTR_DEF_RULES',

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,
4878: to_char(m.customer_site_id),

Line 4886: from OE_DEF_ATTR_DEF_RULES a,

4882: hz_utility_pub.CREATION_DATE,
4883: hz_utility_pub.LAST_UPDATE_LOGIN,
4884: hz_utility_pub.LAST_UPDATE_DATE,
4885: hz_utility_pub.LAST_UPDATED_BY
4886: from OE_DEF_ATTR_DEF_RULES a,
4887: ra_customer_merges m
4888: where a.src_constant_value = to_char(m.duplicate_site_id)
4889: and m.process_flag = 'N'
4890: and m.request_id = req_id

Line 4898: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );

4894: END IF;
4895:
4896: /* site level update */
4897: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4898: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4899:
4900:
4901:
4902: UPDATE OE_DEF_ATTR_DEF_RULES a

Line 4902: UPDATE OE_DEF_ATTR_DEF_RULES a

4898: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4899:
4900:
4901:
4902: UPDATE OE_DEF_ATTR_DEF_RULES a
4903: set src_constant_value = (select distinct to_char(m.customer_site_id)
4904: from ra_customer_merges m
4905: where a.src_constant_value =
4906: to_char(m.duplicate_site_id)

Line 4944: 'OE_DEF_ATTR_DEF_RULES',

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,
4948: to_char(m.customer_site_id),

Line 4956: from OE_DEF_ATTR_DEF_RULES a,

4952: hz_utility_pub.CREATION_DATE,
4953: hz_utility_pub.LAST_UPDATE_LOGIN,
4954: hz_utility_pub.LAST_UPDATE_DATE,
4955: hz_utility_pub.LAST_UPDATED_BY
4956: from OE_DEF_ATTR_DEF_RULES a,
4957: ra_customer_merges m
4958: where a.src_constant_value = to_char(m.duplicate_site_id)
4959: and m.process_flag = 'N'
4960: and m.request_id = req_id

Line 4968: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );

4964: END IF;
4965:
4966: /* site level update */
4967: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4968: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4969:
4970: UPDATE OE_DEF_ATTR_DEF_RULES a
4971: set src_constant_value = (select distinct to_char(m.customer_site_id)
4972: from ra_customer_merges m

Line 4970: UPDATE OE_DEF_ATTR_DEF_RULES a

4966: /* site level update */
4967: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4968: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4969:
4970: UPDATE OE_DEF_ATTR_DEF_RULES a
4971: set src_constant_value = (select distinct to_char(m.customer_site_id)
4972: from ra_customer_merges m
4973: where a.src_constant_value =
4974: to_char(m.duplicate_site_id)

Line 5012: 'OE_DEF_ATTR_DEF_RULES',

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,
5016: to_char(m.customer_site_id),

Line 5024: from OE_DEF_ATTR_DEF_RULES a,

5020: hz_utility_pub.CREATION_DATE,
5021: hz_utility_pub.LAST_UPDATE_LOGIN,
5022: hz_utility_pub.LAST_UPDATE_DATE,
5023: hz_utility_pub.LAST_UPDATED_BY
5024: from OE_DEF_ATTR_DEF_RULES a,
5025: ra_customer_merges m
5026: where a.src_constant_value = to_char(m.duplicate_site_id)
5027: and m.process_flag = 'N'
5028: and m.request_id = req_id

Line 5036: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );

5032: END IF;
5033:
5034: /* site level update */
5035: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5036: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
5037:
5038: UPDATE OE_DEF_ATTR_DEF_RULES a
5039: set src_constant_value = (select distinct to_char(m.customer_site_id)
5040: from ra_customer_merges m

Line 5038: UPDATE OE_DEF_ATTR_DEF_RULES a

5034: /* site level update */
5035: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5036: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
5037:
5038: UPDATE OE_DEF_ATTR_DEF_RULES a
5039: set src_constant_value = (select distinct to_char(m.customer_site_id)
5040: from ra_customer_merges m
5041: where a.src_constant_value =
5042: to_char(m.duplicate_site_id)

Line 5081: 'OE_DEF_ATTR_DEF_RULES',

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,
5085: to_char(m.customer_site_id),

Line 5093: from OE_DEF_ATTR_DEF_RULES a,

5089: hz_utility_pub.CREATION_DATE,
5090: hz_utility_pub.LAST_UPDATE_LOGIN,
5091: hz_utility_pub.LAST_UPDATE_DATE,
5092: hz_utility_pub.LAST_UPDATED_BY
5093: from OE_DEF_ATTR_DEF_RULES a,
5094: ra_customer_merges m
5095: where a.src_constant_value = to_char(m.duplicate_site_id)
5096: and m.process_flag = 'N'
5097: and m.request_id = req_id

Line 5105: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );

5101: END IF;
5102:
5103: /* customer level update */
5104: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5105: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
5106:
5107: UPDATE OE_DEF_ATTR_DEF_RULES a
5108: set src_constant_value = (select distinct to_char(m.customer_id)
5109: from ra_customer_merges m

Line 5107: UPDATE OE_DEF_ATTR_DEF_RULES a

5103: /* customer level update */
5104: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5105: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
5106:
5107: UPDATE OE_DEF_ATTR_DEF_RULES a
5108: set src_constant_value = (select distinct to_char(m.customer_id)
5109: from ra_customer_merges m
5110: where a.src_constant_value =
5111: to_char(m.duplicate_id)