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 93: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;

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

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

1214: l_x_legal_entity_id okl_ext_sell_invs_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
1215:
1216: -- Bug 4524095
1217: --l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
1218: --l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1219: l_tld_id okl_txd_ar_ln_dtls_v.id%TYPE;
1220: l_xsi_id okl_ext_sell_invs_v.id%TYPE;
1221: l_xls_id okl_xtl_sell_invs_v.id%TYPE;
1222:

Line 1219: l_tld_id okl_txd_ar_ln_dtls_v.id%TYPE;

1215:
1216: -- Bug 4524095
1217: --l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
1218: --l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1219: l_tld_id okl_txd_ar_ln_dtls_v.id%TYPE;
1220: l_xsi_id okl_ext_sell_invs_v.id%TYPE;
1221: l_xls_id okl_xtl_sell_invs_v.id%TYPE;
1222:
1223: ------------------------------------------------------------

Line 3072: okl_txd_ar_ln_dtls_v c

3068: CURSOR txd_cnt_succ_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS
3069: SELECT COUNT(*)
3070: FROM okl_trx_ar_invoices_v a,
3071: okl_txl_ar_inv_lns_v b,
3072: okl_txd_ar_ln_dtls_v c
3073: WHERE a.id = b.tai_id AND
3074: b.id = c.til_id_details AND
3075: a.trx_status_code = p_sts AND
3076: a.request_id = p_req_id ;

Line 3082: okl_txd_ar_ln_dtls_v c

3078: CURSOR txd_cnt_err_csr( p_req_id NUMBER, p_sts VARCHAR2 ) IS
3079: SELECT COUNT(*)
3080: FROM okl_trx_ar_invoices_v a,
3081: okl_txl_ar_inv_lns_v b,
3082: okl_txd_ar_ln_dtls_v c
3083: WHERE a.id = b.tai_id AND
3084: b.id = c.til_id_details AND
3085: a.trx_status_code = p_sts AND
3086: a.request_id = p_req_id ;