DBA Data[Home] [Help]

APPS.OKL_AM_CNTRCT_LN_TRMNT_PVT dependencies on OKL_TXL_QUOTE_LINES_V

Line 1303: FROM okl_txl_quote_lines_v tql,

1299: tql.asset_quantity asset_quantity,
1300: tql.ID tql_id,
1301: tql.quote_quantity quote_quantity,
1302: tql.split_kle_name split_kle_name -- RMUNJULU 2757312
1303: FROM okl_txl_quote_lines_v tql,
1304: okc_k_lines_v kle
1305: WHERE tql.qte_id = p_qte_id
1306: AND tql.qlt_code = 'AMCFIA'
1307: AND tql.kle_id = kle.ID;

Line 5123: FROM okl_txl_quote_lines_v tql

5119: p_qte_id IN NUMBER
5120: )
5121: IS
5122: SELECT NVL (tql.amount, 0) amount --SECHAWLA 11-MAR-03 : Added nvl
5123: FROM okl_txl_quote_lines_v tql
5124: WHERE tql.kle_id = p_kle_id
5125: AND tql.qte_id = p_qte_id
5126: AND tql.qlt_code = 'AMBPOC'; -- Purchase Amount
5127: