APPS.OKL_AM_RESTRUCTURE_QUOTE_PVT dependencies on OKL_TRX_QUOTES_V

Line 353: FROM OKL_TRX_QUOTES_V Q,

349: -- Cursor to get the khr_id for the quote
350: CURSOR k_details_for_qte_csr (p_qte_id IN NUMBER) IS
351: SELECT K.id,
352: K.contract_number
353: FROM OKL_TRX_QUOTES_V Q,
354: OKL_K_HEADERS_FULL_V K
355: WHERE Q.id = p_qte_id
356: AND Q.khr_id = K.id;
357:

Line 693: FROM OKL_TRX_QUOTES_V OTQV,

689: OKHV.contract_number,
690: OTQV.quote_number,
691: OTQV.id qte_id,
692: OTQV.qtp_code
693: FROM OKL_TRX_QUOTES_V OTQV,
694: OKL_K_HEADERS_FULL_V OKHV
695: WHERE OTQV.id = p_id
696: AND OTQV.khr_id = OKHV.id;
697:

Line 1373: FROM OKL_TRX_QUOTES_V QTE

1369: -- RMUNJULU 31-JAN-03 2779255 Added khr_id
1370: CURSOR okl_get_qte_db_vals_csr ( p_qte_id IN NUMBER) IS
1371: SELECT QTE.accepted_yn,
1372: QTE.khr_id
1373: FROM OKL_TRX_QUOTES_V QTE
1374: WHERE QTE.id = p_qte_id;
1375:
1376: lp_quot_rec quot_rec_type := p_quot_rec;
1377: lx_quot_rec quot_rec_type;

Line 1509: p_trx_source_table => 'OKL_TRX_QUOTES_V',

1505:
1506:
1507: -- Save message from stack into transaction message table
1508: OKL_AM_UTIL_PVT.process_messages(
1509: p_trx_source_table => 'OKL_TRX_QUOTES_V',
1510: p_trx_id => lp_quot_rec.id,
1511: x_return_status => l_return_status);
1512:
1513: -- raise exception if error