DBA Data[Home] [Help]

APPS.OKS_SUBSCRIPTION_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 2135: FROM mtl_system_items_b_kfv b,

2131:
2132: FUNCTION get_subscription_qty_OM(p_start_date IN DATE, p_end_date IN DATE, p_ou_id IN NUMBER, p_subscription_template_id IN NUMBER, p_inventory_item_id IN NUMBER )RETURN NUMBER IS
2133: CURSOR get_item_dtls IS
2134: SELECT b.coverage_schedule_id
2135: FROM mtl_system_items_b_kfv b,
2136: mtl_system_items_tl t
2137: WHERE b.inventory_item_id =p_inventory_item_id
2138: AND b.inventory_item_id = t.inventory_item_id
2139: AND b.organization_id = t.organization_id