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_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_STRM_ELEMENTS

Line 114: OKL_STRM_ELEMENTS SEL,

110: p_rbk_khr_id NUMBER,
111: p_rbk_kle_id NUMBER ) IS
112: SELECT NVL(SUM(SEL.AMOUNT),0)
113: FROM OKL_STREAMS STM,
114: OKL_STRM_ELEMENTS SEL,
115: OKL_STRM_TYPE_V STY
116: WHERE STM.KHR_ID = p_rbk_khr_id
117: AND NVL(STM.KLE_ID,-99) = NVL ( p_rbk_kle_id,-99 )
118: AND STM.STY_ID = STY.ID

Line 827: okl_strm_elements ste,

823: cnsld_id,
824: --ssiruvol Bug 5000886 end
825: oklh.deal_type deal_type
826: FROM
827: okl_strm_elements ste,
828: okl_streams stm,
829: okl_strm_type_v sty,
830: okc_k_headers_b khr,
831: okl_k_headers oklh

Line 881: okl_strm_elements ste,

877: cnsld_id,
878: --ssiruvol Bug 5000886 end
879: khl.deal_type deal_type
880: FROM
881: okl_strm_elements ste,
882: -- Bug 4550607
883: okl_strm_elements ste1,
884: -- End Bug 4550607
885: okl_streams stm,

Line 883: okl_strm_elements ste1,

879: khl.deal_type deal_type
880: FROM
881: okl_strm_elements ste,
882: -- Bug 4550607
883: okl_strm_elements ste1,
884: -- End Bug 4550607
885: okl_streams stm,
886: okl_strm_type_v sty,
887: okc_k_headers_b khr,

Line 1108: proc_sel_id okl_strm_elements.id%TYPE,

1104: tap_id okl_trx_ap_invoices_v.id%TYPE,
1105: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1106: -- xpi_id okl_ext_pay_invs_v.id%TYPE,
1107: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1108: proc_sel_id okl_strm_elements.id%TYPE,
1109: bill_date DATE,
1110: contract_number okc_k_headers_b.contract_number%type,
1111: stream_name okl_strm_type_v.name%type,
1112: amount okl_strm_elements.amount%type,

Line 1112: amount okl_strm_elements.amount%type,

1108: proc_sel_id okl_strm_elements.id%TYPE,
1109: bill_date DATE,
1110: contract_number okc_k_headers_b.contract_number%type,
1111: stream_name okl_strm_type_v.name%type,
1112: amount okl_strm_elements.amount%type,
1113: error_message Varchar2(2000)
1114: );
1115:
1116: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK

Line 1126: proc_sel_id okl_strm_elements.id%TYPE,

1122: tap_id okl_trx_ap_invoices_v.id%TYPE,
1123: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1124: -- xpi_id okl_ext_pay_invs_v.id%TYPE,
1125: -- xlp_id okl_xtl_pay_invs_v.id%TYPE,
1126: proc_sel_id okl_strm_elements.id%TYPE,
1127: bill_date DATE,
1128: contract_number okc_k_headers_b.contract_number%type,
1129: stream_name okl_strm_type_v.name%type,
1130: amount okl_strm_elements.amount%type,

Line 1130: amount okl_strm_elements.amount%type,

1126: proc_sel_id okl_strm_elements.id%TYPE,
1127: bill_date DATE,
1128: contract_number okc_k_headers_b.contract_number%type,
1129: stream_name okl_strm_type_v.name%type,
1130: amount okl_strm_elements.amount%type,
1131: error_message Varchar2(2000)
1132: );
1133:
1134: TYPE tld_err_tbl_type IS TABLE OF tld_err_rec_type

Line 1234: FROM OKL_STRM_ELEMENTS SEL,

1230: -- Get parent sty Id for an SEL_ID
1231: -----------------------------------------------------------------
1232: CURSOR get_parent_sty ( p_ref_sel_id NUMBER ) IS
1233: SELECT STM.STY_ID
1234: FROM OKL_STRM_ELEMENTS SEL,
1235: OKL_STREAMS STM
1236: WHERE SEL.ID = p_ref_sel_id
1237: AND SEL.STM_ID = STM.ID;
1238:

Line 1325: TYPE l_ele_id_tbl_type IS TABLE OF okl_strm_elements.id%TYPE

1321: l_evrgrn_psthrgh_flg NUMBER := 0;
1322: -- end fmiao for bug 4961860
1323:
1324: --ssiruvol Bug 5000886 start
1325: TYPE l_ele_id_tbl_type IS TABLE OF okl_strm_elements.id%TYPE
1326: INDEX BY BINARY_INTEGER;
1327:
1328: strm_ele_idx NUMBER;
1329: inv_ele_idx NUMBER;

Line 1344: proc_sel_id okl_strm_elements.id%TYPE,

1340: tap_id okl_trx_ap_invoices_v.id%TYPE,
1341: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1342: xpi_id okl_ext_pay_invs_v.id%TYPE,
1343: xlp_id okl_xtl_pay_invs_v.id%TYPE,
1344: proc_sel_id okl_strm_elements.id%TYPE,
1345: bill_date DATE,
1346: contract_number okc_k_headers_b.contract_number%type,
1347: stream_name okl_strm_type_v.name%type,
1348: amount okl_strm_elements.amount%type,

Line 1348: amount okl_strm_elements.amount%type,

1344: proc_sel_id okl_strm_elements.id%TYPE,
1345: bill_date DATE,
1346: contract_number okc_k_headers_b.contract_number%type,
1347: stream_name okl_strm_type_v.name%type,
1348: amount okl_strm_elements.amount%type,
1349: error_message Varchar2(2000)
1350: );
1351:
1352: TYPE lsm_succ_tbl_type IS TABLE OF lsm_succ_rec_type

Line 2252: UPDATE okl_strm_elements

2248: (inv_disb_rec.ref_sel_id IS NULL) THEN
2249:
2250: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 43.1 ### ');
2251: --ssiruvol Bug 5000886 start
2252: UPDATE okl_strm_elements
2253: SET date_billed = SYSDATE
2254: WHERE id = tld_succ_log_table(i).proc_sel_id;
2255:
2256: UPDATE OKL_TXD_AR_LN_DTLS_B

Line 2273: UPDATE okl_strm_elements

2269: -- IF (check_rcpts( inv_disb_rec.ref_sel_id ) = 'FULL') THEN
2270: IF (check_rcpts( inv_disb_rec.cnsld_id ) = 'FULL') THEN
2271: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 43.3 ### ');
2272:
2273: UPDATE okl_strm_elements
2274: SET date_billed = SYSDATE
2275: WHERE id = tld_succ_log_table(i).proc_sel_id;
2276:
2277: UPDATE OKL_TXD_AR_LN_DTLS_B

Line 2321: UPDATE okl_strm_elements

2317: IF l_commit_cnt > l_MAX_commit_cnt THEN
2318: --ssiruvol Bug 5000886 start
2319: IF l_strm_ele_id_tbl.COUNT > 0 THEN
2320: FORALL indx in l_strm_ele_id_tbl.FIRST .. l_strm_ele_id_tbl.LAST
2321: UPDATE okl_strm_elements
2322: SET date_billed = SYSDATE--l_date_billed_tbl(indx);
2323: WHERE id = l_strm_ele_id_tbl(indx);
2324: l_strm_ele_id_tbl:=l_temp_ele_id_tbl;
2325: strm_ele_idx:=1;

Line 2357: UPDATE okl_strm_elements

2353:
2354: --ssiruvol Bug 5000886 start
2355: IF l_strm_ele_id_tbl.COUNT > 0 THEN
2356: FORALL indx in l_strm_ele_id_tbl.FIRST .. l_strm_ele_id_tbl.LAST
2357: UPDATE okl_strm_elements
2358: SET date_billed = SYSDATE
2359: WHERE id = l_strm_ele_id_tbl(indx);
2360: l_strm_ele_id_tbl:=l_temp_ele_id_tbl;
2361: strm_ele_idx:=1;