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 1330: okc_k_items c

1326: CURSOR get_inv_item_id ( p_fin_asset_line_id NUMBER ) IS
1327: SELECT c.OBJECT1_ID1
1328: FROM okc_k_lines_b a,
1329: okc_line_styles_b b,
1330: okc_k_items c
1331: WHERE a.cle_id = p_fin_asset_line_id
1332: AND b.lty_code = 'ITEM'
1333: AND a.lse_id = b.id
1334: AND a.id = c.cle_id;

Line 1354: okc_k_items cim,

1350: --cim.object1_id2 "#",
1351: csi.install_location_id
1352: , csi.location_id
1353: FROM csi_item_instances csi,
1354: okc_k_items cim,
1355: okc_k_lines_b inst,
1356: okc_k_lines_b ib,
1357: okc_line_styles_b lse
1358: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)

Line 1390: okc_k_items c

1386: CURSOR get_service_inv_csr ( p_cle_id NUMBER ) IS
1387: SELECT c.object1_id1
1388: FROM okc_k_lines_v a,
1389: okc_line_styles_v b,
1390: okc_k_items c
1391: WHERE a.lse_id = b.id
1392: AND b.lty_code = 'SOLD_SERVICE'
1393: AND a.id = p_cle_id
1394: AND c.cle_id = a.id;