APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_TXL_QUOTE_LINES_V

Line 979: FROM OKL_TXL_QUOTE_LINES_V TQL,

975: KLE.name asset_name,
976: TQL.id tql_id,
977: TQL.quote_quantity quote_quantity,
978: TQL.asset_quantity asset_quantity
979: FROM OKL_TXL_QUOTE_LINES_V TQL,
980: OKC_K_LINES_V KLE
981: WHERE TQL.qte_id = p_qte_id
982: AND TQL.qlt_code = 'AMCFIA'
983: AND TQL.kle_id = KLE.id;

Line 4634: FROM OKL_TXL_QUOTE_LINES_V TQL

4630: x_return_status OUT NOCOPY VARCHAR2) IS
4631:
4632: CURSOR get_qte_lines_csr ( p_qte_id IN NUMBER) IS
4633: SELECT TQL.kle_id kle_id
4634: FROM OKL_TXL_QUOTE_LINES_V TQL
4635: WHERE TQL.qte_id = p_qte_id
4636: AND TQL.qlt_code = 'AMCFIA';
4637:
4638:

Line 5511: OKL_TXL_QUOTE_LINES_V TQL

5507: SELECT QTE.qst_code,
5508: QTE.id qte_id, -- rmunjulu Sales_Tax_Enhancement
5509: TQL.amount -- rmunjulu Sales_Tax_Enhancement
5510: FROM OKL_TRX_QUOTES_V QTE,
5511: OKL_TXL_QUOTE_LINES_V TQL
5512: WHERE TQL.id = p_tql_id
5513: AND TQL.qte_id = QTE.id;
5514:
5515: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 6380: OKL_TXL_QUOTE_LINES_V TQL

6376: CURSOR get_quote_dtls_csr ( p_tql_id IN NUMBER) IS
6377: SELECT QTE.qst_code,
6378: QTE.id qte_id -- rmunjulu Sales_Tax_Enhancement
6379: FROM OKL_TRX_QUOTES_V QTE,
6380: OKL_TXL_QUOTE_LINES_V TQL
6381: WHERE TQL.id = p_tql_id
6382: AND TQL.qte_id = QTE.id;
6383:
6384: