APPS.CSI_ONT_TXN_PUB dependencies on MTL_SYSTEM_ITEMS

Line 58: l_transactable_flag mtl_system_items_b.mtl_transactions_enabled_flag%TYPE; --bug6140021

54: x_error_message OUT NOCOPY VARCHAR2)
55: IS
56:
57: l_message_id number;
58: l_transactable_flag mtl_system_items_b.mtl_transactions_enabled_flag%TYPE; --bug6140021
59: l_org_id number;
60: l_order_id oe_order_lines_all.header_id%TYPE; --Added for MACD Enhancement
61: l_vld_organization_id number;
62: l_inventory_item_id number;

Line 64: l_shippable_flag mtl_system_items_b.shippable_item_flag%TYPE;

60: l_order_id oe_order_lines_all.header_id%TYPE; --Added for MACD Enhancement
61: l_vld_organization_id number;
62: l_inventory_item_id number;
63: l_line_category_code oe_order_lines_all.line_category_code%TYPE;
64: l_shippable_flag mtl_system_items_b.shippable_item_flag%TYPE;
65: l_ordered_item varchar2(80);
66: l_item_type_code varchar2(30);
67: l_fulfilled_qty number;
68: l_shipped_qty number;

Line 252: FROM mtl_system_items

248: --Code start for bug 6140021--
249: BEGIN
250: SELECT nvl(mtl_transactions_enabled_flag,'N')
251: INTO l_transactable_flag
252: FROM mtl_system_items
253: WHERE inventory_item_id = l_inventory_item_id
254: AND organization_id = l_vld_organization_id;
255: EXCEPTION
256: WHEN no_data_found THEN

Line 272: FROM mtl_system_items

268: -- get the Shippable item flag
269: BEGIN
270: SELECT nvl(shippable_item_flag,'N')
271: INTO l_shippable_flag
272: FROM mtl_system_items
273: WHERE inventory_item_id = l_inventory_item_id
274: AND organization_id = l_vld_organization_id;
275: EXCEPTION
276: WHEN no_data_found THEN