DBA Data[Home] [Help]

APPS.GME_MAKE_TO_ORDER_PVT dependencies on OE_TRANSACTION_TYPES_ALL

Line 167: ,oe_transaction_types_all ot

163: SELECT ol.line_number, mtl.segment1,
164: oh.order_number
165: FROM oe_order_headers_all oh
166: ,oe_order_lines_all ol
167: ,oe_transaction_types_all ot
168: ,mtl_system_items mtl
169: WHERE ol.line_id = p_so_line_id
170: and ol.header_id = oh.header_id
171: and oh.order_type_id = ot.transaction_type_id