DBA Data[Home] [Help]

APPS.OE_AR_ACCEPTANCE_GRP dependencies on OE_ORDER_HEADERS

Line 157: FROM oe_order_headers_all

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

Line 163: oe_order_headers oh

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