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_CONDN_ELEMS

Line 4451: from oe_def_condn_elems

4447: )
4448: IS
4449: CURSOR c1 is
4450: select CONDITION_ELEMENT_ID
4451: from oe_def_condn_elems
4452: where value_string in (select to_char(m.duplicate_site_id)
4453: from ra_customer_merges m
4454: where m.process_flag = 'N'
4455: and m.request_id = req_id

Line 4462: from oe_def_condn_elems

4458: for update nowait;
4459:
4460: CURSOR c2 is
4461: select CONDITION_ELEMENT_ID
4462: from oe_def_condn_elems
4463: where value_string in (select to_char(m.duplicate_site_id)
4464: from ra_customer_merges m
4465: where m.process_flag = 'N'
4466: and m.request_id = req_id

Line 4473: from oe_def_condn_elems

4469: for update nowait;
4470:
4471: CURSOR c4 is
4472: select CONDITION_ELEMENT_ID
4473: from oe_def_condn_elems
4474: where value_string in (select to_char(m.duplicate_site_id)
4475: from ra_customer_merges m
4476: where m.process_flag = 'N'
4477: and m.request_id = req_id

Line 4484: from oe_def_condn_elems

4480: for update nowait;
4481:
4482: CURSOR c3 is
4483: select CONDITION_ELEMENT_ID
4484: from oe_def_condn_elems
4485: where value_string in (select to_char(m.duplicate_id)
4486: from ra_customer_merges m
4487: where m.process_flag = 'N'
4488: and m.request_id = req_id

Line 4543: | OE_DEF_CONDN_ELEMS|

4539: BEGIN
4540: arp_message.set_line( 'OE_CUST_MERGE.OE_Defaulting_Merge()+' );
4541:
4542: /*-----------------------------+
4543: | OE_DEF_CONDN_ELEMS|
4544: +-----------------------------*/
4545: /* both customer and site level */
4546:
4547: IF( process_mode = 'LOCK' ) THEN

Line 4550: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );

4546:
4547: IF( process_mode = 'LOCK' ) THEN
4548:
4549: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
4550: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4551:
4552:
4553: open c1;
4554: close c1;

Line 4600: 'OE_DEF_CONDN_ELEMS',

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

Line 4612: from OE_DEF_CONDN_ELEMS a,

4608: hz_utility_pub.CREATION_DATE,
4609: hz_utility_pub.LAST_UPDATE_LOGIN,
4610: hz_utility_pub.LAST_UPDATE_DATE,
4611: hz_utility_pub.LAST_UPDATED_BY
4612: from OE_DEF_CONDN_ELEMS a,
4613: ra_customer_merges m
4614: where a.value_string = to_char(m.duplicate_site_id)
4615: and m.process_flag = 'N'
4616: and m.request_id = req_id

Line 4624: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );

4620: END IF;
4621:
4622: /* site level update */
4623: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4624: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4625:
4626: UPDATE OE_DEF_CONDN_ELEMS a
4627: set value_string = (select distinct to_char(m.customer_site_id)
4628: from ra_customer_merges m

Line 4626: UPDATE OE_DEF_CONDN_ELEMS a

4622: /* site level update */
4623: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4624: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4625:
4626: UPDATE OE_DEF_CONDN_ELEMS a
4627: set value_string = (select distinct to_char(m.customer_site_id)
4628: from ra_customer_merges m
4629: where a.value_string =
4630: to_char(m.duplicate_site_id)

Line 4667: 'OE_DEF_CONDN_ELEMS',

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

Line 4679: from OE_DEF_CONDN_ELEMS a,

4675: hz_utility_pub.CREATION_DATE,
4676: hz_utility_pub.LAST_UPDATE_LOGIN,
4677: hz_utility_pub.LAST_UPDATE_DATE,
4678: hz_utility_pub.LAST_UPDATED_BY
4679: from OE_DEF_CONDN_ELEMS a,
4680: ra_customer_merges m
4681: where a.value_string = to_char(m.duplicate_site_id)
4682: and m.process_flag = 'N'
4683: and m.request_id = req_id

Line 4692: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );

4688:
4689:
4690: /* site level update */
4691: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4692: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4693:
4694: UPDATE OE_DEF_CONDN_ELEMS a
4695: set value_string = (select distinct to_char(m.customer_site_id)
4696: from ra_customer_merges m

Line 4694: UPDATE OE_DEF_CONDN_ELEMS a

4690: /* site level update */
4691: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4692: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4693:
4694: UPDATE OE_DEF_CONDN_ELEMS a
4695: set value_string = (select distinct to_char(m.customer_site_id)
4696: from ra_customer_merges m
4697: where a.value_string =
4698: to_char(m.duplicate_site_id)

Line 4736: 'OE_DEF_CONDN_ELEMS',

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

Line 4748: from OE_DEF_CONDN_ELEMS a,

4744: hz_utility_pub.CREATION_DATE,
4745: hz_utility_pub.LAST_UPDATE_LOGIN,
4746: hz_utility_pub.LAST_UPDATE_DATE,
4747: hz_utility_pub.LAST_UPDATED_BY
4748: from OE_DEF_CONDN_ELEMS a,
4749: ra_customer_merges m
4750: where a.value_string = to_char(m.duplicate_site_id)
4751: and m.process_flag = 'N'
4752: and m.request_id = req_id

Line 4760: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );

4756: END IF;
4757:
4758: /* site level update */
4759: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4760: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4761:
4762: UPDATE OE_DEF_CONDN_ELEMS a
4763: set value_string = (select distinct to_char(m.customer_site_id)
4764: from ra_customer_merges m

Line 4762: UPDATE OE_DEF_CONDN_ELEMS a

4758: /* site level update */
4759: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4760: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4761:
4762: UPDATE OE_DEF_CONDN_ELEMS a
4763: set value_string = (select distinct to_char(m.customer_site_id)
4764: from ra_customer_merges m
4765: where a.value_string =
4766: to_char(m.duplicate_site_id)

Line 4804: 'OE_DEF_CONDN_ELEMS',

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,
4808: to_char(m.customer_id),

Line 4816: from OE_DEF_CONDN_ELEMS a,

4812: hz_utility_pub.CREATION_DATE,
4813: hz_utility_pub.LAST_UPDATE_LOGIN,
4814: hz_utility_pub.LAST_UPDATE_DATE,
4815: hz_utility_pub.LAST_UPDATED_BY
4816: from OE_DEF_CONDN_ELEMS a,
4817: ra_customer_merges m
4818: where a.value_string = to_char(m.duplicate_id)
4819: and m.process_flag = 'N'
4820: and m.request_id = req_id

Line 4828: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );

4824: END IF;
4825:
4826: /* customer level update */
4827: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4828: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4829:
4830: UPDATE OE_DEF_CONDN_ELEMS a
4831: set value_string = (select distinct to_char(m.customer_id)
4832: from ra_customer_merges m

Line 4830: UPDATE OE_DEF_CONDN_ELEMS a

4826: /* customer level update */
4827: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4828: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4829:
4830: UPDATE OE_DEF_CONDN_ELEMS a
4831: set value_string = (select distinct to_char(m.customer_id)
4832: from ra_customer_merges m
4833: where a.value_string =
4834: to_char(m.duplicate_id)