DBA Data[Home] [Help]

APPS.CSI_ONT_TXN_PUB dependencies on MTL_SYSTEM_ITEMS

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

21: x_error_message OUT NOCOPY VARCHAR2)
22: IS
23:
24: l_message_id number;
25: l_transactable_flag mtl_system_items_b.mtl_transactions_enabled_flag%TYPE; --bug6140021
26: l_org_id number;
27: l_order_id oe_order_lines_all.header_id%TYPE; --Added for MACD Enhancement
28: l_vld_organization_id number;
29: l_inventory_item_id number;

Line 31: l_shippable_flag mtl_system_items_b.shippable_item_flag%TYPE;

27: l_order_id oe_order_lines_all.header_id%TYPE; --Added for MACD Enhancement
28: l_vld_organization_id number;
29: l_inventory_item_id number;
30: l_line_category_code oe_order_lines_all.line_category_code%TYPE;
31: l_shippable_flag mtl_system_items_b.shippable_item_flag%TYPE;
32: l_ordered_item varchar2(80);
33: l_item_type_code varchar2(30);
34: l_fulfilled_qty number;
35: l_shipped_qty number;

Line 180: FROM mtl_system_items

176: --Code start for bug 6140021--
177: BEGIN
178: SELECT nvl(mtl_transactions_enabled_flag,'N')
179: INTO l_transactable_flag
180: FROM mtl_system_items
181: WHERE inventory_item_id = l_inventory_item_id
182: AND organization_id = l_vld_organization_id;
183: EXCEPTION
184: WHEN no_data_found THEN

Line 200: FROM mtl_system_items

196: -- get the Shippable item flag
197: BEGIN
198: SELECT nvl(shippable_item_flag,'N')
199: INTO l_shippable_flag
200: FROM mtl_system_items
201: WHERE inventory_item_id = l_inventory_item_id
202: AND organization_id = l_vld_organization_id;
203: EXCEPTION
204: WHEN no_data_found THEN