APPS.CSI_UTL_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 2299: l_bom_item_type mtl_system_items.bom_item_type%TYPE;

2295: p_order_line_rec IN csi_order_ship_pub.order_line_rec)
2296: RETURN BOOLEAN
2297: IS
2298:
2299: l_bom_item_type mtl_system_items.bom_item_type%TYPE;
2300: l_bom_found varchar2(1);
2301: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2302: l_explosion_level number;
2303: l_explode_flag varchar2(3);

Line 6136: mtl_system_items_b c

6132: ---For Shippable and Non-shippable Items--
6133: SELECT a.*
6134: FROM csi_t_txn_line_details a ,
6135: csi_t_transaction_lines b ,
6136: mtl_system_items_b c
6137: WHERE a.transaction_line_id = b.transaction_line_id
6138: AND ((b.source_transaction_table = 'WSH_DELIVERY_DETAILS' AND c.shippable_item_flag = 'Y')
6139: OR (b.source_transaction_table = 'OE_ORDER_LINES_ALL' AND c.shippable_item_flag = 'N'))
6140: AND a.instance_id IS NOT NULL ---meaning it is already processed. or it is Non Source