APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on OKC_LINE_STYLES_B

Line 148: okc_line_styles_b lse

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
152: AND inst.lse_id = lse.id

Line 166: okc_line_styles_b lse

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
170: AND inst.lse_id = lse.id

Line 199: okc_line_styles_b lse1,

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
203: and hpsu.party_site_use_id = tii.object_id1_new

Line 200: okc_line_styles_b lse2

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
203: and hpsu.party_site_use_id = tii.object_id1_new
204: and tii.jtot_object_code_new = 'OKX_PARTSITE'

Line 254: okc_line_styles_b b,

250: CURSOR get_inv_item_id ( p_cle_id NUMBER ) IS
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'