DBA Data[Home] [Help]

APPS.GME_MAKE_TO_ORDER_PVT dependencies on OE_TRANSACTION_TYPES_ALL

Line 182: ,oe_transaction_types_all ot

178: SELECT ol.line_number, mtl.segment1,
179: oh.order_number
180: FROM oe_order_headers_all oh
181: ,oe_order_lines_all ol
182: ,oe_transaction_types_all ot
183: ,mtl_system_items mtl
184: WHERE ol.line_id = p_so_line_id
185: and ol.header_id = oh.header_id
186: and oh.order_type_id = ot.transaction_type_id