eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_TXL_AR_INV_LNS_V

Line 87: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;

83: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE := -1;
84: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
85: --Bug# 9690217
86: l_bill_amount okl_trx_ar_invoices_v.amount%TYPE := 0;
87: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
88: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
89: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
90: l_header_id okl_trx_ar_invoices_v.id%TYPE;
91: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;

Line 89: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;

85: --Bug# 9690217
86: l_bill_amount okl_trx_ar_invoices_v.amount%TYPE := 0;
87: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
88: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
89: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
90: l_header_id okl_trx_ar_invoices_v.id%TYPE;
91: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
92:
93: -- Bug 4524095 -- make break variables global

Line 91: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;

87: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
88: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
89: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
90: l_header_id okl_trx_ar_invoices_v.id%TYPE;
91: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
92:
93: -- Bug 4524095 -- make break variables global
94: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
95: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;

Line 94: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;

90: l_header_id okl_trx_ar_invoices_v.id%TYPE;
91: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
92:
93: -- Bug 4524095 -- make break variables global
94: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
95: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
96: -- End Code; Bug 4524095 -- make break variables global
97:
98: -- To enforce commit frequency

Line 1279: --l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;

1275: l_legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
1276: l_x_legal_entity_id okl_ext_sell_invs_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
1277:
1278: -- Bug 4524095
1279: --l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
1280: --l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1281: l_tld_id okl_txd_ar_ln_dtls_v.id%TYPE;
1282: l_xsi_id okl_ext_sell_invs_v.id%TYPE;
1283: l_xls_id okl_xtl_sell_invs_v.id%TYPE;

Line 3261: okl_txl_ar_inv_lns_v b,

3257:
3258: CURSOR txd_cnt_succ_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS
3259: SELECT COUNT(*)
3260: FROM okl_trx_ar_invoices_v a,
3261: okl_txl_ar_inv_lns_v b,
3262: okl_txd_ar_ln_dtls_v c
3263: WHERE a.id = b.tai_id AND
3264: b.id = c.til_id_details AND
3265: a.trx_status_code = p_sts AND

Line 3271: okl_txl_ar_inv_lns_v b,

3267:
3268: CURSOR txd_cnt_err_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS
3269: SELECT COUNT(*)
3270: FROM okl_trx_ar_invoices_v a,
3271: okl_txl_ar_inv_lns_v b,
3272: okl_txd_ar_ln_dtls_v c
3273: WHERE a.id = b.tai_id AND
3274: b.id = c.til_id_details AND
3275: a.trx_status_code = p_sts AND