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 254: okc_k_items c

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
257: AND b.lty_code = 'ITEM'
258: AND a.id = c.cle_id

Line 263: okc_k_items c

259: UNION
260: SELECT c.object1_id1
261: FROM okc_k_lines_v a,
262: okc_line_styles_v b,
263: okc_k_items c
264: WHERE a.id = p_cle_id
265: AND a.lse_id = b.id
266: AND b.lty_code = 'SOLD_SERVICE'
267: AND c.cle_id = a.id;