DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on OE_TRANSACTION_TYPES_TL

Line 4890: oe_transaction_types_tl ott

4886: , ooh.order_number
4887: , ott.name order_type
4888: FROM oe_order_lines ool,
4889: oe_order_headers_all ooh, /* MOAC SQL CHANGE */
4890: oe_transaction_types_tl ott
4891: WHERE ool.line_id = c_line_id
4892: AND ooh.header_id = ool.header_id
4893: AND ott.transaction_type_id = ooh.order_type_id
4894: AND ott.language =

Line 6067: FROM oe_transaction_types_tl tt,

6063: p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1 := to_char(p_header_rec.order_number);
6064:
6065: SELECT tt.name
6066: INTO p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE2
6067: FROM oe_transaction_types_tl tt,
6068: oe_order_headers oh
6069: WHERE tt.language = ( select language_code
6070: from fnd_languages
6071: where installed_flag = 'B')