DBA Data[Home] [Help]

APPS.AMS_ITEM_OWNER_PVT dependencies on OKC_K_LINES_B

Line 1422: FROM okc_k_lines_b cleb ,

1418: -- inanaiah: bug fix 5191150 - cleb.lse_id is a NUMBER so decode l_item_type
1419: CURSOR get_coverage_template(l_item_type varchar2)
1420: IS
1421: SELECT cleb.id id
1422: FROM okc_k_lines_b cleb ,
1423: okc_k_lines_tl clet
1424: WHERE cleb.chr_id < 0
1425: AND cleb.lse_id IN (2,15,65,66)
1426: AND clet.id = cleb.id