APPS.OKL_LCKBX_CSH_APP_PVT dependencies on OKL_TRX_QUOTES_V

Line 535: l_quote_id okl_trx_quotes_v.ID%TYPE DEFAULT NULL;

531: l_tolerance okl_cash_allctn_rls.amount_tolerance_percent%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;

Line 538: l_quote_number okl_trx_quotes_v.quote_number%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
541: DEFAULT NULL;
542: l_party_id okx_customer_accounts_v.party_id%TYPE

Line 540: l_quote_date_effective_to okl_trx_quotes_v.date_effective_to%TYPE

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
541: DEFAULT NULL;
542: l_party_id okx_customer_accounts_v.party_id%TYPE
543: DEFAULT NULL;
544: l_err_msg VARCHAR2 (2000);

Line 909: okl_trx_quotes_v tq,

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

Line 939: okl_trx_quotes_v tq,

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