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 3952: from oe_def_attr_def_rules

3948: for update nowait;
3949:
3950: CURSOR c5 is
3951: select ATTR_DEF_RULE_ID
3952: from oe_def_attr_def_rules
3953: where src_constant_value in (select to_char(m.duplicate_site_id)
3954: from ra_customer_merges m
3955: where m.process_flag = 'N'
3956: and m.request_id = req_id

Line 3963: from oe_def_attr_def_rules

3959: for update nowait;
3960:
3961: CURSOR c6 is
3962: select ATTR_DEF_RULE_ID
3963: from oe_def_attr_def_rules
3964: where src_constant_value in (select to_char(m.duplicate_site_id)
3965: from ra_customer_merges m
3966: where m.process_flag = 'N'
3967: and m.request_id = req_id

Line 3974: from oe_def_attr_def_rules

3970: for update nowait;
3971:
3972: CURSOR c7 is
3973: select ATTR_DEF_RULE_ID
3974: from oe_def_attr_def_rules
3975: where src_constant_value in (select to_char(m.duplicate_site_id)
3976: from ra_customer_merges m
3977: where m.process_flag = 'N'
3978: and m.request_id = req_id

Line 3985: from oe_def_attr_def_rules

3981: for update nowait;
3982:
3983: CURSOR c8 is
3984: select ATTR_DEF_RULE_ID
3985: from oe_def_attr_def_rules
3986: where src_constant_value in (select to_char(m.duplicate_id)
3987: from ra_customer_merges m
3988: where m.process_flag = 'N'
3989: and m.request_id = req_id

Line 4331: 'OE_DEF_ATTR_DEF_RULES',

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

Line 4343: from OE_DEF_ATTR_DEF_RULES a,

4339: hz_utility_pub.CREATION_DATE,
4340: hz_utility_pub.LAST_UPDATE_LOGIN,
4341: hz_utility_pub.LAST_UPDATE_DATE,
4342: hz_utility_pub.LAST_UPDATED_BY
4343: from OE_DEF_ATTR_DEF_RULES a,
4344: ra_customer_merges m
4345: where a.src_constant_value = to_char(m.duplicate_site_id)
4346: and m.process_flag = 'N'
4347: and m.request_id = req_id

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

4351: END IF;
4352:
4353: /* site level update */
4354: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4355: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4356:
4357:
4358:
4359: UPDATE OE_DEF_ATTR_DEF_RULES a

Line 4359: UPDATE OE_DEF_ATTR_DEF_RULES a

4355: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4356:
4357:
4358:
4359: UPDATE OE_DEF_ATTR_DEF_RULES a
4360: set src_constant_value = (select distinct to_char(m.customer_site_id)
4361: from ra_customer_merges m
4362: where a.src_constant_value =
4363: to_char(m.duplicate_site_id)

Line 4401: 'OE_DEF_ATTR_DEF_RULES',

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

Line 4413: from OE_DEF_ATTR_DEF_RULES a,

4409: hz_utility_pub.CREATION_DATE,
4410: hz_utility_pub.LAST_UPDATE_LOGIN,
4411: hz_utility_pub.LAST_UPDATE_DATE,
4412: hz_utility_pub.LAST_UPDATED_BY
4413: from OE_DEF_ATTR_DEF_RULES a,
4414: ra_customer_merges m
4415: where a.src_constant_value = to_char(m.duplicate_site_id)
4416: and m.process_flag = 'N'
4417: and m.request_id = req_id

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

4421: END IF;
4422:
4423: /* site level update */
4424: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4425: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4426:
4427: UPDATE OE_DEF_ATTR_DEF_RULES a
4428: set src_constant_value = (select distinct to_char(m.customer_site_id)
4429: from ra_customer_merges m

Line 4427: UPDATE OE_DEF_ATTR_DEF_RULES a

4423: /* site level update */
4424: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4425: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4426:
4427: UPDATE OE_DEF_ATTR_DEF_RULES a
4428: set src_constant_value = (select distinct to_char(m.customer_site_id)
4429: from ra_customer_merges m
4430: where a.src_constant_value =
4431: to_char(m.duplicate_site_id)

Line 4469: 'OE_DEF_ATTR_DEF_RULES',

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

Line 4481: from OE_DEF_ATTR_DEF_RULES a,

4477: hz_utility_pub.CREATION_DATE,
4478: hz_utility_pub.LAST_UPDATE_LOGIN,
4479: hz_utility_pub.LAST_UPDATE_DATE,
4480: hz_utility_pub.LAST_UPDATED_BY
4481: from OE_DEF_ATTR_DEF_RULES a,
4482: ra_customer_merges m
4483: where a.src_constant_value = to_char(m.duplicate_site_id)
4484: and m.process_flag = 'N'
4485: and m.request_id = req_id

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

4489: END IF;
4490:
4491: /* site level update */
4492: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4493: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4494:
4495: UPDATE OE_DEF_ATTR_DEF_RULES a
4496: set src_constant_value = (select distinct to_char(m.customer_site_id)
4497: from ra_customer_merges m

Line 4495: UPDATE OE_DEF_ATTR_DEF_RULES a

4491: /* site level update */
4492: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4493: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4494:
4495: UPDATE OE_DEF_ATTR_DEF_RULES a
4496: set src_constant_value = (select distinct to_char(m.customer_site_id)
4497: from ra_customer_merges m
4498: where a.src_constant_value =
4499: to_char(m.duplicate_site_id)

Line 4538: 'OE_DEF_ATTR_DEF_RULES',

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

Line 4550: from OE_DEF_ATTR_DEF_RULES a,

4546: hz_utility_pub.CREATION_DATE,
4547: hz_utility_pub.LAST_UPDATE_LOGIN,
4548: hz_utility_pub.LAST_UPDATE_DATE,
4549: hz_utility_pub.LAST_UPDATED_BY
4550: from OE_DEF_ATTR_DEF_RULES a,
4551: ra_customer_merges m
4552: where a.src_constant_value = to_char(m.duplicate_site_id)
4553: and m.process_flag = 'N'
4554: and m.request_id = req_id

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

4558: END IF;
4559:
4560: /* customer level update */
4561: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4562: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4563:
4564: UPDATE OE_DEF_ATTR_DEF_RULES a
4565: set src_constant_value = (select distinct to_char(m.customer_id)
4566: from ra_customer_merges m

Line 4564: UPDATE OE_DEF_ATTR_DEF_RULES a

4560: /* customer level update */
4561: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4562: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
4563:
4564: UPDATE OE_DEF_ATTR_DEF_RULES a
4565: set src_constant_value = (select distinct to_char(m.customer_id)
4566: from ra_customer_merges m
4567: where a.src_constant_value =
4568: to_char(m.duplicate_id)