APPS.OKL_UBB_INTEGRATION_PVT dependencies on OKC_K_ITEMS

Line 104: okc_k_items cim,

100: SELECT cc.counter_id,
101: cc.uom_code
102: FROM cs_counter_groups csg,
103: cs_counters cc,
104: okc_k_items cim,
105: okc_k_lines_b cle,
106: okc_line_styles_b lse
107: WHERE TO_CHAR(csg.source_object_id) = cim.object1_id1
108: AND cim.cle_id = cle.id

Line 1344: -- from Usage Sub Line ID. Getting the link thru OKC_K_ITEMS.OBJECT1_ID1

1340: ------------------------------------------------------------------------------
1341: -- PROCEDURE get_top_line_id
1342: --
1343: -- This procedure returns TOP line for a contract with USAGE line
1344: -- from Usage Sub Line ID. Getting the link thru OKC_K_ITEMS.OBJECT1_ID1
1345: --
1346: -- Calls:
1347: -- Called By:
1348: -- create_ubb_contract

Line 1368: okc_k_items oki

1364: CURSOR top_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1365: p_link_asset_line_id OKL_K_LINES_FULL_V.ID%TYPE) IS
1366: SELECT oki.object1_id1
1367: FROM okl_k_lines_full_v oklf,
1368: okc_k_items oki
1369: WHERE oklf.id = p_link_asset_line_id
1370: AND oklf.dnz_chr_id = p_chr_id
1371: AND oklf.id = oki.cle_id;
1372:

Line 1445: OKC_K_ITEMS ct_item,

1441: select ct.*
1442: --Bug# 6374869
1443: from --CS_COUNTERS ct,
1444: CSI_COUNTERS_B ct,
1445: OKC_K_ITEMS ct_item,
1446: OKC_K_LINES_B ct_line
1447: where ct.counter_id = to_number(ct_item.object1_id1)
1448: and ct_item.cle_id = ct_line.id
1449: and ct_item.dnz_chr_id = ct_line.dnz_chr_id

Line 2220: FROM okc_k_items_v

2216: p_oks_usage_line_id IN OKC_K_LINES_V.ID%TYPE
2217: ) IS
2218: CURSOR item_csr (p_cle_id NUMBER) IS
2219: SELECT id
2220: FROM okc_k_items_v
2221: WHERE cle_id = p_cle_id
2222: AND dnz_chr_id = p_okl_header_id;
2223: --AND jtot_object1_code = 'OKL_USAGE';
2224: