DBA Data[Home] [Help]

APPS.OKL_AM_INVOICES_PVT dependencies on FND_LOOKUPS

Line 108: l_party_role FND_LOOKUPS.meaning%TYPE; -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes

104: l_rgd_id NUMBER;
105: l_party_name VARCHAR2(1000);
106:
107: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE; -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
108: l_party_role FND_LOOKUPS.meaning%TYPE; -- RMUNJULU 29-AUG-03 OKC RULES MIGRATION changes
109:
110: --l_bto_rulv_rec rulv_rec_type; -- Bill To Address Rule
111: l_mth_rulv_rec rulv_rec_type; -- Payment Method Rule
112:

Line 3402: fnd_lookups flo,

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'
3406: AND flo.lookup_code = qte.qtp_code

Line 3436: fnd_lookups flo

3432: qlt.qlt_code qlt_code,
3433: flo.meaning description,
3434: qlt.id quote_line_id -- rmunjulu sales_tax_enhancement
3435: FROM okl_txl_quote_lines_b qlt,
3436: fnd_lookups flo
3437: WHERE qlt.qte_id = cp_quote_id
3438: AND qlt.amount NOT IN (G_MISS_NUM, 0)
3439: AND flo.lookup_type = 'OKL_QUOTE_LINE_TYPE'
3440: AND flo.lookup_code = qlt.qlt_code

Line 3471: FROM FND_LOOKUPS fnd

3467:
3468: -- rmunjulu EDAT -- Get the quote line meaning for BILL_ADJST
3469: CURSOR get_qte_ln_meaning_csr IS
3470: SELECT fnd.meaning meaning
3471: FROM FND_LOOKUPS fnd
3472: WHERE fnd.lookup_type = 'OKL_QUOTE_LINE_TYPE'
3473: AND fnd.lookup_code = 'BILL_ADJST';
3474:
3475: l_api_version CONSTANT NUMBER := G_API_VERSION;

Line 4493: l_qlt_mean fnd_lookups.meaning%TYPE := NULL;

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;
4497: lx_pos_roll_taiv_rec taiv_rec_type;

Line 4519: from fnd_lookups fl

4515: -- Following cursor retrieves the quote type meaning for given qlt_code
4516: CURSOR l_qlt_csr (p_qlt_code IN VARCHAR2)
4517: IS
4518: select fl.meaning
4519: from fnd_lookups fl
4520: where fl.lookup_type = 'OKL_QUOTE_LINE_TYPE'
4521: and fl.lookup_code = p_qlt_code;
4522:
4523: --+++++++++++ pagarg +++ Rollover +++++++ End ++++++++++

Line 4534: FROM FND_LOOKUPS fnd

4530:
4531: -- Get the quote line meaning for BILL_ADJST
4532: CURSOR get_qte_ln_meaning_csr IS
4533: SELECT fnd.meaning meaning
4534: FROM FND_LOOKUPS fnd
4535: WHERE fnd.lookup_type = 'OKL_QUOTE_LINE_TYPE'
4536: AND fnd.lookup_code = 'BILL_ADJST';
4537:
4538: -- get quote details

Line 4595: fnd_lookups flo,

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'
4599: AND flo.lookup_code = qte.qtp_code