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_ATTACHMENT_RULE_ELEMENTS

Line 4164: from oe_attachment_rule_elements

4160: )
4161: IS
4162: CURSOR c1 is
4163: select RULE_ELEMENT_ID
4164: from oe_attachment_rule_elements
4165: where attribute_value in (select to_char(m.duplicate_site_id)
4166: from ra_customer_merges m
4167: where m.process_flag = 'N'
4168: and m.request_id = req_id

Line 4175: from oe_attachment_rule_elements

4171: for update nowait;
4172:
4173: CURSOR c2 is
4174: select RULE_ELEMENT_ID
4175: from oe_attachment_rule_elements
4176: where attribute_value in (select to_char(m.duplicate_site_id)
4177: from ra_customer_merges m
4178: where m.process_flag = 'N'
4179: and m.request_id = req_id

Line 4186: from oe_attachment_rule_elements

4182: for update nowait;
4183:
4184: CURSOR c3 is
4185: select RULE_ELEMENT_ID
4186: from oe_attachment_rule_elements
4187: where attribute_value in (select to_char(m.duplicate_id)
4188: from ra_customer_merges m
4189: where m.process_flag = 'N'
4190: and m.request_id = req_id

Line 4208: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );

4204:
4205: IF( process_mode = 'LOCK' ) THEN
4206:
4207: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
4208: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
4209:
4210: open c1;
4211: close c1;
4212:

Line 4243: 'OE_ATTACHMENT_RULE_ELEMENTS',

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

Line 4255: from OE_ATTACHMENT_RULE_ELEMENTS a,

4251: hz_utility_pub.CREATION_DATE,
4252: hz_utility_pub.LAST_UPDATE_LOGIN,
4253: hz_utility_pub.LAST_UPDATE_DATE,
4254: hz_utility_pub.LAST_UPDATED_BY
4255: from OE_ATTACHMENT_RULE_ELEMENTS a,
4256: ra_customer_merges m
4257: where a.attribute_value = to_char(m.duplicate_site_id)
4258: and m.process_flag = 'N'
4259: and m.request_id = req_id

Line 4267: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );

4263: END IF;
4264:
4265: /* site level update */
4266: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4267: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
4268:
4269: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
4270: set (attribute_value) = (select distinct to_char(m.customer_site_id)
4271: from ra_customer_merges m

Line 4269: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a

4265: /* site level update */
4266: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4267: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
4268:
4269: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
4270: set (attribute_value) = (select distinct to_char(m.customer_site_id)
4271: from ra_customer_merges m
4272: where a.attribute_value =
4273: to_char(m.duplicate_site_id)

Line 4311: 'OE_ATTACHMENT_RULE_ELEMENTS',

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

Line 4323: from OE_ATTACHMENT_RULE_ELEMENTS a,

4319: hz_utility_pub.CREATION_DATE,
4320: hz_utility_pub.LAST_UPDATE_LOGIN,
4321: hz_utility_pub.LAST_UPDATE_DATE,
4322: hz_utility_pub.LAST_UPDATED_BY
4323: from OE_ATTACHMENT_RULE_ELEMENTS a,
4324: ra_customer_merges m
4325: where a.attribute_value = to_char(m.duplicate_site_id)
4326: and m.process_flag = 'N'
4327: and m.request_id = req_id

Line 4335: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );

4331: END IF;
4332:
4333: /* site level update */
4334: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4335: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
4336:
4337: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
4338: set (attribute_value) = (select distinct to_char(m.customer_site_id)
4339: from ra_customer_merges m

Line 4337: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a

4333: /* site level update */
4334: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4335: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
4336:
4337: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
4338: set (attribute_value) = (select distinct to_char(m.customer_site_id)
4339: from ra_customer_merges m
4340: where a.attribute_value =
4341: to_char(m.duplicate_site_id)

Line 4380: 'OE_ATTACHMENT_RULE_ELEMENTS',

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

Line 4392: from OE_ATTACHMENT_RULE_ELEMENTS a,

4388: hz_utility_pub.CREATION_DATE,
4389: hz_utility_pub.LAST_UPDATE_LOGIN,
4390: hz_utility_pub.LAST_UPDATE_DATE,
4391: hz_utility_pub.LAST_UPDATED_BY
4392: from OE_ATTACHMENT_RULE_ELEMENTS a,
4393: ra_customer_merges m
4394: where a.attribute_value = to_char(m.duplicate_site_id)
4395: and m.process_flag = 'N'
4396: and m.request_id = req_id

Line 4404: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );

4400: END IF;
4401:
4402: /* customer level update */
4403: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4404: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
4405:
4406: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
4407: set (attribute_value) = (select distinct to_char(m.customer_id)
4408: from ra_customer_merges m

Line 4406: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a

4402: /* customer level update */
4403: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4404: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
4405:
4406: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
4407: set (attribute_value) = (select distinct to_char(m.customer_id)
4408: from ra_customer_merges m
4409: where a.attribute_value =
4410: to_char(m.duplicate_id)