APPS.OKS_USAGE_SETTLE_PUB dependencies on OKC_K_LINES_B

Line 15: okc_k_lines_b line

11: CURSOR line_cur (p_chr_id IN NUMBER)
12: IS
13: SELECT line.id, rline.settlement_interval, rline.usage_type,rline.usage_period, line.line_number --Bug 5284103
14: FROM oks_k_lines_b rline,
15: okc_k_lines_b line
16: WHERE line.dnz_chr_id = p_chr_id
17: AND rline.cle_id = line.id
18: AND line.lse_id = 12
19: AND rline.usage_type = 'VRT'

Line 28: FROM OKC_K_LINES_B line,

24: CURSOR subline_cur (p_cle_id IN NUMBER)
25: IS
26: SELECT line.id,rline.minimum_quantity,
27: line.start_date,line.end_date
28: FROM OKC_K_LINES_B line,
29: OKS_K_LINES_B rline
30: WHERE line.cle_id = p_cle_id
31: AND line.lse_id = 13
32: AND rline.cle_id = line.id;

Line 92: ,okc_k_lines_b line

88: SELECT mtl.primary_uom_code
89: FROM Okc_K_items Item
90: ,mtl_system_items_b mtl --Okx_system_items_v mtl
91: ,okc_k_headers_b hdr
92: ,okc_k_lines_b line
93: WHERE item.cle_id = line.id --p_cle_id
94: AND line.id = p_cle_id
95: AND line.dnz_chr_id = hdr.id
96: --AND mtl.id1 = item.object1_id1