APPS.OE_AR_ACCEPTANCE_GRP dependencies on OE_ORDER_HEADERS

Line 155: FROM oe_order_headers_all

151: x_line_flex_rec.INTERFACE_LINE_CONTEXT := 'ORDER ENTRY';
152:
153: SELECT order_number
154: INTO x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE1
155: FROM oe_order_headers_all
156: WHERE header_id= l_line_rec.header_id;
157:
158: SELECT tt.name
159: INTO x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2

Line 161: oe_order_headers oh

157:
158: SELECT tt.name
159: INTO x_line_flex_rec.INTERFACE_LINE_ATTRIBUTE2
160: FROM oe_transaction_types_tl tt,
161: oe_order_headers oh
162: WHERE tt.language = ( select language_code
163: from fnd_languages
164: where installed_flag = 'B')
165: AND tt.transaction_type_id = oh.order_type_id