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_ITEMS

Line 145: okc_k_items cim,

141: CURSOR Ship_to_csr( p_top_kle_id IN NUMBER ) IS
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)

Line 163: okc_k_items cim,

159: , csi.location_id
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)

Line 255: okc_k_items c

251: SELECT c.OBJECT1_ID1,
252: c.OBJECT1_ID2 --21-Oct-2011 sechawla Bug 12888543 : added to get the inventory org id
253: FROM okc_k_lines_b a,
254: okc_line_styles_b b,
255: okc_k_items c
256: WHERE a.cle_id = p_cle_id
257: AND a.lse_id = b.id
258: AND b.lty_code = 'ITEM'
259: AND a.id = c.cle_id

Line 265: okc_k_items c

261: SELECT c.object1_id1,
262: c.OBJECT1_ID2 --21-Oct-2011 sechawla Bug 12888543 : added to get the inventory org id
263: FROM okc_k_lines_v a,
264: okc_line_styles_v b,
265: okc_k_items c
266: WHERE a.id = p_cle_id
267: AND a.lse_id = b.id
268: AND b.lty_code = 'SOLD_SERVICE'
269: AND c.cle_id = a.id;