APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on CSI_ITEM_INSTANCES

Line 144: FROM csi_item_instances csi,

140: /*
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

Line 162: FROM csi_item_instances csi,

158: SELECT csi.install_location_id
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

Line 242: l_install_location_type_code csi_item_instances.install_location_type_code%type; -- 07-May-2008 cklee -- Fixed bug:7015970

238: l_top_kle_id NUMBER;
239: l_khr_id NUMBER;
240: l_install_location_id NUMBER;
241: l_location_id NUMBER;
242: l_install_location_type_code csi_item_instances.install_location_type_code%type; -- 07-May-2008 cklee -- Fixed bug:7015970
243: l_customer_id NUMBER;
244: l_sts_code okc_k_headers_all_b.sts_code%type; -- 07-May-2008 cklee -- Fixed bug:7015970
245: l_ship_to NUMBER;
246: l_try_name okl_trx_types_v.name%type;