APPS.OKL_UBB_PVT dependencies on OKL_TXL_AR_INV_LNS_V

Line 585: okl_txl_ar_inv_lns_v til,

581: from okl_cnsld_ar_strms_b cnsld,
582: AR_PAYMENT_SCHEDULES_ALL AR,
583: OKL_XTL_SELL_INVS_V XTL,
584: okl_trx_ar_invoices_v tai,
585: okl_txl_ar_inv_lns_v til,
586: okl_txd_ar_ln_dtls_v tld
587: where cnsld.receivables_invoice_id = AR.customer_trx_id
588: and cnsld.khr_id = c_khr_id
589: and cnsld.id = XTL.lsm_id

Line 925: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;

921:
922: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE;
923: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
924: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
925: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
926:
927: l_curr_code okc_k_headers_b.currency_code%TYPE;
928: l_ste_amount okl_strm_elements.amount%type;
929:

Line 931: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;

927: l_curr_code okc_k_headers_b.currency_code%TYPE;
928: l_ste_amount okl_strm_elements.amount%type;
929:
930:
931: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
932: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
933:
934: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
935: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;

Line 935: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;

931: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
932: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
933:
934: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
935: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
936:
937: l_header_id okl_trx_ar_invoices_v.id%TYPE;
938: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
939:

Line 938: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;

934: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
935: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
936:
937: l_header_id okl_trx_ar_invoices_v.id%TYPE;
938: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
939:
940: ------------------------------------------------------------
941: -- Declare variables required by APIs
942: ------------------------------------------------------------