DBA Data[Home] [Help]

APPS.OKL_LCKBX_CSH_APP_PVT dependencies on OKL_QUOTE_PARTIES_V

Line 908: okl_quote_parties_v qp,

904: SELECT tq.id quote_id,
905: tq.date_effective_to,
906: SUM(NVL(tl.amount,0)) quote_amount
907: FROM okc_k_party_roles_v pr,
908: okl_quote_parties_v qp,
909: okl_trx_quotes_v tq,
910: okl_txl_quote_lines_v tl
911: WHERE pr.jtot_object1_code = 'OKX_PARTY'
912: AND pr.object1_id2 = '#'

Line 938: okl_quote_parties_v qp,

934: tq.date_effective_to,
935: tq.quote_number,
936: SUM (NVL (tl.amount, 0)) quote_amount
937: FROM okc_k_party_roles_v pr,
938: okl_quote_parties_v qp,
939: okl_trx_quotes_v tq,
940: okl_txl_quote_lines_v tl
941: WHERE pr.jtot_object1_code = 'OKX_PARTY'
942: AND pr.object1_id2 = '#'