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_PAY_INVOICES_TRANS_PVT dependencies on OKL_TXL_AP_INV_LNS_ALL_B

Line 65: -- sjalasut, modified code to refer khr_id from okl_txl_ap_inv_lns_all_b instead of okl_trx_ap_invoices_b

61: SELECT taxable_yn
62: FROM okl_txl_ap_inv_lns_b
63: WHERE id = p_tpl_id;
64:
65: -- sjalasut, modified code to refer khr_id from okl_txl_ap_inv_lns_all_b instead of okl_trx_ap_invoices_b
66: -- changes made as part of OKLR12B disbursements project
67: CURSOR c_num_csr ( p_id NUMBER ) IS
68: SELECT CHR.CONTRACT_NUMBER
69: FROM okc_k_headers_b chr

Line 70: ,okl_txl_ap_inv_lns_all_b tpl

66: -- changes made as part of OKLR12B disbursements project
67: CURSOR c_num_csr ( p_id NUMBER ) IS
68: SELECT CHR.CONTRACT_NUMBER
69: FROM okc_k_headers_b chr
70: ,okl_txl_ap_inv_lns_all_b tpl
71: ,okl_xtl_pay_invs_all_b xlp
72: WHERE XLP.ID = p_id
73: AND XLP.tpl_id = TPL.id
74: AND TPL.khr_id = chr.id;

Line 78: -- sjalasut, modified code to refer khr_id from okl_txl_ap_inv_lns_all_b instead of okl_trx_ap_invoices_b

74: AND TPL.khr_id = chr.id;
75:
76:
77: -- XLP.tpl_id has tap_id
78: -- sjalasut, modified code to refer khr_id from okl_txl_ap_inv_lns_all_b instead of okl_trx_ap_invoices_b
79: -- changes made as part of OKLR12B disbursements project
80: /* rkuttiya commented this cursor as no longer required */
81: /* CURSOR c_fun_csr ( p_id NUMBER ) IS
82: SELECT CHR.CONTRACT_NUMBER

Line 85: ,okl_txl_ap_inv_lns_all_b tpl

81: /* CURSOR c_fun_csr ( p_id NUMBER ) IS
82: SELECT CHR.CONTRACT_NUMBER
83: FROM okc_k_headers_b chr
84: ,okl_trx_ap_invoices_b tap
85: ,okl_txl_ap_inv_lns_all_b tpl
86: ,okl_xtl_pay_invs_all_b xlp
87: WHERE XLP.XPI_ID_DETAILS = p_id
88: AND XLP.tap_id = TAP.id
89: AND tpl.tap_id = tap.id

Line 556: -- Note: okl_txl_ap_inv_lns_all_b.kle_id may be null, so the l_ship_to and l_inventory_item_id

552: CLOSE get_khr_id_csr;
553:
554:
555:
556: -- Note: okl_txl_ap_inv_lns_all_b.kle_id may be null, so the l_ship_to and l_inventory_item_id
557: -- may also null
558:
559: /*--07-May-2008 cklee -- Fixed bug:7015970
560: OPEN Ship_to_csr2( l_customer_id, l_install_location_id, l_location_id);

Line 704: ,'OKL_TXL_AP_INV_LNS_ALL_B'

700: ,r_invoice_lines.line_type
701: ,r_invoice_lines.org_id
702: ,r_invoice_lines.tax_code
703: ,fnd_global.prog_appl_id
704: ,'OKL_TXL_AP_INV_LNS_ALL_B'
705: ,r_invoice_lines.tpl_id
706: ,trim(substr(trim(substr(l_contract_number,1,100)) || '/' || trim(substr(l_asset_number,1,100)) || '/' || trim(substr(l_stream_type_purpose,1,38)), 1,240))
707: --start:| 03-May-2007 cklee -- Commented out OKL_PROCESS_SALES_TAX_PVT related code. |
708: