APPS.OKL_AM_PARTIES_PVT dependencies on FND_LOOKUPS

Line 483: fnd_lookups lq,

479: pr.rle_code kp_role_code,
480: lk.meaning kp_party_role
481: FROM okc_k_party_roles_b pr,
482: okc_k_headers_b kh,
483: fnd_lookups lq,
484: fnd_lookups lk
485: WHERE pr.id = cp_cpl_id
486: AND kh.id = cp_khr_id
487: AND kh.id = pr.chr_id

Line 484: fnd_lookups lk

480: lk.meaning kp_party_role
481: FROM okc_k_party_roles_b pr,
482: okc_k_headers_b kh,
483: fnd_lookups lq,
484: fnd_lookups lk
485: WHERE pr.id = cp_cpl_id
486: AND kh.id = cp_khr_id
487: AND kh.id = pr.chr_id
488: AND lq.lookup_code = cp_qpt_code

Line 499: fnd_lookups lq

495: cp_qpt_code VARCHAR2) IS
496: SELECT kh.buy_or_sell k_buy_or_sell,
497: lq.meaning qp_party_role
498: FROM okc_k_headers_v kh,
499: fnd_lookups lq
500: WHERE kh.id = cp_khr_id
501: AND lq.lookup_code = cp_qpt_code
502: AND lq.lookup_type = 'OKL_QUOTE_PARTY_TYPE';
503:

Line 1587: fnd_lookups lq,

1583: FROM okl_quote_parties qp,
1584: okc_k_party_roles_b pr,
1585: okl_trx_quotes_b tq,
1586: okc_k_headers_all_b kh,
1587: fnd_lookups lq,
1588: fnd_lookups lk
1589: WHERE qp.qte_id = cp_qte_id
1590: AND qp.qpt_code = NVL (cp_qpt_code, qp.qpt_code)
1591: AND pr.id (+) = qp.cpl_id

Line 1588: fnd_lookups lk

1584: okc_k_party_roles_b pr,
1585: okl_trx_quotes_b tq,
1586: okc_k_headers_all_b kh,
1587: fnd_lookups lq,
1588: fnd_lookups lk
1589: WHERE qp.qte_id = cp_qte_id
1590: AND qp.qpt_code = NVL (cp_qpt_code, qp.qpt_code)
1591: AND pr.id (+) = qp.cpl_id
1592: AND tq.id = qp.qte_id