APPS.CSI_ORDER_FULFILL_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 5097: FROM mtl_system_items_b msi, oe_order_lines_all eol

5093: --Changes for Bug 12568983
5094: BEGIN
5095: SELECT msi.SHIPPABLE_ITEM_FLAG
5096: INTO l_shippable_item_flag
5097: FROM mtl_system_items_b msi, oe_order_lines_all eol
5098: WHERE msi.ORGANIZATION_ID = eol.SHIP_FROM_ORG_ID
5099: AND msi.INVENTORY_ITEM_ID = p_option_item_id
5100: AND eol.LINE_ID = p_line_id;
5101: EXCEPTION

Line 9536: FROM MTL_SYSTEM_ITEMS_B

9532: -- then we need to update the Order line ID for the Item Instance.
9533: --
9534: SELECT nvl(shippable_item_flag ,'N')
9535: INTO l_shippable_item_flag
9536: FROM MTL_SYSTEM_ITEMS_B
9537: WHERE inventory_item_id = l_order_line_rec.inventory_item_id
9538: AND organization_id = l_order_line_rec.ship_from_org_id;
9539: --
9540: IF l_shippable_item_flag = 'Y' THEN