APPS.OKL_LCKBX_CSH_APP_PVT dependencies on OKL_TXL_QUOTE_LINES_V

Line 536: l_quote_amount okl_txl_quote_lines_v.amount%TYPE

532: DEFAULT NULL;
533: l_days_past_quote_valid okl_cash_allctn_rls.days_past_quote_valid_toleranc%TYPE
534: DEFAULT NULL;
535: l_quote_id okl_trx_quotes_v.ID%TYPE DEFAULT NULL;
536: l_quote_amount okl_txl_quote_lines_v.amount%TYPE
537: DEFAULT NULL;
538: l_quote_number okl_trx_quotes_v.quote_number%TYPE
539: DEFAULT NULL;
540: l_quote_date_effective_to okl_trx_quotes_v.date_effective_to%TYPE

Line 910: okl_txl_quote_lines_v tl

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 = '#'
913: AND pr.object1_id1 = cp_cust_id
914: AND qp.cpl_id = pr.id

Line 940: okl_txl_quote_lines_v tl

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 = '#'
943: AND pr.object1_id1 = cp_cust_id
944: AND qp.cpl_id = pr.ID