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 3508: fnd_lookups flo,

3504: --PAGARG Bug 4044659 Query inventory org id
3505: ,khr.inv_organization_id inv_organization_id,
3506: qte.art_id -- RRAVIKIR Legal Entity Changes
3507: FROM okl_trx_quotes_b qte,
3508: fnd_lookups flo,
3509: okc_k_headers_b khr
3510: WHERE qte.id = cp_quote_id
3511: AND flo.lookup_type = 'OKL_QUOTE_TYPE'
3512: AND flo.lookup_code = qte.qtp_code

Line 3542: fnd_lookups flo

3538: qlt.qlt_code qlt_code,
3539: flo.meaning description,
3540: qlt.id quote_line_id -- rmunjulu sales_tax_enhancement
3541: FROM okl_txl_quote_lines_b qlt,
3542: fnd_lookups flo
3543: WHERE qlt.qte_id = cp_quote_id
3544: AND qlt.amount NOT IN (G_MISS_NUM, 0)
3545: AND flo.lookup_type = 'OKL_QUOTE_LINE_TYPE'
3546: AND flo.lookup_code = qlt.qlt_code

Line 3577: FROM FND_LOOKUPS fnd

3573:
3574: -- rmunjulu EDAT -- Get the quote line meaning for BILL_ADJST
3575: CURSOR get_qte_ln_meaning_csr IS
3576: SELECT fnd.meaning meaning
3577: FROM FND_LOOKUPS fnd
3578: WHERE fnd.lookup_type = 'OKL_QUOTE_LINE_TYPE'
3579: AND fnd.lookup_code = 'BILL_ADJST';
3580:
3581: l_api_version CONSTANT NUMBER := G_API_VERSION;

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

4602: --+++++++++++ pagarg +++ Rollover +++++++ Start ++++++++++
4603: -- Following variables are used for creating counter
4604: -- invoices/credit memos for Rollover Quote
4605: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE DEFAULT NULL;
4606: l_qlt_mean fnd_lookups.meaning%TYPE := NULL;
4607: l_roll_allc_pos NUMBER;
4608: l_roll_allc_neg NUMBER;
4609: l_roll_taiv_rec taiv_rec_type;
4610: lx_pos_roll_taiv_rec taiv_rec_type;

Line 4632: from fnd_lookups fl

4628: -- Following cursor retrieves the quote type meaning for given qlt_code
4629: CURSOR l_qlt_csr (p_qlt_code IN VARCHAR2)
4630: IS
4631: select fl.meaning
4632: from fnd_lookups fl
4633: where fl.lookup_type = 'OKL_QUOTE_LINE_TYPE'
4634: and fl.lookup_code = p_qlt_code;
4635:
4636: --+++++++++++ pagarg +++ Rollover +++++++ End ++++++++++

Line 4647: FROM FND_LOOKUPS fnd

4643:
4644: -- Get the quote line meaning for BILL_ADJST
4645: CURSOR get_qte_ln_meaning_csr IS
4646: SELECT fnd.meaning meaning
4647: FROM FND_LOOKUPS fnd
4648: WHERE fnd.lookup_type = 'OKL_QUOTE_LINE_TYPE'
4649: AND fnd.lookup_code = 'BILL_ADJST';
4650:
4651: -- get quote details

Line 4708: fnd_lookups flo,

4704: qte.currency_conversion_rate currency_conversion_rate,
4705: qte.currency_conversion_date currency_conversion_date,
4706: khr.inv_organization_id inv_organization_id
4707: FROM okl_trx_quotes_b qte,
4708: fnd_lookups flo,
4709: okc_k_headers_b khr
4710: WHERE qte.id = cp_quote_id
4711: AND flo.lookup_type = 'OKL_QUOTE_TYPE'
4712: AND flo.lookup_code = qte.qtp_code