DBA Data[Home] [Help]

APPS.OKL_LCKBX_CSH_APP_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 907: FROM okc_k_party_roles_v pr,

903: cp_date_tol IN NUMBER)IS
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'

Line 937: FROM okc_k_party_roles_v pr,

933: SELECT tq.ID quote_id,
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'