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_HEADER_UTIL dependencies on OE_PRICE_ADJUSTMENTS

Line 8459: select count(*) into v_count from oe_price_adjustments

8455:
8456: IF l_count = 0 THEN
8457:
8458: --bug 4190357
8459: select count(*) into v_count from oe_price_adjustments
8460: where header_id = p_x_header_rec.header_id
8461: and line_id is null
8462: and substitution_attribute = 'QUALIFIER_ATTRIBUTE11'
8463: and list_line_type_code = 'TSN'

Line 8469: DELETE FROM OE_PRICE_ADJUSTMENTS

8465: IF v_count > 0 THEN
8466: IF l_debug_level > 0 THEN
8467: oe_debug_pub.add('Deleting the header tsn adjustments');
8468: END IF;
8469: DELETE FROM OE_PRICE_ADJUSTMENTS
8470: WHERE HEADER_ID = p_x_header_rec.header_id
8471: AND LIST_LINE_TYPE_CODE = 'TSN'
8472: AND SUBSTITUTION_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE11'
8473: AND MODIFIED_TO = p_x_header_rec.shipping_method_code

Line 8522: select count(*) into v_count from oe_price_Adjustments

8518:
8519: --bug 4190357
8520: for i in line_ids(p_x_header_rec.header_id) loop
8521: v_count := 0;
8522: select count(*) into v_count from oe_price_Adjustments
8523: where header_id = p_x_header_rec.header_id
8524: and line_id = i.line_id
8525: and substitution_attribute = 'QUALIFIER_ATTRIBUTE11'
8526: and list_line_type_code = 'TSN';