eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_CASH_FLOWS

Line 15743: FROM OKL_ASSETS_B ast, okl_cash_flow_objects cfo, okl_cash_flows caf, okl_cash_flow_levels cfl

15739: -- Get the quote and asset level cash flows for a sales quote
15740: CURSOR l_q_asset_cashflows_csr(cp_quote_id IN NUMBER) IS
15741: SELECT cfo.source_id , ast.asset_number, caf.sty_id,
15742: sum(nvl((cfl.amount * cfl.number_of_periods),0) + nvl(cfl.stub_amount,0)) taxable_basis
15743: FROM OKL_ASSETS_B ast, okl_cash_flow_objects cfo, okl_cash_flows caf, okl_cash_flow_levels cfl
15744: WHERE AST.PARENT_OBJECT_CODE = 'LEASEQUOTE'
15745: AND AST.PARENT_OBJECT_ID = cp_quote_id
15746: AND ast.id = cfo.source_id
15747: AND cfo.oty_code = 'QUOTED_ASSET'

Line 15757: FROM okl_cash_flow_objects cfo, okl_cash_flows caf, okl_cash_flow_levels cfl

15753: GROUP BY cfo.source_id , ast.asset_number, caf.sty_id
15754: UNION
15755: SELECT cfo.source_id , null, caf.sty_id,
15756: sum(nvl((cfl.amount * cfl.number_of_periods),0) + nvl(cfl.stub_amount,0)) taxable_basis
15757: FROM okl_cash_flow_objects cfo, okl_cash_flows caf, okl_cash_flow_levels cfl
15758: WHERE cfo.oty_code = 'LEASE_QUOTE'
15759: AND cfo.source_table = 'OKL_LEASE_QUOTES_B'
15760: AND cfo.source_id = cp_quote_id
15761: AND cfo.id = caf.cfo_id