1238: oe_order_lines_all sl_child,
1239: oe_order_lines_all sl_parent,
1240: oe_order_headers_all sh,
1241: mtl_parameters mp, /* INVCONV umoogala 17-oct-2004 */
1242: cst_revenue_cogs_match_lines crcml
1243: WHERE cr.build_id = l_build_id
1244: AND (mmt.transaction_source_type_id in (2,8) -- dropship
1245: OR mmt.transaction_action_id = 9)
1246: AND transaction_action_id <> 28