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_PC_VTMPLT_COLS

Line 5155: from oe_pc_vtmplt_cols

5151: )
5152: IS
5153: CURSOR c1 is
5154: select VALIDATION_TMPLT_ID
5155: from oe_pc_vtmplt_cols
5156: where value_string in (select to_char(m.duplicate_site_id)
5157: from ra_customer_merges m
5158: where m.process_flag = 'N'
5159: and m.request_id = req_id

Line 5166: from oe_pc_vtmplt_cols

5162: for update nowait;
5163:
5164: CURSOR c2 is
5165: select VALIDATION_TMPLT_ID
5166: from oe_pc_vtmplt_cols
5167: where value_string in (select to_char(m.duplicate_site_id)
5168: from ra_customer_merges m
5169: where m.process_flag = 'N'
5170: and m.request_id = req_id

Line 5177: from oe_pc_vtmplt_cols

5173: for update nowait;
5174:
5175: CURSOR c4 is
5176: select VALIDATION_TMPLT_ID
5177: from oe_pc_vtmplt_cols
5178: where value_string in (select to_char(m.duplicate_site_id)
5179: from ra_customer_merges m
5180: where m.process_flag = 'N'
5181: and m.request_id = req_id

Line 5188: from oe_pc_vtmplt_cols

5184: for update nowait;
5185:
5186: CURSOR c3 is
5187: select VALIDATION_TMPLT_ID
5188: from oe_pc_vtmplt_cols
5189: where value_string in (select to_char(m.duplicate_id)
5190: from ra_customer_merges m
5191: where m.process_flag = 'N'
5192: and m.request_id = req_id

Line 5203: | oe_pc_vtmplt_cols|

5199: BEGIN
5200: arp_message.set_line( 'OE_CUST_MERGE.Constraints_Merge()+' );
5201:
5202: /*-----------------------------+
5203: | oe_pc_vtmplt_cols|
5204: +-----------------------------*/
5205: /* both customer and site level */
5206:
5207: IF( process_mode = 'LOCK' ) THEN

Line 5210: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );

5206:
5207: IF( process_mode = 'LOCK' ) THEN
5208:
5209: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
5210: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
5211:
5212:
5213: open c1;
5214: close c1;

Line 5249: 'OE_PC_VTMPLT_COLS',

5245: LAST_UPDATED_BY
5246: )
5247: select
5248: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5249: 'OE_PC_VTMPLT_COLS',
5250: m.customer_merge_header_id,
5251: a.validation_tmplt_id,
5252: a.value_string,
5253: to_char(m.customer_site_id),

Line 5261: from OE_PC_VTMPLT_COLS a,

5257: hz_utility_pub.CREATION_DATE,
5258: hz_utility_pub.LAST_UPDATE_LOGIN,
5259: hz_utility_pub.LAST_UPDATE_DATE,
5260: hz_utility_pub.LAST_UPDATED_BY
5261: from OE_PC_VTMPLT_COLS a,
5262: ra_customer_merges m
5263: where a.value_string = to_char(m.duplicate_site_id)
5264: and m.process_flag = 'N'
5265: and m.request_id = req_id

Line 5273: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );

5269: END IF;
5270:
5271: /* site level update */
5272: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5273: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
5274:
5275: UPDATE OE_PC_VTMPLT_COLS a
5276: set value_string = (select distinct to_char(m.customer_site_id)
5277: from ra_customer_merges m

Line 5275: UPDATE OE_PC_VTMPLT_COLS a

5271: /* site level update */
5272: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5273: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
5274:
5275: UPDATE OE_PC_VTMPLT_COLS a
5276: set value_string = (select distinct to_char(m.customer_site_id)
5277: from ra_customer_merges m
5278: where a.value_string =
5279: to_char(m.duplicate_site_id)

Line 5317: 'OE_PC_VTMPLT_COLS',

5313: LAST_UPDATED_BY
5314: )
5315: select
5316: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5317: 'OE_PC_VTMPLT_COLS',
5318: m.customer_merge_header_id,
5319: a.validation_tmplt_id,
5320: a.value_string,
5321: to_char(m.customer_site_id),

Line 5329: from OE_PC_VTMPLT_COLS a,

5325: hz_utility_pub.CREATION_DATE,
5326: hz_utility_pub.LAST_UPDATE_LOGIN,
5327: hz_utility_pub.LAST_UPDATE_DATE,
5328: hz_utility_pub.LAST_UPDATED_BY
5329: from OE_PC_VTMPLT_COLS a,
5330: ra_customer_merges m
5331: where a.value_string = to_char(m.duplicate_site_id)
5332: and m.process_flag = 'N'
5333: and m.request_id = req_id

Line 5341: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );

5337: END IF;
5338:
5339: /* site level update */
5340: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5341: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
5342:
5343: UPDATE OE_PC_VTMPLT_COLS a
5344: set value_string = (select distinct to_char(m.customer_site_id)
5345: from ra_customer_merges m

Line 5343: UPDATE OE_PC_VTMPLT_COLS a

5339: /* site level update */
5340: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5341: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
5342:
5343: UPDATE OE_PC_VTMPLT_COLS a
5344: set value_string = (select distinct to_char(m.customer_site_id)
5345: from ra_customer_merges m
5346: where a.value_string =
5347: to_char(m.duplicate_site_id)

Line 5385: 'OE_PC_VTMPLT_COLS',

5381: LAST_UPDATED_BY
5382: )
5383: select
5384: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5385: 'OE_PC_VTMPLT_COLS',
5386: m.customer_merge_header_id,
5387: a.validation_tmplt_id,
5388: a.value_string,
5389: to_char(m.customer_site_id),

Line 5397: from OE_PC_VTMPLT_COLS a,

5393: hz_utility_pub.CREATION_DATE,
5394: hz_utility_pub.LAST_UPDATE_LOGIN,
5395: hz_utility_pub.LAST_UPDATE_DATE,
5396: hz_utility_pub.LAST_UPDATED_BY
5397: from OE_PC_VTMPLT_COLS a,
5398: ra_customer_merges m
5399: where a.value_string = to_char(m.duplicate_site_id)
5400: and m.process_flag = 'N'
5401: and m.request_id = req_id

Line 5409: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );

5405: END IF;
5406:
5407: /* site level update */
5408: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5409: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
5410:
5411: UPDATE OE_PC_VTMPLT_COLS a
5412: set value_string = (select distinct to_char(m.customer_site_id)
5413: from ra_customer_merges m

Line 5411: UPDATE OE_PC_VTMPLT_COLS a

5407: /* site level update */
5408: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5409: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
5410:
5411: UPDATE OE_PC_VTMPLT_COLS a
5412: set value_string = (select distinct to_char(m.customer_site_id)
5413: from ra_customer_merges m
5414: where a.value_string =
5415: to_char(m.duplicate_site_id)

Line 5454: 'OE_PC_VTMPLT_COLS',

5450: LAST_UPDATED_BY
5451: )
5452: select
5453: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5454: 'OE_PC_VTMPLT_COLS',
5455: m.customer_merge_header_id,
5456: a.validation_tmplt_id,
5457: a.value_string,
5458: to_char(m.customer_id),

Line 5466: from OE_PC_VTMPLT_COLS a,

5462: hz_utility_pub.CREATION_DATE,
5463: hz_utility_pub.LAST_UPDATE_LOGIN,
5464: hz_utility_pub.LAST_UPDATE_DATE,
5465: hz_utility_pub.LAST_UPDATED_BY
5466: from OE_PC_VTMPLT_COLS a,
5467: ra_customer_merges m
5468: where a.value_string = to_char(m.duplicate_id)
5469: and m.process_flag = 'N'
5470: and m.request_id = req_id

Line 5478: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );

5474: END IF;
5475:
5476: /* customer level update */
5477: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5478: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
5479:
5480: UPDATE OE_PC_VTMPLT_COLS a
5481: set value_string = (select distinct to_char(m.customer_id)
5482: from ra_customer_merges m

Line 5480: UPDATE OE_PC_VTMPLT_COLS a

5476: /* customer level update */
5477: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5478: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
5479:
5480: UPDATE OE_PC_VTMPLT_COLS a
5481: set value_string = (select distinct to_char(m.customer_id)
5482: from ra_customer_merges m
5483: where a.value_string =
5484: to_char(m.duplicate_id)