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_DATA_FIX dependencies on OE_ATTACHMENT_RULE_ELEMENTS

Line 2106: from oe_attachment_rule_elements

2102: Process_Mode IN VARCHAR2)
2103: IS
2104: CURSOR c1 is
2105: select RULE_ELEMENT_ID
2106: from oe_attachment_rule_elements
2107: where attribute_value in (select to_char(m.duplicate_site_id)
2108: from ra_customer_merges m
2109: where m.process_flag = 'Y'
2110: and m.request_id = req_id

Line 2117: from oe_attachment_rule_elements

2113: for update nowait;
2114:
2115: CURSOR c2 is
2116: select RULE_ELEMENT_ID
2117: from oe_attachment_rule_elements
2118: where attribute_value in (select to_char(m.duplicate_site_id)
2119: from ra_customer_merges m
2120: where m.process_flag = 'Y'
2121: and m.request_id = req_id

Line 2128: from oe_attachment_rule_elements

2124: for update nowait;
2125:
2126: CURSOR c3 is
2127: select RULE_ELEMENT_ID
2128: from oe_attachment_rule_elements
2129: where attribute_value in (select to_char(m.duplicate_id)
2130: from ra_customer_merges m
2131: where m.process_flag = 'Y'
2132: and m.request_id = req_id

Line 2154: oe_debug_pub.add( 'LOCKING TABLE OE_ATTACHMENT_RULE_ELEMENTS' ) ;

2150: /* both customer and site level */
2151:
2152: IF( process_mode = 'LOCK' ) THEN
2153: IF l_debug_level > 0 THEN
2154: oe_debug_pub.add( 'LOCKING TABLE OE_ATTACHMENT_RULE_ELEMENTS' ) ;
2155: END IF;
2156: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
2157: -- arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
2158:

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

2153: IF l_debug_level > 0 THEN
2154: oe_debug_pub.add( 'LOCKING TABLE OE_ATTACHMENT_RULE_ELEMENTS' ) ;
2155: END IF;
2156: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
2157: -- arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
2158:
2159: open c1;
2160: close c1;
2161:

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

2174: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
2175: END IF;
2176:
2177: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2178: -- arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
2179: IF l_debug_level > 0 THEN
2180: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE SHIP_TO_ORG_ID' ) ;
2181: END IF;
2182: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a

Line 2180: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE SHIP_TO_ORG_ID' ) ;

2176:
2177: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2178: -- arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
2179: IF l_debug_level > 0 THEN
2180: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE SHIP_TO_ORG_ID' ) ;
2181: END IF;
2182: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
2183: set (attribute_value) = (select distinct to_char(m.customer_site_id)
2184: from ra_customer_merges m

Line 2182: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a

2178: -- arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
2179: IF l_debug_level > 0 THEN
2180: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE SHIP_TO_ORG_ID' ) ;
2181: END IF;
2182: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
2183: set (attribute_value) = (select distinct to_char(m.customer_site_id)
2184: from ra_customer_merges m
2185: where a.attribute_value =
2186: to_char(m.duplicate_site_id)

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

2210: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
2211: END IF;
2212:
2213: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2214: -- arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
2215: IF l_debug_level > 0 THEN
2216: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE INVOICE_TO_ORG_ID' ) ;
2217: END IF;
2218: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a

Line 2216: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE INVOICE_TO_ORG_ID' ) ;

2212:
2213: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2214: -- arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
2215: IF l_debug_level > 0 THEN
2216: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE INVOICE_TO_ORG_ID' ) ;
2217: END IF;
2218: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
2219: set (attribute_value) = (select distinct to_char(m.customer_site_id)
2220: from ra_customer_merges m

Line 2218: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a

2214: -- arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
2215: IF l_debug_level > 0 THEN
2216: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE INVOICE_TO_ORG_ID' ) ;
2217: END IF;
2218: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
2219: set (attribute_value) = (select distinct to_char(m.customer_site_id)
2220: from ra_customer_merges m
2221: where a.attribute_value =
2222: to_char(m.duplicate_site_id)

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

2246: IF l_debug_level > 0 THEN
2247: oe_debug_pub.add( 'CUSTOMER LEVEL UPDATE' ) ;
2248: END IF;
2249: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2250: -- arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
2251: IF l_debug_level > 0 THEN
2252: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE SOLD_TO_ORG_ID' ) ;
2253: END IF;
2254:

Line 2252: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE SOLD_TO_ORG_ID' ) ;

2248: END IF;
2249: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2250: -- arp_message.set_token( 'TABLE_NAME', 'OE_ATTACHMENT_RULE_ELEMENTS', FALSE );
2251: IF l_debug_level > 0 THEN
2252: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE SOLD_TO_ORG_ID' ) ;
2253: END IF;
2254:
2255: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
2256: set (attribute_value) = (select distinct to_char(m.customer_id)

Line 2255: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a

2251: IF l_debug_level > 0 THEN
2252: oe_debug_pub.add( 'UPDATING OE_ATTACHMENT_RULE_ELEMENTS.ATTRIBUTE_VALUE FOR ATTRIBUTE_CODE SOLD_TO_ORG_ID' ) ;
2253: END IF;
2254:
2255: UPDATE OE_ATTACHMENT_RULE_ELEMENTS a
2256: set (attribute_value) = (select distinct to_char(m.customer_id)
2257: from ra_customer_merges m
2258: where a.attribute_value =
2259: to_char(m.duplicate_id)