APPS.OKL_AM_INVOICES_PVT dependencies on OKL_TRX_QUOTES_B

Line 3105: FROM OKL_TRX_QUOTES_B qte

3101: l_transaction_source VARCHAR2(80);
3102: CURSOR c_set_trn_src
3103: IS
3104: SELECT 'TERMINATION_QUOTE' transaction_source
3105: FROM OKL_TRX_QUOTES_B qte
3106: WHERE qte.id = p_quote_id; --akrangan modified for bug 7036873
3107:
3108: BEGIN
3109: IF (is_debug_procedure_on) THEN

Line 3401: FROM okl_trx_quotes_b qte,

3397: qte.currency_conversion_date currency_conversion_date
3398: --PAGARG Bug 4044659 Query inventory org id
3399: ,khr.inv_organization_id inv_organization_id,
3400: qte.art_id -- RRAVIKIR Legal Entity Changes
3401: FROM okl_trx_quotes_b qte,
3402: fnd_lookups flo,
3403: okc_k_headers_b khr
3404: WHERE qte.id = cp_quote_id
3405: AND flo.lookup_type = 'OKL_QUOTE_TYPE'

Line 3463: FROM OKL_TRX_QUOTES_B qte,

3459: QTE.DATE_ACCEPTED DATE_ACCEPTED, -- RMUNJULU 4547765 FUTURE_BILLS_BUG
3460: qte.creation_date creation_date, --SECHAWLA 05-JAN-05 4926740 : added creation_date
3461: chr.inv_organization_id inv_organization_id,
3462: QTE.perdiem_amount -- rmunjulu LOANS_ENHACEMENTS
3463: FROM OKL_TRX_QUOTES_B qte,
3464: OKC_K_HEADERS_B chr
3465: WHERE qte.id = p_quote_id
3466: AND qte.khr_id = chr.id;-- rmunjulu 3985369
3467:

Line 4492: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE DEFAULT NULL;

4488:
4489: --+++++++++++ pagarg +++ Rollover +++++++ Start ++++++++++
4490: -- Following variables are used for creating counter
4491: -- invoices/credit memos for Rollover Quote
4492: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE DEFAULT NULL;
4493: l_qlt_mean fnd_lookups.meaning%TYPE := NULL;
4494: l_roll_allc_pos NUMBER;
4495: l_roll_allc_neg NUMBER;
4496: l_roll_taiv_rec taiv_rec_type;

Line 4510: FROM okl_trx_quotes_b

4506: -- Following cursor retrieves the quote type for the given quote id
4507: CURSOR quote_type_csr (p_quote_id IN NUMBER)
4508: IS
4509: SELECT qtp_code, khr_id
4510: FROM okl_trx_quotes_b
4511: WHERE id = p_quote_id;
4512:
4513: quote_type_rec quote_type_csr%rowtype;
4514:

Line 4545: FROM OKL_TRX_QUOTES_B qte,

4541: qte.khr_id khr_id,
4542: qte.date_effective_from date_eff_from,
4543: qte.date_accepted date_accepted,
4544: chr.inv_organization_id inv_organization_id
4545: FROM OKL_TRX_QUOTES_B qte,
4546: OKC_K_HEADERS_B chr
4547: WHERE qte.id = p_quote_id
4548: AND qte.khr_id = chr.id;
4549:

Line 4594: FROM okl_trx_quotes_b qte,

4590: qte.currency_conversion_type currency_conversion_type,
4591: qte.currency_conversion_rate currency_conversion_rate,
4592: qte.currency_conversion_date currency_conversion_date,
4593: khr.inv_organization_id inv_organization_id
4594: FROM okl_trx_quotes_b qte,
4595: fnd_lookups flo,
4596: okc_k_headers_b khr
4597: WHERE qte.id = cp_quote_id
4598: AND flo.lookup_type = 'OKL_QUOTE_TYPE'