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_TXD_AR_LN_DTLS_V

Line 95: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%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
99: -- Bug 4540379

Line 1280: --l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;

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;
1284:

Line 1281: l_tld_id okl_txd_ar_ln_dtls_v.id%TYPE;

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;
1284:
1285: ------------------------------------------------------------

Line 3262: okl_txd_ar_ln_dtls_v c

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
3266: a.request_id = p_req_id ;

Line 3272: okl_txd_ar_ln_dtls_v c

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
3276: a.request_id = p_req_id ;