DBA Data[Home] [Help]

APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 21: from mtl_system_items_kfv

17: IS
18:
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

Line 222: From mtl_system_items_kfv kfv, cs_billing_type_categories cbtc

218:
219: -- Bug 7229344
220: Cursor billing_category IS
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: