DBA Data[Home] [Help]

APPS.OKL_UBB_PVT dependencies on OKL_TXL_AR_INV_LNS_V

Line 672: okl_txl_ar_inv_lns_v til,

668: from okl_cnsld_ar_strms_b cnsld,
669: AR_PAYMENT_SCHEDULES_ALL AR,
670: OKL_XTL_SELL_INVS_V XTL,
671: okl_trx_ar_invoices_v tai,
672: okl_txl_ar_inv_lns_v til,
673: okl_txd_ar_ln_dtls_v tld
674: where cnsld.receivables_invoice_id = AR.customer_trx_id
675: and cnsld.khr_id = c_khr_id
676: and cnsld.id = XTL.lsm_id

Line 1012: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;

1008:
1009: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE;
1010: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
1011: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1012: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
1013:
1014: l_curr_code okc_k_headers_b.currency_code%TYPE;
1015: l_ste_amount okl_strm_elements.amount%type;
1016:

Line 1018: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;

1014: l_curr_code okc_k_headers_b.currency_code%TYPE;
1015: l_ste_amount okl_strm_elements.amount%type;
1016:
1017:
1018: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
1019: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1020:
1021: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
1022: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;

Line 1022: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;

1018: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
1019: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1020:
1021: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
1022: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
1023:
1024: l_header_id okl_trx_ar_invoices_v.id%TYPE;
1025: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
1026:

Line 1025: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;

1021: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
1022: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
1023:
1024: l_header_id okl_trx_ar_invoices_v.id%TYPE;
1025: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
1026:
1027: ------------------------------------------------------------
1028: -- Declare variables required by APIs
1029: ------------------------------------------------------------