DBA Data[Home] [Help]

APPS.OKL_AM_QUOTES_WF dependencies on FND_LOOKUPS

Line 1793: FND_LOOKUPS FNDV

1789: OKPB.object1_id1 party_id
1790: FROM OKC_K_PARTY_ROLES_B OKPB,
1791: OKC_K_LINES_B OKLB,
1792: OKC_LINE_STYLES_B OLSB,
1793: FND_LOOKUPS FNDV
1794: WHERE OKLB.chr_id = p_khr_id
1795: AND OKLB.id > NVL(p_current_rec_id,0)
1796: AND OKPB.dnz_chr_id = OKLB.dnz_chr_id
1797: AND OKPB.cle_id = OKLB.id

Line 3643: fnd_lookups flo

3639: -- Returns Quote Line which needs invoice creation
3640: CURSOR l_qlt_csr (p_qte_id IN NUMBER) IS
3641: SELECT qlt.kle_id kle_id
3642: FROM okl_txl_quote_lines_b qlt,
3643: fnd_lookups flo
3644: WHERE qlt.qte_id = p_qte_id
3645: AND qlt.amount NOT IN (OKL_API.G_MISS_NUM, 0)
3646: AND flo.lookup_type = 'OKL_QUOTE_LINE_TYPE'
3647: AND flo.lookup_code = qlt.qlt_code

Line 3660: fnd_lookups flo

3656: -- as it is not billed as part of partial termination quote
3657: CURSOR l_partial_qlt_csr (p_qte_id IN NUMBER) IS
3658: SELECT qlt.kle_id kle_id
3659: FROM okl_txl_quote_lines_b qlt,
3660: fnd_lookups flo
3661: WHERE qlt.qte_id = p_qte_id
3662: AND qlt.amount NOT IN (OKL_API.G_MISS_NUM, 0)
3663: AND flo.lookup_type = 'OKL_QUOTE_LINE_TYPE'
3664: AND flo.lookup_code = qlt.qlt_code