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_HOLD_SOURCES

Line 5527: from oe_hold_sources

5523: )
5524: IS
5525: CURSOR c1 is
5526: select hold_source_id
5527: from oe_hold_sources
5528: where hold_entity_id in (select m.duplicate_site_id
5529: from ra_customer_merges m
5530: where m.process_flag = 'N'
5531: and m.request_id = req_id

Line 5538: from oe_hold_sources

5534: for update nowait;
5535:
5536: CURSOR c2 is
5537: select hold_source_id
5538: from oe_hold_sources
5539: where hold_entity_id in (select m.duplicate_site_id
5540: from ra_customer_merges m
5541: where m.process_flag = 'N'
5542: and m.request_id = req_id

Line 5550: from oe_hold_sources

5546:
5547:
5548: CURSOR c3 is
5549: select hold_source_id
5550: from oe_hold_sources
5551: where hold_entity_id in (select m.duplicate_id
5552: from ra_customer_merges m
5553: where m.process_flag = 'N'
5554: and m.request_id = req_id

Line 5565: | OE_HOLD_SOURCES |

5561: BEGIN
5562:
5563: arp_message.set_line( 'OE_CUST_MERGE.OE_Hold_Merge()+' );
5564: /*-----------------------------+
5565: | OE_HOLD_SOURCES |
5566: +-----------------------------*/
5567: /* both customer and site level */
5568:
5569: IF( process_mode = 'LOCK' ) THEN

Line 5572: arp_message.set_token( 'TABLE_NAME', 'OE_HOLD_SOURCES', FALSE );

5568:
5569: IF( process_mode = 'LOCK' ) THEN
5570:
5571: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
5572: arp_message.set_token( 'TABLE_NAME', 'OE_HOLD_SOURCES', FALSE );
5573:
5574: open c1;
5575: close c1;
5576:

Line 5606: 'OE_HOLD_SOURCES',

5602: LAST_UPDATED_BY
5603: )
5604: select
5605: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5606: 'OE_HOLD_SOURCES',
5607: m.customer_merge_header_id,
5608: a.hold_source_id,
5609: to_char(a.hold_entity_id),
5610: to_char(m.customer_site_id),

Line 5618: from OE_HOLD_SOURCES a,

5614: hz_utility_pub.CREATION_DATE,
5615: hz_utility_pub.LAST_UPDATE_LOGIN,
5616: hz_utility_pub.LAST_UPDATE_DATE,
5617: hz_utility_pub.LAST_UPDATED_BY
5618: from OE_HOLD_SOURCES a,
5619: ra_customer_merges m
5620: where a.hold_entity_id = to_char(m.duplicate_site_id)
5621: and m.process_flag = 'N'
5622: and m.request_id = req_id

Line 5630: arp_message.set_token( 'TABLE_NAME', 'OE_HOLD_SOURCES', FALSE );

5626: END IF;
5627:
5628: /* site level update */
5629: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5630: arp_message.set_token( 'TABLE_NAME', 'OE_HOLD_SOURCES', FALSE );
5631:
5632: UPDATE OE_HOLD_SOURCES a
5633: set (hold_entity_id) = (select distinct to_char(m.customer_site_id) --Bug 8866783
5634: from ra_customer_merges m

Line 5632: UPDATE OE_HOLD_SOURCES a

5628: /* site level update */
5629: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5630: arp_message.set_token( 'TABLE_NAME', 'OE_HOLD_SOURCES', FALSE );
5631:
5632: UPDATE OE_HOLD_SOURCES a
5633: set (hold_entity_id) = (select distinct to_char(m.customer_site_id) --Bug 8866783
5634: from ra_customer_merges m
5635: where a.hold_entity_id =
5636: m.duplicate_site_id

Line 5674: 'OE_HOLD_SOURCES',

5670: LAST_UPDATED_BY
5671: )
5672: select
5673: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5674: 'OE_HOLD_SOURCES',
5675: m.customer_merge_header_id,
5676: a.hold_source_id,
5677: to_char(a.hold_entity_id),
5678: to_char(m.customer_site_id),

Line 5686: from OE_HOLD_SOURCES a,

5682: hz_utility_pub.CREATION_DATE,
5683: hz_utility_pub.LAST_UPDATE_LOGIN,
5684: hz_utility_pub.LAST_UPDATE_DATE,
5685: hz_utility_pub.LAST_UPDATED_BY
5686: from OE_HOLD_SOURCES a,
5687: ra_customer_merges m
5688: where a.hold_entity_id = to_char(m.duplicate_site_id)
5689: and m.process_flag = 'N'
5690: and m.request_id = req_id

Line 5701: UPDATE OE_HOLD_SOURCES a

5697: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5698: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
5699: oe_debug_pub.add('ER 3095805 Updating Bill To Site 1');
5700:
5701: UPDATE OE_HOLD_SOURCES a
5702: set (hold_entity_id) = (select distinct to_char(m.customer_site_id) --Bug 8866783
5703: from ra_customer_merges m
5704: where a.hold_entity_id =
5705:

Line 5745: 'OE_HOLD_SOURCES',

5741: LAST_UPDATED_BY
5742: )
5743: select
5744: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5745: 'OE_HOLD_SOURCES',
5746: m.customer_merge_header_id,
5747: a.hold_source_id,
5748: to_char(a.hold_entity_id),
5749: to_char(m.customer_id),

Line 5757: from OE_HOLD_SOURCES a,

5753: hz_utility_pub.CREATION_DATE,
5754: hz_utility_pub.LAST_UPDATE_LOGIN,
5755: hz_utility_pub.LAST_UPDATE_DATE,
5756: hz_utility_pub.LAST_UPDATED_BY
5757: from OE_HOLD_SOURCES a,
5758: ra_customer_merges m
5759: where a.hold_entity_id = to_char(m.duplicate_id)
5760: and m.process_flag = 'N'
5761: and m.request_id = req_id

Line 5772: UPDATE OE_HOLD_SOURCES a

5768: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5769: arp_message.set_token( 'TABLE_NAME', 'SO_HOLD_SOURCES', FALSE );
5770: oe_debug_pub.add('ER 3095805 Updating Acc');
5771:
5772: UPDATE OE_HOLD_SOURCES a
5773: set hold_entity_id = (select distinct to_char(m.customer_id) --Bug 8866783
5774: from ra_customer_merges m
5775: where a.hold_entity_id =
5776: m.duplicate_id