DBA Data[Home] [Help]

APPS.OKS_SUBSCRIPTION_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 2136: mtl_system_items_tl t

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
2140: AND t.LANGUAGE = USERENV ('LANG')