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 85: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;

81: l_art_index NUMBER := 0;
82: l_commit_cnt NUMBER := 0;
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: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
86: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
87: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
88: l_header_id okl_trx_ar_invoices_v.id%TYPE;
89: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;

Line 87: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;

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: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
86: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
87: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
88: l_header_id okl_trx_ar_invoices_v.id%TYPE;
89: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
90:
91: -- Bug 4524095 -- make break variables global

Line 89: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;

85: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE := -1;
86: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
87: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
88: l_header_id okl_trx_ar_invoices_v.id%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;

Line 92: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;

88: l_header_id okl_trx_ar_invoices_v.id%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

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

1213: l_legal_entity_id okl_trx_ar_invoices_v.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
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;

Line 3071: okl_txl_ar_inv_lns_v b,

3067:
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

Line 3081: okl_txl_ar_inv_lns_v b,

3077:
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