APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 59: FROM mtl_system_items

55: IF p_inventory_item_id IS NOT NULL THEN
56: BEGIN
57: SELECT 'x'
58: INTO l_dummy
59: FROM mtl_system_items
60: WHERE inventory_item_id = p_inventory_item_id
61: AND organization_id = l_inv_valdn_org_id;
62: -- AND organization_id = cs_std.get_item_valdn_orgzn_id;
63: EXCEPTION

Line 248: from mtl_system_items

244: if p_usage_item_id is not null then
245: begin
246: select 'x'
247: into l_dummy
248: from mtl_system_items
249: where inventory_item_id = p_usage_item_id
250: and organization_id = l_inv_valdn_org_id
251: -- and organization_id = cs_std.get_item_valdn_orgzn_id
252: and usage_item_flag = 'Y';

Line 1152: FROM mtl_system_items_b

1148: /* Check if the item is an EAM item */
1149: BEGIN
1150: SELECT distinct nvl(eam_item_type,0) eam_item_type
1151: INTO l_eam_item_type
1152: FROM mtl_system_items_b
1153: WHERE inventory_item_id = l_inventory_item_id;
1154: EXCEPTION
1155: WHEN NO_DATA_FOUND THEN
1156: l_eam_item_type := 0;