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 5705: INDEX (A,OE_PRICE_ADJ_ATTRIBS_N2) */

5701: -- For 'Ship To' Qualifier Attribute
5702: --bug6071855
5703: CURSOR c1 IS
5704: SELECT /*+ USE_NL (M A)
5705: INDEX (A,OE_PRICE_ADJ_ATTRIBS_N2) */
5706: a.price_adj_attrib_id ,
5707: decode(a.pricing_attribute, 'QUALIFIER_ATTRIBUTE2',
5708: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
5709: m.customer_merge_id

Line 5711: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A

5707: decode(a.pricing_attribute, 'QUALIFIER_ATTRIBUTE2',
5708: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
5709: m.customer_merge_id
5710: --changed for bug 3196900
5711: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
5712: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A,OE_PRICE_ADJUSTMENTS P,OE_ORDER_HEADERS H
5713: WHERE
5714: a.pricing_context = 'CUSTOMER'
5715: and ((a.pricing_attribute in ('QUALIFIER_ATTRIBUTE11',

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

5708: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
5709: m.customer_merge_id
5710: --changed for bug 3196900
5711: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
5712: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A,OE_PRICE_ADJUSTMENTS P,OE_ORDER_HEADERS H
5713: WHERE
5714: a.pricing_context = 'CUSTOMER'
5715: and ((a.pricing_attribute in ('QUALIFIER_ATTRIBUTE11',
5716: 'QUALIFIER_ATTRIBUTE5',

Line 5732: INDEX (A,OE_PRICE_ADJ_ATTRIBS_N2) */

5728:
5729: --bug6071855
5730: CURSOR c1_2 IS
5731: SELECT /*+ USE_NL (M A)
5732: INDEX (A,OE_PRICE_ADJ_ATTRIBS_N2) */
5733: a.price_adj_attrib_id ,
5734: decode(a.pricing_attribute, 'QUALIFIER_ATTRIBUTE2',
5735: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
5736: m.customer_merge_id

Line 5738: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A

5734: decode(a.pricing_attribute, 'QUALIFIER_ATTRIBUTE2',
5735: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
5736: m.customer_merge_id
5737: --changed for bug 3196900
5738: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
5739: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A , OE_PRICE_ADJUSTMENTS P,
5740: OE_ORDER_HEADERS H
5741: WHERE
5742: a.pricing_context = 'CUSTOMER'

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

5735: m.customer_id, m.customer_site_id) attrib_value_from, a.pricing_attr_value_from,
5736: m.customer_merge_id
5737: --changed for bug 3196900
5738: -- FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A
5739: FROM RA_CUSTOMER_MERGES M, OE_PRICE_ADJ_ATTRIBS A , OE_PRICE_ADJUSTMENTS P,
5740: OE_ORDER_HEADERS H
5741: WHERE
5742: a.pricing_context = 'CUSTOMER'
5743: and ((a.pricing_attribute in ('QUALIFIER_ATTRIBUTE11',

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

5765: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs()+' );
5766: IF (process_mode = 'LOCK') THEN
5767:
5768: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
5769: arp_message.set_token( 'TABLE_NAME', 'oe_price_adj_attribs', FALSE );
5770:
5771: open c1;
5772: close c1;
5773:

Line 5807: 'OE_PRICE_ADJ_ATTRIBS',

5803: LAST_UPDATE_DATE,
5804: LAST_UPDATED_BY
5805: ) VALUES (
5806: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5807: 'OE_PRICE_ADJ_ATTRIBS',
5808: MERGE_HEADER_ID_LIST(I),
5809: attrib_id_tab(I),
5810: pricing_attr_value_from_tab(I),
5811: to_char(attrib_value_from_tab(I)),

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

5821: END IF;
5822: end if;
5823:
5824: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5825: arp_message.set_token( 'TABLE_NAME', 'oe_price_adj_attribs', FALSE );
5826:
5827: IF attrib_id_tab.COUNT <> 0 THEN
5828: FORALL i in attrib_id_tab.FIRST..attrib_id_tab.LAST
5829: UPDATE OE_PRICE_ADJ_ATTRIBS S

Line 5829: UPDATE OE_PRICE_ADJ_ATTRIBS S

5825: arp_message.set_token( 'TABLE_NAME', 'oe_price_adj_attribs', FALSE );
5826:
5827: IF attrib_id_tab.COUNT <> 0 THEN
5828: FORALL i in attrib_id_tab.FIRST..attrib_id_tab.LAST
5829: UPDATE OE_PRICE_ADJ_ATTRIBS S
5830: SET pricing_attr_value_from = to_char(attrib_value_from_tab(i)),
5831: last_update_date = sysdate,
5832: last_updated_by = arp_standard.profile.user_id,
5833: last_update_login = arp_standard.profile.last_update_login