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