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_ATTACHMENT_RULE_ELEMENTS

Line 3621: from oe_attachment_rule_elements

3617: )
3618: IS
3619: CURSOR c1 is
3620: select RULE_ELEMENT_ID
3621: from oe_attachment_rule_elements
3622: where attribute_value in (select to_char(m.duplicate_site_id)
3623: from ra_customer_merges m
3624: where m.process_flag = 'N'
3625: and m.request_id = req_id

Line 3632: from oe_attachment_rule_elements

3628: for update nowait;
3629:
3630: CURSOR c2 is
3631: select RULE_ELEMENT_ID
3632: from oe_attachment_rule_elements
3633: where attribute_value in (select to_char(m.duplicate_site_id)
3634: from ra_customer_merges m
3635: where m.process_flag = 'N'
3636: and m.request_id = req_id

Line 3643: from oe_attachment_rule_elements

3639: for update nowait;
3640:
3641: CURSOR c3 is
3642: select RULE_ELEMENT_ID
3643: from oe_attachment_rule_elements
3644: where attribute_value in (select to_char(m.duplicate_id)
3645: from ra_customer_merges m
3646: where m.process_flag = 'N'
3647: and m.request_id = req_id

Line 3665: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );

3661:
3662: IF( process_mode = 'LOCK' ) THEN
3663:
3664: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
3665: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
3666:
3667: open c1;
3668: close c1;
3669:

Line 3700: 'OE_ATTACHMENT_RULE_ELEMENTS',

3696: LAST_UPDATED_BY
3697: )
3698: select
3699: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3700: 'OE_ATTACHMENT_RULE_ELEMENTS',
3701: m.customer_merge_header_id,
3702: a.rule_element_id,
3703: a.attribute_value,
3704: to_char(m.customer_site_id),

Line 3712: from OE_ATTACHMENT_RULE_ELEMENTS a,

3708: hz_utility_pub.CREATION_DATE,
3709: hz_utility_pub.LAST_UPDATE_LOGIN,
3710: hz_utility_pub.LAST_UPDATE_DATE,
3711: hz_utility_pub.LAST_UPDATED_BY
3712: from OE_ATTACHMENT_RULE_ELEMENTS a,
3713: ra_customer_merges m
3714: where a.attribute_value = to_char(m.duplicate_site_id)
3715: and m.process_flag = 'N'
3716: and m.request_id = req_id

Line 3724: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );

3720: END IF;
3721:
3722: /* site level update */
3723: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3724: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
3725:
3726: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
3727: set (attribute_value) = (select distinct to_char(m.customer_site_id)
3728: from ra_customer_merges m

Line 3726: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a

3722: /* site level update */
3723: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3724: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
3725:
3726: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
3727: set (attribute_value) = (select distinct to_char(m.customer_site_id)
3728: from ra_customer_merges m
3729: where a.attribute_value =
3730: to_char(m.duplicate_site_id)

Line 3768: 'OE_ATTACHMENT_RULE_ELEMENTS',

3764: LAST_UPDATED_BY
3765: )
3766: select
3767: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3768: 'OE_ATTACHMENT_RULE_ELEMENTS',
3769: m.customer_merge_header_id,
3770: a.rule_element_id,
3771: a.attribute_value,
3772: to_char(m.customer_site_id),

Line 3780: from OE_ATTACHMENT_RULE_ELEMENTS a,

3776: hz_utility_pub.CREATION_DATE,
3777: hz_utility_pub.LAST_UPDATE_LOGIN,
3778: hz_utility_pub.LAST_UPDATE_DATE,
3779: hz_utility_pub.LAST_UPDATED_BY
3780: from OE_ATTACHMENT_RULE_ELEMENTS a,
3781: ra_customer_merges m
3782: where a.attribute_value = to_char(m.duplicate_site_id)
3783: and m.process_flag = 'N'
3784: and m.request_id = req_id

Line 3792: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );

3788: END IF;
3789:
3790: /* site level update */
3791: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3792: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
3793:
3794: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
3795: set (attribute_value) = (select distinct to_char(m.customer_site_id)
3796: from ra_customer_merges m

Line 3794: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a

3790: /* site level update */
3791: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3792: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
3793:
3794: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
3795: set (attribute_value) = (select distinct to_char(m.customer_site_id)
3796: from ra_customer_merges m
3797: where a.attribute_value =
3798: to_char(m.duplicate_site_id)

Line 3837: 'OE_ATTACHMENT_RULE_ELEMENTS',

3833: LAST_UPDATED_BY
3834: )
3835: select
3836: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3837: 'OE_ATTACHMENT_RULE_ELEMENTS',
3838: m.customer_merge_header_id,
3839: a.rule_element_id,
3840: a.attribute_value,
3841: to_char(m.customer_site_id),

Line 3849: from OE_ATTACHMENT_RULE_ELEMENTS a,

3845: hz_utility_pub.CREATION_DATE,
3846: hz_utility_pub.LAST_UPDATE_LOGIN,
3847: hz_utility_pub.LAST_UPDATE_DATE,
3848: hz_utility_pub.LAST_UPDATED_BY
3849: from OE_ATTACHMENT_RULE_ELEMENTS a,
3850: ra_customer_merges m
3851: where a.attribute_value = to_char(m.duplicate_site_id)
3852: and m.process_flag = 'N'
3853: and m.request_id = req_id

Line 3861: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );

3857: END IF;
3858:
3859: /* customer level update */
3860: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3861: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
3862:
3863: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
3864: set (attribute_value) = (select distinct to_char(m.customer_id)
3865: from ra_customer_merges m

Line 3863: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a

3859: /* customer level update */
3860: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3861: arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
3862:
3863: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
3864: set (attribute_value) = (select distinct to_char(m.customer_id)
3865: from ra_customer_merges m
3866: where a.attribute_value =
3867: to_char(m.duplicate_id)