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 OKC_K_LINES_B

Line 131: FROM OKC_K_LINES_B kle

127: CURSOR c_top_line(p_tpl_id IN NUMBER) IS
128: SELECT NVL(kle.cle_id, kle.id) top_kle_id
129: , kle.dnz_chr_id khr_id
130: -- , try.name try_name -- cklee 06/19/2007
131: FROM OKC_K_LINES_B kle
132: , okl_txl_ap_inv_lns_b tpl
133: , okl_trx_ap_invoices_b tap
134: , okl_trx_types_v try
135: WHERE tpl.id = p_tpl_id

Line 146: okc_k_lines_b inst,

142: SELECT csi.install_location_id
143: , csi.location_id
144: FROM csi_item_instances csi,
145: okc_k_items cim,
146: okc_k_lines_b inst,
147: okc_k_lines_b ib,
148: okc_line_styles_b lse
149: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
150: AND cim.cle_id = ib.id

Line 147: okc_k_lines_b ib,

143: , csi.location_id
144: FROM csi_item_instances csi,
145: okc_k_items cim,
146: okc_k_lines_b inst,
147: okc_k_lines_b ib,
148: okc_line_styles_b lse
149: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
150: AND cim.cle_id = ib.id
151: AND ib.cle_id = inst.id

Line 164: okc_k_lines_b inst,

160: , csi.install_location_type_code
161: -- , csi.location_type_code
162: FROM csi_item_instances csi,
163: okc_k_items cim,
164: okc_k_lines_b inst,
165: okc_k_lines_b ib,
166: okc_line_styles_b lse
167: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
168: AND cim.cle_id = ib.id

Line 165: okc_k_lines_b ib,

161: -- , csi.location_type_code
162: FROM csi_item_instances csi,
163: okc_k_items cim,
164: okc_k_lines_b inst,
165: okc_k_lines_b ib,
166: okc_line_styles_b lse
167: WHERE csi.instance_id = TO_NUMBER(cim.object1_id1)
168: AND cim.cle_id = ib.id
169: AND ib.cle_id = inst.id

Line 197: okc_k_lines_b cleb_ib,

193: from hz_locations hl,
194: hz_party_sites hps,
195: hz_party_site_uses hpsu,
196: okl_txl_itm_insts tii,
197: okc_k_lines_b cleb_ib,
198: okc_k_lines_b cleb_inst,
199: okc_line_styles_b lse1,
200: okc_line_styles_b lse2
201: where hl.location_id = hps.location_id

Line 198: okc_k_lines_b cleb_inst,

194: hz_party_sites hps,
195: hz_party_site_uses hpsu,
196: okl_txl_itm_insts tii,
197: okc_k_lines_b cleb_ib,
198: okc_k_lines_b cleb_inst,
199: okc_line_styles_b lse1,
200: okc_line_styles_b lse2
201: where hl.location_id = hps.location_id
202: and hps.party_site_id = hpsu.party_site_id

Line 252: FROM okc_k_lines_b a,

248: --Get the inventory for a financial asset line or service line.
249: --A line can either be a fin asset or service line
250: CURSOR get_inv_item_id ( p_cle_id NUMBER ) IS
251: SELECT c.OBJECT1_ID1
252: FROM okc_k_lines_b a,
253: okc_line_styles_b b,
254: okc_k_items c
255: WHERE a.cle_id = p_cle_id
256: AND a.lse_id = b.id