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 4612: from oe_pc_vtmplt_cols

4608: )
4609: IS
4610: CURSOR c1 is
4611: select VALIDATION_TMPLT_ID
4612: from oe_pc_vtmplt_cols
4613: where value_string in (select to_char(m.duplicate_site_id)
4614: from ra_customer_merges m
4615: where m.process_flag = 'N'
4616: and m.request_id = req_id

Line 4623: from oe_pc_vtmplt_cols

4619: for update nowait;
4620:
4621: CURSOR c2 is
4622: select VALIDATION_TMPLT_ID
4623: from oe_pc_vtmplt_cols
4624: where value_string in (select to_char(m.duplicate_site_id)
4625: from ra_customer_merges m
4626: where m.process_flag = 'N'
4627: and m.request_id = req_id

Line 4634: from oe_pc_vtmplt_cols

4630: for update nowait;
4631:
4632: CURSOR c4 is
4633: select VALIDATION_TMPLT_ID
4634: from oe_pc_vtmplt_cols
4635: where value_string in (select to_char(m.duplicate_site_id)
4636: from ra_customer_merges m
4637: where m.process_flag = 'N'
4638: and m.request_id = req_id

Line 4645: from oe_pc_vtmplt_cols

4641: for update nowait;
4642:
4643: CURSOR c3 is
4644: select VALIDATION_TMPLT_ID
4645: from oe_pc_vtmplt_cols
4646: where value_string in (select to_char(m.duplicate_id)
4647: from ra_customer_merges m
4648: where m.process_flag = 'N'
4649: and m.request_id = req_id

Line 4660: | oe_pc_vtmplt_cols|

4656: BEGIN
4657: arp_message.set_line( 'OE_CUST_MERGE.Constraints_Merge()+' );
4658:
4659: /*-----------------------------+
4660: | oe_pc_vtmplt_cols|
4661: +-----------------------------*/
4662: /* both customer and site level */
4663:
4664: IF( process_mode = 'LOCK' ) THEN

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

4663:
4664: IF( process_mode = 'LOCK' ) THEN
4665:
4666: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
4667: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4668:
4669:
4670: open c1;
4671: close c1;

Line 4706: 'OE_PC_VTMPLT_COLS',

4702: LAST_UPDATED_BY
4703: )
4704: select
4705: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4706: 'OE_PC_VTMPLT_COLS',
4707: m.customer_merge_header_id,
4708: a.validation_tmplt_id,
4709: a.value_string,
4710: to_char(m.customer_site_id),

Line 4718: from OE_PC_VTMPLT_COLS a,

4714: hz_utility_pub.CREATION_DATE,
4715: hz_utility_pub.LAST_UPDATE_LOGIN,
4716: hz_utility_pub.LAST_UPDATE_DATE,
4717: hz_utility_pub.LAST_UPDATED_BY
4718: from OE_PC_VTMPLT_COLS a,
4719: ra_customer_merges m
4720: where a.value_string = to_char(m.duplicate_site_id)
4721: and m.process_flag = 'N'
4722: and m.request_id = req_id

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

4726: END IF;
4727:
4728: /* site level update */
4729: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4730: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4731:
4732: UPDATE OE_PC_VTMPLT_COLS a
4733: set value_string = (select distinct to_char(m.customer_site_id)
4734: from ra_customer_merges m

Line 4732: UPDATE OE_PC_VTMPLT_COLS a

4728: /* site level update */
4729: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4730: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4731:
4732: UPDATE OE_PC_VTMPLT_COLS a
4733: set value_string = (select distinct to_char(m.customer_site_id)
4734: from ra_customer_merges m
4735: where a.value_string =
4736: to_char(m.duplicate_site_id)

Line 4774: 'OE_PC_VTMPLT_COLS',

4770: LAST_UPDATED_BY
4771: )
4772: select
4773: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4774: 'OE_PC_VTMPLT_COLS',
4775: m.customer_merge_header_id,
4776: a.validation_tmplt_id,
4777: a.value_string,
4778: to_char(m.customer_site_id),

Line 4786: from OE_PC_VTMPLT_COLS a,

4782: hz_utility_pub.CREATION_DATE,
4783: hz_utility_pub.LAST_UPDATE_LOGIN,
4784: hz_utility_pub.LAST_UPDATE_DATE,
4785: hz_utility_pub.LAST_UPDATED_BY
4786: from OE_PC_VTMPLT_COLS a,
4787: ra_customer_merges m
4788: where a.value_string = to_char(m.duplicate_site_id)
4789: and m.process_flag = 'N'
4790: and m.request_id = req_id

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

4794: END IF;
4795:
4796: /* site level update */
4797: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4798: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4799:
4800: UPDATE OE_PC_VTMPLT_COLS a
4801: set value_string = (select distinct to_char(m.customer_site_id)
4802: from ra_customer_merges m

Line 4800: UPDATE OE_PC_VTMPLT_COLS a

4796: /* site level update */
4797: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4798: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4799:
4800: UPDATE OE_PC_VTMPLT_COLS a
4801: set value_string = (select distinct to_char(m.customer_site_id)
4802: from ra_customer_merges m
4803: where a.value_string =
4804: to_char(m.duplicate_site_id)

Line 4842: 'OE_PC_VTMPLT_COLS',

4838: LAST_UPDATED_BY
4839: )
4840: select
4841: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4842: 'OE_PC_VTMPLT_COLS',
4843: m.customer_merge_header_id,
4844: a.validation_tmplt_id,
4845: a.value_string,
4846: to_char(m.customer_site_id),

Line 4854: from OE_PC_VTMPLT_COLS a,

4850: hz_utility_pub.CREATION_DATE,
4851: hz_utility_pub.LAST_UPDATE_LOGIN,
4852: hz_utility_pub.LAST_UPDATE_DATE,
4853: hz_utility_pub.LAST_UPDATED_BY
4854: from OE_PC_VTMPLT_COLS a,
4855: ra_customer_merges m
4856: where a.value_string = to_char(m.duplicate_site_id)
4857: and m.process_flag = 'N'
4858: and m.request_id = req_id

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

4862: END IF;
4863:
4864: /* site level update */
4865: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4866: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4867:
4868: UPDATE OE_PC_VTMPLT_COLS a
4869: set value_string = (select distinct to_char(m.customer_site_id)
4870: from ra_customer_merges m

Line 4868: UPDATE OE_PC_VTMPLT_COLS a

4864: /* site level update */
4865: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4866: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4867:
4868: UPDATE OE_PC_VTMPLT_COLS a
4869: set value_string = (select distinct to_char(m.customer_site_id)
4870: from ra_customer_merges m
4871: where a.value_string =
4872: to_char(m.duplicate_site_id)

Line 4911: 'OE_PC_VTMPLT_COLS',

4907: LAST_UPDATED_BY
4908: )
4909: select
4910: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4911: 'OE_PC_VTMPLT_COLS',
4912: m.customer_merge_header_id,
4913: a.validation_tmplt_id,
4914: a.value_string,
4915: to_char(m.customer_id),

Line 4923: from OE_PC_VTMPLT_COLS a,

4919: hz_utility_pub.CREATION_DATE,
4920: hz_utility_pub.LAST_UPDATE_LOGIN,
4921: hz_utility_pub.LAST_UPDATE_DATE,
4922: hz_utility_pub.LAST_UPDATED_BY
4923: from OE_PC_VTMPLT_COLS a,
4924: ra_customer_merges m
4925: where a.value_string = to_char(m.duplicate_id)
4926: and m.process_flag = 'N'
4927: and m.request_id = req_id

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

4931: END IF;
4932:
4933: /* customer level update */
4934: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4935: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4936:
4937: UPDATE OE_PC_VTMPLT_COLS a
4938: set value_string = (select distinct to_char(m.customer_id)
4939: from ra_customer_merges m

Line 4937: UPDATE OE_PC_VTMPLT_COLS a

4933: /* customer level update */
4934: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4935: arp_message.set_token( 'TABLE_NAME', 'OE_PC_VTMPLT_COLS', FALSE );
4936:
4937: UPDATE OE_PC_VTMPLT_COLS a
4938: set value_string = (select distinct to_char(m.customer_id)
4939: from ra_customer_merges m
4940: where a.value_string =
4941: to_char(m.duplicate_id)