APPS.OKL_LA_SALES_TAX_PVT dependencies on OKC_K_ITEMS

Line 1535: okc_k_items cim_fee

1531: cim_fee.id cim_fee_id,
1532: cim_fee.object1_id1
1533: FROM okl_k_lines kle_fee,
1534: okc_k_lines_b cleb_fee,
1535: okc_k_items cim_fee
1536: WHERE cleb_fee.id = p_fee_cle_id
1537: AND kle_fee.id = cleb_fee.id
1538: AND cim_fee.cle_id = cleb_fee.id
1539: AND cim_fee.dnz_chr_id = cleb_fee.dnz_chr_id

Line 1554: okc_k_items cim_cov_asset

1550: NVL(kle_cov_asset.capital_amount,kle_cov_asset.amount) amount,
1551: cim_cov_asset.id cim_cov_asset_id
1552: FROM okc_k_lines_b cleb_cov_asset,
1553: okl_k_lines kle_cov_asset,
1554: okc_k_items cim_cov_asset
1555: WHERE cleb_cov_asset.cle_id = p_fee_cle_id
1556: AND cleb_cov_asset.dnz_chr_id = p_chr_id
1557: AND kle_cov_asset.id = cleb_cov_asset.id
1558: AND cim_cov_asset.cle_id = cleb_cov_asset.id

Line 1607: okc_k_items cim_cov_asset,

1603: p_fee_cle_id IN NUMBER) IS
1604: SELECT cleb_cov_asset.id cleb_cov_asset_id,
1605: cim_cov_asset.id cim_cov_asset_id
1606: FROM okc_k_lines_b cleb_cov_asset,
1607: okc_k_items cim_cov_asset,
1608: okc_k_lines_b cleb_fin,
1609: okc_rule_groups_b rgp,
1610: okc_rules_b rul
1611: WHERE cleb_cov_asset.cle_id = p_fee_cle_id

Line 1635: okc_k_items cim_cov_asset,

1631: p_fee_cle_id IN NUMBER) IS
1632: SELECT cleb_cov_asset.id cleb_cov_asset_id,
1633: cim_cov_asset.id cim_cov_asset_id
1634: FROM okc_k_lines_b cleb_cov_asset,
1635: okc_k_items cim_cov_asset,
1636: okc_k_lines_b cleb_fin,
1637: okc_rule_groups_b rgp,
1638: okc_rules_b rul
1639: WHERE cleb_cov_asset.cle_id = p_fee_cle_id

Line 5798: okc_k_items item,

5794: kle.fee_type
5795: FROM okc_k_lines_b fee_line,
5796: okc_k_lines_b cleb,
5797: okl_k_lines kle,
5798: okc_k_items item,
5799: okc_k_lines_tl clet_asset,
5800: okc_line_styles_b sty
5801: WHERE fee_line.id = kle.id
5802: AND kle.FEE_PURPOSE_CODE='SALESTAX'