DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on OE_TRANSACTION_TYPES_TL

Line 5121: oe_transaction_types_tl ott

5117: , ooh.order_number
5118: , ott.name order_type
5119: FROM oe_order_lines ool,
5120: oe_order_headers_all ooh, /* MOAC SQL CHANGE */
5121: oe_transaction_types_tl ott
5122: WHERE ool.line_id = c_line_id
5123: AND ooh.header_id = ool.header_id
5124: AND ott.transaction_type_id = ooh.order_type_id
5125: AND ott.language =

Line 6325: FROM oe_transaction_types_tl tt,

6321: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1 := to_char(p_header_rec.order_number);
6322:
6323: SELECT tt.name
6324: INTO p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE2
6325: FROM oe_transaction_types_tl tt,
6326: oe_order_headers oh
6327: WHERE tt.language = ( select language_code
6328: from fnd_languages
6329: where installed_flag = 'B')