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 3908: from oe_def_condn_elems

3904: )
3905: IS
3906: CURSOR c1 is
3907: select CONDITION_ELEMENT_ID
3908: from oe_def_condn_elems
3909: where value_string in (select to_char(m.duplicate_site_id)
3910: from ra_customer_merges m
3911: where m.process_flag = 'N'
3912: and m.request_id = req_id

Line 3919: from oe_def_condn_elems

3915: for update nowait;
3916:
3917: CURSOR c2 is
3918: select CONDITION_ELEMENT_ID
3919: from oe_def_condn_elems
3920: where value_string in (select to_char(m.duplicate_site_id)
3921: from ra_customer_merges m
3922: where m.process_flag = 'N'
3923: and m.request_id = req_id

Line 3930: from oe_def_condn_elems

3926: for update nowait;
3927:
3928: CURSOR c4 is
3929: select CONDITION_ELEMENT_ID
3930: from oe_def_condn_elems
3931: where value_string in (select to_char(m.duplicate_site_id)
3932: from ra_customer_merges m
3933: where m.process_flag = 'N'
3934: and m.request_id = req_id

Line 3941: from oe_def_condn_elems

3937: for update nowait;
3938:
3939: CURSOR c3 is
3940: select CONDITION_ELEMENT_ID
3941: from oe_def_condn_elems
3942: where value_string in (select to_char(m.duplicate_id)
3943: from ra_customer_merges m
3944: where m.process_flag = 'N'
3945: and m.request_id = req_id

Line 4000: | OE_DEF_CONDN_ELEMS|

3996: BEGIN
3997: arp_message.set_line( 'OE_CUST_MERGE.OE_Defaulting_Merge()+' );
3998:
3999: /*-----------------------------+
4000: | OE_DEF_CONDN_ELEMS|
4001: +-----------------------------*/
4002: /* both customer and site level */
4003:
4004: IF( process_mode = 'LOCK' ) THEN

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

4003:
4004: IF( process_mode = 'LOCK' ) THEN
4005:
4006: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
4007: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4008:
4009:
4010: open c1;
4011: close c1;

Line 4057: 'OE_DEF_CONDN_ELEMS',

4053: LAST_UPDATED_BY
4054: )
4055: select
4056: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4057: 'OE_DEF_CONDN_ELEMS',
4058: m.customer_merge_header_id,
4059: a.condition_element_id,
4060: a.value_string,
4061: to_char(m.customer_site_id),

Line 4069: from OE_DEF_CONDN_ELEMS a,

4065: hz_utility_pub.CREATION_DATE,
4066: hz_utility_pub.LAST_UPDATE_LOGIN,
4067: hz_utility_pub.LAST_UPDATE_DATE,
4068: hz_utility_pub.LAST_UPDATED_BY
4069: from OE_DEF_CONDN_ELEMS a,
4070: ra_customer_merges m
4071: where a.value_string = to_char(m.duplicate_site_id)
4072: and m.process_flag = 'N'
4073: and m.request_id = req_id

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

4077: END IF;
4078:
4079: /* site level update */
4080: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4081: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4082:
4083: UPDATE OE_DEF_CONDN_ELEMS a
4084: set value_string = (select distinct to_char(m.customer_site_id)
4085: from ra_customer_merges m

Line 4083: UPDATE OE_DEF_CONDN_ELEMS a

4079: /* site level update */
4080: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4081: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4082:
4083: UPDATE OE_DEF_CONDN_ELEMS a
4084: set value_string = (select distinct to_char(m.customer_site_id)
4085: from ra_customer_merges m
4086: where a.value_string =
4087: to_char(m.duplicate_site_id)

Line 4124: 'OE_DEF_CONDN_ELEMS',

4120: LAST_UPDATED_BY
4121: )
4122: select
4123: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4124: 'OE_DEF_CONDN_ELEMS',
4125: m.customer_merge_header_id,
4126: a.condition_element_id,
4127: a.value_string,
4128: to_char(m.customer_site_id),

Line 4136: from OE_DEF_CONDN_ELEMS a,

4132: hz_utility_pub.CREATION_DATE,
4133: hz_utility_pub.LAST_UPDATE_LOGIN,
4134: hz_utility_pub.LAST_UPDATE_DATE,
4135: hz_utility_pub.LAST_UPDATED_BY
4136: from OE_DEF_CONDN_ELEMS a,
4137: ra_customer_merges m
4138: where a.value_string = to_char(m.duplicate_site_id)
4139: and m.process_flag = 'N'
4140: and m.request_id = req_id

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

4145:
4146:
4147: /* site level update */
4148: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4149: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4150:
4151: UPDATE OE_DEF_CONDN_ELEMS a
4152: set value_string = (select distinct to_char(m.customer_site_id)
4153: from ra_customer_merges m

Line 4151: UPDATE OE_DEF_CONDN_ELEMS a

4147: /* site level update */
4148: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4149: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4150:
4151: UPDATE OE_DEF_CONDN_ELEMS a
4152: set value_string = (select distinct to_char(m.customer_site_id)
4153: from ra_customer_merges m
4154: where a.value_string =
4155: to_char(m.duplicate_site_id)

Line 4193: 'OE_DEF_CONDN_ELEMS',

4189: LAST_UPDATED_BY
4190: )
4191: select
4192: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4193: 'OE_DEF_CONDN_ELEMS',
4194: m.customer_merge_header_id,
4195: a.condition_element_id,
4196: a.value_string,
4197: to_char(m.customer_site_id),

Line 4205: from OE_DEF_CONDN_ELEMS a,

4201: hz_utility_pub.CREATION_DATE,
4202: hz_utility_pub.LAST_UPDATE_LOGIN,
4203: hz_utility_pub.LAST_UPDATE_DATE,
4204: hz_utility_pub.LAST_UPDATED_BY
4205: from OE_DEF_CONDN_ELEMS a,
4206: ra_customer_merges m
4207: where a.value_string = to_char(m.duplicate_site_id)
4208: and m.process_flag = 'N'
4209: and m.request_id = req_id

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

4213: END IF;
4214:
4215: /* site level update */
4216: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4217: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4218:
4219: UPDATE OE_DEF_CONDN_ELEMS a
4220: set value_string = (select distinct to_char(m.customer_site_id)
4221: from ra_customer_merges m

Line 4219: UPDATE OE_DEF_CONDN_ELEMS a

4215: /* site level update */
4216: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4217: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4218:
4219: UPDATE OE_DEF_CONDN_ELEMS a
4220: set value_string = (select distinct to_char(m.customer_site_id)
4221: from ra_customer_merges m
4222: where a.value_string =
4223: to_char(m.duplicate_site_id)

Line 4261: 'OE_DEF_CONDN_ELEMS',

4257: LAST_UPDATED_BY
4258: )
4259: select
4260: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4261: 'OE_DEF_CONDN_ELEMS',
4262: m.customer_merge_header_id,
4263: a.condition_element_id,
4264: a.value_string,
4265: to_char(m.customer_id),

Line 4273: from OE_DEF_CONDN_ELEMS a,

4269: hz_utility_pub.CREATION_DATE,
4270: hz_utility_pub.LAST_UPDATE_LOGIN,
4271: hz_utility_pub.LAST_UPDATE_DATE,
4272: hz_utility_pub.LAST_UPDATED_BY
4273: from OE_DEF_CONDN_ELEMS a,
4274: ra_customer_merges m
4275: where a.value_string = to_char(m.duplicate_id)
4276: and m.process_flag = 'N'
4277: and m.request_id = req_id

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

4281: END IF;
4282:
4283: /* customer level update */
4284: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4285: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4286:
4287: UPDATE OE_DEF_CONDN_ELEMS a
4288: set value_string = (select distinct to_char(m.customer_id)
4289: from ra_customer_merges m

Line 4287: UPDATE OE_DEF_CONDN_ELEMS a

4283: /* customer level update */
4284: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4285: arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
4286:
4287: UPDATE OE_DEF_CONDN_ELEMS a
4288: set value_string = (select distinct to_char(m.customer_id)
4289: from ra_customer_merges m
4290: where a.value_string =
4291: to_char(m.duplicate_id)