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_FUNDING_PVT dependencies on OKL_TXL_AP_INV_LNS_B

Line 207: from OKL_TXL_AP_INV_LNS_B ast

203: -- assets request
204: cursor c_fund_asset(p_fund_id OKL_TRX_AP_INVOICES_B.ID%TYPE) is
205: select ast.KLE_ID,
206: ast.AMOUNT
207: from OKL_TXL_AP_INV_LNS_B ast
208: where ast.TAP_ID = p_fund_id;
209:
210:
211: r_khr c_khr%ROWTYPE;

Line 1201: p_fund_line_id IN OKL_TXL_AP_INV_LNS_B.ID%TYPE,

1197: --start:| 21-May-2007 cklee OKLR12B Accounting CR |
1198: p_fund_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE ) IS --,
1199: /*
1200: -- cklee 11.5.10 subsidy
1201: p_fund_line_id IN OKL_TXL_AP_INV_LNS_B.ID%TYPE,
1202: p_subsidy_amt IN NUMBER,
1203: p_sty_id IN NUMBER) IS
1204: */
1205: --end:| 21-May-2007 cklee OKLR12B Accounting CR |

Line 1359: from okl_txl_ap_inv_lns_b txl

1355: -- get sty_id for manual_disb
1356: -- cklee 05/04/2004
1357: Cursor manu_disb( p_fund_id NUMBER) IS
1358: select id, sty_id
1359: from okl_txl_ap_inv_lns_b txl
1360: where txl.tap_id = p_fund_id;
1361:
1362: -- Multi Currency Compliance
1363: CURSOR l_curr_conv_csr( p_khr_id NUMBER ) IS

Line 1380: FROM okl_txl_ap_inv_lns_b tl

1376: --- vpanwar 21/02/2007 Added
1377: --- get the funding line amount based on funding_line_id
1378: CURSOR c_amount(p_fund_line_id NUMBER) IS
1379: SELECT nvl(tl.amount,0)
1380: FROM okl_txl_ap_inv_lns_b tl
1381: WHERE tl.id = p_fund_line_id;
1382: ---- vpanwar 21/02/2007 End
1383:
1384: --start:| 21-May-2007 cklee OKLR12B Accounting CR |

Line 2231: okl_txl_ap_inv_lns_b b

2227: CURSOR c_tot_expense_fund (p_contract_id NUMBER, p_vendor_site_id NUMBER)
2228: IS
2229: select nvl(sum(b.amount),0)
2230: from okl_trx_ap_invoices_b a,
2231: okl_txl_ap_inv_lns_b b
2232: where a.id = b.tap_id
2233: and a.trx_status_code in ('APPROVED', 'PROCESSED')
2234: and a.funding_type_code ='EXPENSE'
2235: and b.amount > 0 --?

Line 2277: okl_txl_ap_inv_lns_b b

2273: CURSOR c_tot_expense_fund (p_contract_id NUMBER)
2274: IS
2275: select nvl(sum(b.amount),0)
2276: from okl_trx_ap_invoices_b a,
2277: okl_txl_ap_inv_lns_b b
2278: where a.id = b.tap_id
2279: and a.trx_status_code in ('APPROVED', 'PROCESSED')
2280: and a.funding_type_code ='EXPENSE'
2281: and b.amount > 0 --?

Line 3363: okl_txl_ap_inv_lns_b b

3359: CURSOR c_curr (p_fund_id NUMBER)
3360: IS
3361: select nvl(sum(b.amount),0)
3362: from okl_trx_ap_invoices_b a,
3363: okl_txl_ap_inv_lns_b b
3364: where a.id = b.tap_id
3365: and b.tap_id = p_fund_id
3366: and a.trx_status_code IN ('ENTERED','SUBMITTED')
3367: ;

Line 5707: from OKL_TXL_AP_INV_LNS_B

5703: --- vpanwar 21/02/2007 Added
5704: --- to get all the funding lines for the funding header
5705: CURSOR funding_line_csr(p_fund_id number) IS
5706: Select id funding_line_id
5707: from OKL_TXL_AP_INV_LNS_B
5708: Where tap_id = p_fund_id;
5709: --- vpanwar 21/02/2007 End
5710:
5711: BEGIN

Line 6116: FROM OKL_TXL_AP_INV_LNS_B

6112:
6113: -- dcshanmu added - 23-Nov-2007 - bug # 6639928 - start
6114: CURSOR c_get_max_line_number(p_tap_id OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
6115: SELECT MAX(LINE_NUMBER)
6116: FROM OKL_TXL_AP_INV_LNS_B
6117: WHERE TAP_ID = P_TAP_ID;
6118:
6119: l_max_line_number NUMBER := 0;
6120: -- dcshanmu added - 23-Nov-2007 - bug # 6639928 - start

Line 6487: from okl_txl_ap_inv_lns_b

6483: --- vpanwar added 28/02/2007 end
6484:
6485: cursor c_sty_id(p_tpl_id number) is
6486: select sty_id
6487: from okl_txl_ap_inv_lns_b
6488: where id = p_tpl_id
6489: ;
6490:
6491: -- smadhava - Bug#5200033 - Added - Start

Line 6709: from okl_txl_ap_inv_lns_b b

6705: where a.FUND_ID = p_fund_id
6706: and a.KLE_AMT > 0
6707: and NOT EXISTS
6708: (select 1
6709: from okl_txl_ap_inv_lns_b b
6710: where a.FUND_ID = b.tap_id
6711: and a.cle_id = b.kle_id)
6712: ;*/
6713: CURSOR c2 (p_fund_id NUMBER)

Line 6727: from okl_txl_ap_inv_lns_b c

6723: WHERE a.chr_id = b.khr_id
6724: AND b.ID = p_fund_id
6725: and NOT EXISTS
6726: (select 1
6727: from okl_txl_ap_inv_lns_b c
6728: where b.ID = c.tap_id
6729: and a.cle_id = c.kle_id)
6730: -- )
6731: --WHERE KLE_AMT > 0

Line 6983: from OKL_TXL_AP_INV_LNS_B

6979: --- vpanwar 21/02/2007 Added
6980: --- to get all the funding lines for the funding header
6981: CURSOR fund_line_csr(p_fund_id number) IS
6982: Select id funding_line_id
6983: from OKL_TXL_AP_INV_LNS_B
6984: Where tap_id = p_fund_id;
6985: --- vpanwar 21/02/2007 End
6986:
6987: BEGIN

Line 7820: okl_txl_ap_inv_lns_b tl

7816: CURSOR c (p_fund_id NUMBER)
7817: IS
7818: SELECT nvl(SUM(tl.amount),0)
7819: FROM okl_trx_ap_invoices_b th,
7820: okl_txl_ap_inv_lns_b tl
7821: WHERE tl.tap_id = th.id
7822: AND th.id = p_fund_id
7823: -- no need for this function. this is used for display at UI site only
7824: -- AND th.TRX_STATUS_CODE NOT IN ('CANCELED', 'ERROR', 'REJECTED')

Line 7927: FROM okl_txl_ap_inv_lns_b t

7923:
7924: CURSOR c (p_fund_id NUMBER, p_kle_id NUMBER)
7925: IS
7926: SELECT 'X'
7927: FROM okl_txl_ap_inv_lns_b t
7928: WHERE t.tap_id = p_fund_id
7929: AND t.kle_id = p_kle_id
7930: ;
7931:

Line 7937: FROM okl_txl_ap_inv_lns_b t

7933: IS
7934:
7935:
7936: SELECT 'X'
7937: FROM okl_txl_ap_inv_lns_b t
7938: WHERE t.tap_id = p_fund_id
7939: AND t.kle_id = p_kle_id
7940:
7941: AND t.id <> p_fund_line_id -- except itself

Line 8510: okl_txl_ap_inv_lns_b subln

8506: -- select nvl(sum(decode(sub.invoice_type, 'CREDIT', -subln.amount, subln.amount)),0)
8507: -- sjalasut, commented the above select as part of OKLR12B disbursements project
8508: select nvl(sum(subln.amount),0)
8509: from okl_trx_ap_invoices_b sub,
8510: okl_txl_ap_inv_lns_b subln
8511: where sub.id = subln.tap_id
8512: and sub.trx_status_code in ('APPROVED', 'PROCESSED')
8513: and sub.funding_type_code = G_MANUAL_DISB
8514: and subln.khr_id = p_contract_id;