19: Cursor uom_csr(p_inventory_item_id number) IS
20: Select primary_uom_code
21: from mtl_system_items_kfv
22: where inventory_item_id = p_inventory_item_id
23: and organization_id = cs_std.get_item_valdn_orgzn_id;
24:
25: BEGIN
26: OPEN uom_csr(p_inventory_item_id);
27: FETCH uom_csr INTO x_unit_of_measure_code;
221: Select cbtc.billing_category, cbtc.billing_type -- Bug 13247672
222: From mtl_system_items_kfv kfv, cs_billing_type_categories cbtc
223: Where kfv.inventory_item_id = p_sbe_record.inventory_item_id
224: and kfv.material_billable_flag = cbtc.billing_type
225: and organization_id = cs_std.get_item_valdn_orgzn_id;
226:
227: Cursor txn_billing_type_csr(p_transaction_type_id number,p_billing_type varchar2) IS
228: Select ctbt.txn_billing_type_id
229: from cs_txn_billing_types ctbt, cs_billing_type_categories cbtc