APPS.OKS_SUBSCRIPTION_PVT dependencies on MTL_SYSTEM_ITEMS

Line 19: mtl_system_items MTL

15: KI.number_of_items, KI.uom_code,
16: NVL(MTL.contract_item_type_code,'NON-SUB'), MTL.coverage_schedule_id, MTL.comms_nl_trackable_flag
17: From okc_k_lines_b KL,
18: okc_k_items KI,
19: mtl_system_items MTL
20: Where KL.id = p_cle_id
21: and KI.cle_id = p_cle_id
22: and MTL.inventory_item_id = TO_NUMBER(KI.object1_id1)
23: and MTL.organization_id = TO_NUMBER(KI.object1_id2);

Line 432: mtl_system_items MTL

428: KL.price_negotiated, KI.number_of_items, KI.uom_code,
429: NVL(MTL.contract_item_type_code,'NON-SUB')
430: From okc_k_lines_b KL,
431: okc_k_items KI,
432: mtl_system_items MTL
433: Where KL.id = p_cle_id
434: and KI.cle_id = p_cle_id
435: and MTL.inventory_item_id = TO_NUMBER(KI.object1_id1)
436: and MTL.organization_id = TO_NUMBER(KI.object1_id2);

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

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')