APPS.OKL_LA_SALES_TAX_PVT dependencies on OKC_K_ITEMS

Line 1721: okc_k_items cim_fee

1717: cim_fee.id cim_fee_id,
1718: cim_fee.object1_id1
1719: FROM okl_k_lines kle_fee,
1720: okc_k_lines_b cleb_fee,
1721: okc_k_items cim_fee
1722: WHERE cleb_fee.id = p_fee_cle_id
1723: AND kle_fee.id = cleb_fee.id
1724: AND cim_fee.cle_id = cleb_fee.id
1725: AND cim_fee.dnz_chr_id = cleb_fee.dnz_chr_id

Line 1749: okc_k_items cim_cov_asset

1745: NVL(kle_cov_asset.capital_amount,kle_cov_asset.amount) amount,
1746: cim_cov_asset.id cim_cov_asset_id
1747: FROM okc_k_lines_b cleb_cov_asset,
1748: okl_k_lines kle_cov_asset,
1749: okc_k_items cim_cov_asset
1750: WHERE cleb_cov_asset.cle_id = p_fee_cle_id
1751: AND cleb_cov_asset.dnz_chr_id = p_chr_id
1752: AND kle_cov_asset.id = cleb_cov_asset.id
1753: AND cim_cov_asset.cle_id = cleb_cov_asset.id

Line 1802: okc_k_items cim_cov_asset,

1798: p_fee_cle_id IN NUMBER) IS
1799: SELECT cleb_cov_asset.id cleb_cov_asset_id,
1800: cim_cov_asset.id cim_cov_asset_id
1801: FROM okc_k_lines_b cleb_cov_asset,
1802: okc_k_items cim_cov_asset,
1803: okc_k_lines_b cleb_fin,
1804: okc_rule_groups_b rgp,
1805: okc_rules_b rul
1806: WHERE cleb_cov_asset.cle_id = p_fee_cle_id

Line 1830: okc_k_items cim_cov_asset,

1826: p_fee_cle_id IN NUMBER) IS
1827: SELECT cleb_cov_asset.id cleb_cov_asset_id,
1828: cim_cov_asset.id cim_cov_asset_id
1829: FROM okc_k_lines_b cleb_cov_asset,
1830: okc_k_items cim_cov_asset,
1831: okc_k_lines_b cleb_fin,
1832: okc_rule_groups_b rgp,
1833: okc_rules_b rul
1834: WHERE cleb_cov_asset.cle_id = p_fee_cle_id

Line 6194: okc_k_items item,

6190: kle.fee_type
6191: FROM okc_k_lines_b fee_line,
6192: okc_k_lines_b cleb,
6193: okl_k_lines kle,
6194: okc_k_items item,
6195: okc_k_lines_tl clet_asset,
6196: okc_line_styles_b sty
6197: WHERE fee_line.id = kle.id
6198: AND kle.FEE_PURPOSE_CODE='SALESTAX'