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_PRICE_ADJ_ATTRIBS

Line 6286: INDEX (A,OE_PRICE_ADJ_ATTRIBS_N2) */

6282: -- For 'Ship To' Qualifier Attribute
6283: --bug6071855
6284: CURSOR c1 IS
6285: SELECT /*+ USE_NL (M A)
6286: INDEX (A,OE_PRICE_ADJ_ATTRIBS_N2) */
6287: a.price_adj_attrib_id ,
6288: decode(a.pricing_attribute, 'QUALIFIER_ATTRIBUTE2',
6289: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
6290: m.customer_merge_id

Line 6292: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A

6288: decode(a.pricing_attribute, 'QUALIFIER_ATTRIBUTE2',
6289: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
6290: m.customer_merge_id
6291: --changed for bug 3196900
6292: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
6293: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A,OE_PRICE_ADJUSTMENTS P,OE_ORDER_HEADERS H
6294: WHERE
6295: a.pricing_context = 'CUSTOMER'
6296: and ((a.pricing_attribute in ('QUALIFIER_ATTRIBUTE11',

Line 6293: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A,OE_PRICE_ADJUSTMENTS P,OE_ORDER_HEADERS H

6289: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
6290: m.customer_merge_id
6291: --changed for bug 3196900
6292: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
6293: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A,OE_PRICE_ADJUSTMENTS P,OE_ORDER_HEADERS H
6294: WHERE
6295: a.pricing_context = 'CUSTOMER'
6296: and ((a.pricing_attribute in ('QUALIFIER_ATTRIBUTE11',
6297: 'QUALIFIER_ATTRIBUTE5',

Line 6313: INDEX (A,OE_PRICE_ADJ_ATTRIBS_N2) */

6309:
6310: --bug6071855
6311: CURSOR c1_2 IS
6312: SELECT /*+ USE_NL (M A)
6313: INDEX (A,OE_PRICE_ADJ_ATTRIBS_N2) */
6314: a.price_adj_attrib_id ,
6315: decode(a.pricing_attribute, 'QUALIFIER_ATTRIBUTE2',
6316: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
6317: m.customer_merge_id

Line 6319: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A

6315: decode(a.pricing_attribute, 'QUALIFIER_ATTRIBUTE2',
6316: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
6317: m.customer_merge_id
6318: --changed for bug 3196900
6319: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
6320: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A , OE_PRICE_ADJUSTMENTS P,
6321: OE_ORDER_HEADERS H
6322: WHERE
6323: a.pricing_context = 'CUSTOMER'

Line 6320: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A , OE_PRICE_ADJUSTMENTS P,

6316: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
6317: m.customer_merge_id
6318: --changed for bug 3196900
6319: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
6320: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A , OE_PRICE_ADJUSTMENTS P,
6321: OE_ORDER_HEADERS H
6322: WHERE
6323: a.pricing_context = 'CUSTOMER'
6324: and ((a.pricing_attribute in ('QUALIFIER_ATTRIBUTE11',

Line 6350: arp_message.set_token( 'TABLE_NAME', 'oe_price_adj_attribs', FALSE );

6346: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs()+' );
6347: IF (process_mode = 'LOCK') THEN
6348:
6349: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
6350: arp_message.set_token( 'TABLE_NAME', 'oe_price_adj_attribs', FALSE );
6351:
6352: open c1;
6353: close c1;
6354:

Line 6388: 'OE_PRICE_ADJ_ATTRIBS',

6384: LAST_UPDATE_DATE,
6385: LAST_UPDATED_BY
6386: ) VALUES (
6387: HZ_CUSTOMER_MERGE_LOG_s.nextval,
6388: 'OE_PRICE_ADJ_ATTRIBS',
6389: MERGE_HEADER_ID_LIST(I),
6390: attrib_id_tab(I),
6391: pricing_attr_value_from_tab(I),
6392: to_char(attrib_value_from_tab(I)),

Line 6406: arp_message.set_token( 'TABLE_NAME', 'oe_price_adj_attribs', FALSE );

6402: END IF;
6403: end if;
6404:
6405: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
6406: arp_message.set_token( 'TABLE_NAME', 'oe_price_adj_attribs', FALSE );
6407:
6408: IF attrib_id_tab.COUNT <> 0 THEN
6409: FORALL i in attrib_id_tab.FIRST..attrib_id_tab.LAST
6410: UPDATE OE_PRICE_ADJ_ATTRIBS S

Line 6410: UPDATE OE_PRICE_ADJ_ATTRIBS S

6406: arp_message.set_token( 'TABLE_NAME', 'oe_price_adj_attribs', FALSE );
6407:
6408: IF attrib_id_tab.COUNT <> 0 THEN
6409: FORALL i in attrib_id_tab.FIRST..attrib_id_tab.LAST
6410: UPDATE OE_PRICE_ADJ_ATTRIBS S
6411: SET pricing_attr_value_from = to_char(attrib_value_from_tab(i)),
6412: last_update_date = sysdate,
6413: last_updated_by = arp_standard.profile.user_id,
6414: last_update_login = arp_standard.profile.last_update_login