APPS.OKL_ARINTF_PVT dependencies on OKC_K_ITEMS

Line 99: , okc_k_items item

95: UNION
96: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
97: FROM okc_k_headers_b khr
98: , okc_k_lines_b cle
99: , okc_k_items item
100: , okc_k_lines_b linked_asset
101: , okx_cust_site_uses_v cs
102: , hz_customer_profiles cp
103: WHERE khr.id = p_khr_id

Line 124: , okc_k_items_v item

120: rgp.dnz_chr_id = p_khr_id
121: UNION
122: SELECT rul.object1_id1
123: FROM okc_k_lines_b cle
124: , okc_k_items_v item
125: , okc_k_lines_b linked_asset
126: , OKC_RULES_B rul
127: , Okc_rule_groups_B rgp
128: WHERE cle.dnz_chr_id = p_khr_id AND

Line 164: , okc_k_items_v item

160: rgp.dnz_chr_id = p_khr_id
161: UNION
162: SELECT rul.object1_id1
163: FROM okc_k_lines_b cle
164: , okc_k_items_v item
165: , okc_k_lines_b linked_asset
166: , OKC_RULES_B rul
167: , Okc_rule_groups_B rgp
168: WHERE cle.dnz_chr_id = p_khr_id AND

Line 2296: okc_k_items c

2292: CURSOR get_inv_item_id ( p_fin_asset_line_id NUMBER ) IS
2293: SELECT c.OBJECT1_ID1
2294: FROM okc_k_lines_b a,
2295: okc_line_styles_b b,
2296: okc_k_items c
2297: WHERE a.cle_id = p_fin_asset_line_id
2298: AND b.lty_code = 'ITEM'
2299: AND a.lse_id = b.id
2300: AND a.id = c.cle_id;

Line 2320: okc_k_items cim,

2316: --cim.object1_id2 "#",
2317: csi.install_location_id
2318: , csi.location_id
2319: FROM csi_item_instances csi,
2320: okc_k_items cim,
2321: okc_k_lines_b inst,
2322: okc_k_lines_b ib,
2323: okc_line_styles_b lse
2324: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)

Line 2356: okc_k_items c

2352: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
2353: SELECT c.object1_id1
2354: FROM okc_k_lines_v a,
2355: okc_line_styles_v b,
2356: okc_k_items c
2357: WHERE a.lse_id = b.id
2358: AND b.lty_code = 'SOLD_SERVICE'
2359: AND a.id = p_cle_id
2360: AND c.cle_id = a.id;