DBA Data[Home] [Help]

APPS.OKS_SUBSCRIPTION_PVT dependencies on OKC_K_ITEMS

Line 18: okc_k_items KI,

14: Select KL.dnz_chr_id, KL.start_date, NVL(KL.date_terminated - 1,KL.end_date) end_date,
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)

Line 431: okc_k_items KI,

427: Select KL.dnz_chr_id, KL.start_date, NVL(KL.date_terminated - 1,KL.end_date) end_date,
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)

Line 1664: From okc_k_items

1660: x_uom_code OUT NOCOPY VARCHAR2
1661: ) IS
1662: Cursor k_item_cur Is
1663: Select number_of_items, uom_code
1664: From okc_k_items
1665: Where cle_id = p_cle_id;
1666: Cursor subs_hdr Is
1667: Select item_type, frequency
1668: From oks_subscr_header_b