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 8273: select count(*) into v_count from oe_price_adjustments

8269:
8270: IF l_count = 0 THEN
8271:
8272: --bug 4190357
8273: select count(*) into v_count from oe_price_adjustments
8274: where header_id = p_x_header_rec.header_id
8275: and line_id is null
8276: and substitution_attribute = 'QUALIFIER_ATTRIBUTE11'
8277: and list_line_type_code = 'TSN'

Line 8283: DELETE FROM OE_PRICE_ADJUSTMENTS

8279: IF v_count > 0 THEN
8280: IF l_debug_level > 0 THEN
8281: oe_debug_pub.add('Deleting the header tsn adjustments');
8282: END IF;
8283: DELETE FROM OE_PRICE_ADJUSTMENTS
8284: WHERE HEADER_ID = p_x_header_rec.header_id
8285: AND LIST_LINE_TYPE_CODE = 'TSN'
8286: AND SUBSTITUTION_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE11'
8287: AND MODIFIED_TO = p_x_header_rec.shipping_method_code

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

8330:
8331: --bug 4190357
8332: for i in line_ids(p_x_header_rec.header_id) loop
8333: v_count := 0;
8334: select count(*) into v_count from oe_price_Adjustments
8335: where header_id = p_x_header_rec.header_id
8336: and line_id = i.line_id
8337: and substitution_attribute = 'QUALIFIER_ATTRIBUTE11'
8338: and list_line_type_code = 'TSN';