APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_TXL_QUOTE_LINES_V

Line 991: FROM OKL_TXL_QUOTE_LINES_V TQL,

987: KLE.name asset_name,
988: TQL.id tql_id,
989: TQL.quote_quantity quote_quantity,
990: TQL.asset_quantity asset_quantity
991: FROM OKL_TXL_QUOTE_LINES_V TQL,
992: OKC_K_LINES_V KLE
993: WHERE TQL.qte_id = p_qte_id
994: AND TQL.qlt_code = 'AMCFIA'
995: AND TQL.kle_id = KLE.id;

Line 4844: FROM OKL_TXL_QUOTE_LINES_V TQL

4840: x_return_status OUT NOCOPY VARCHAR2) IS
4841:
4842: CURSOR get_qte_lines_csr ( p_qte_id IN NUMBER) IS
4843: SELECT TQL.kle_id kle_id
4844: FROM OKL_TXL_QUOTE_LINES_V TQL
4845: WHERE TQL.qte_id = p_qte_id
4846: AND TQL.qlt_code = 'AMCFIA';
4847:
4848:

Line 5721: OKL_TXL_QUOTE_LINES_V TQL

5717: SELECT QTE.qst_code,
5718: QTE.id qte_id, -- rmunjulu Sales_Tax_Enhancement
5719: TQL.amount -- rmunjulu Sales_Tax_Enhancement
5720: FROM OKL_TRX_QUOTES_V QTE,
5721: OKL_TXL_QUOTE_LINES_V TQL
5722: WHERE TQL.id = p_tql_id
5723: AND TQL.qte_id = QTE.id;
5724:
5725: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 6590: OKL_TXL_QUOTE_LINES_V TQL

6586: CURSOR get_quote_dtls_csr ( p_tql_id IN NUMBER) IS
6587: SELECT QTE.qst_code,
6588: QTE.id qte_id -- rmunjulu Sales_Tax_Enhancement
6589: FROM OKL_TRX_QUOTES_V QTE,
6590: OKL_TXL_QUOTE_LINES_V TQL
6591: WHERE TQL.id = p_tql_id
6592: AND TQL.qte_id = QTE.id;
6593:
6594: