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_AM_UTIL_PVT dependencies on OKL_TXL_QUOTE_LINES_B

Line 3255: OKL_TXL_QUOTE_LINES_B TQL

3251: QTE.qst_code qst_code,
3252: QTE.qtp_code qtp_code
3253: FROM OKL_TRX_CONTRACTS TCN,
3254: OKL_TRX_QUOTES_B QTE,
3255: OKL_TXL_QUOTE_LINES_B TQL
3256: WHERE TCN.qte_id = QTE.id
3257: AND TQL.qte_id = QTE.id
3258: AND TCN.tcn_type IN ('TMT','ALT' , 'EVG')-- akrangan bug 5354501 fix added 'EVG'
3259: --rkuttiya added for 12.1.1 multi gaap project

Line 3794: l_net_investment okl_txl_quote_lines_b.asset_value%TYPE;

3790: x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER IS
3791:
3792: l_deal_type okl_k_headers.deal_type%TYPE;
3793: l_formula_name VARCHAR2(150) ;
3794: l_net_investment okl_txl_quote_lines_b.asset_value%TYPE;
3795: l_asset_value ak_attributes_vl.attribute_label_long%TYPE;
3796:
3797: --SECHAWLA 09-AUG-05 4304230 : new declarations
3798: l_asset_net_book_value okl_txl_quote_lines_b.asset_value%TYPE;

Line 3798: l_asset_net_book_value okl_txl_quote_lines_b.asset_value%TYPE;

3794: l_net_investment okl_txl_quote_lines_b.asset_value%TYPE;
3795: l_asset_value ak_attributes_vl.attribute_label_long%TYPE;
3796:
3797: --SECHAWLA 09-AUG-05 4304230 : new declarations
3798: l_asset_net_book_value okl_txl_quote_lines_b.asset_value%TYPE;
3799: l_sts_code VARCHAR2(30);
3800:
3801: -- This cursor is used to get the deal type for a contract.
3802: CURSOR l_oklheaders_csr(p_khr_id IN NUMBER) IS

Line 4149: OKL_TXL_QUOTE_LINES_B tql

4145: qte.date_accepted, -- quote acceptance date
4146: nvl(tql.asset_value,0) net_investment -- rmunjulu 4399736
4147: FROM OKL_TRX_CONTRACTS trn,
4148: OKL_TRX_QUOTES_B qte,
4149: OKL_TXL_QUOTE_LINES_B tql
4150: WHERE trn.khr_id = p_khr_id
4151: AND trn.tmt_status_code <> 'CANCELED' --akrangan changed tsu_code to tmt_status_code
4152: AND trn.qte_id = qte.id
4153: --rkuttiya added for 12.1.1 Multi GAAAP Project

Line 4163: FROM OKL_TXL_QUOTE_LINES_B tql

4159:
4160: -- get purchase amount for asset
4161: CURSOR get_purchase_amt_csr (p_qte_id IN NUMBER, p_kle_id IN NUMBER) IS
4162: SELECT tql.amount
4163: FROM OKL_TXL_QUOTE_LINES_B tql
4164: WHERE tql.qte_id = p_qte_id
4165: AND tql.kle_id = p_kle_id
4166: AND tql.qlt_code = 'AMBPOC';
4167: