DBA Data[Home] [Help]

APPS.OKL_CONTRACT_INFO dependencies on OKC_K_ITEMS

Line 364: SELECT 'x' FROM okc_k_items cim

360: SELECT 'Y' FROM okc_k_headers_b chr
361: WHERE id = p_contract_id
362: AND EXISTS
363: (
364: SELECT 'x' FROM okc_k_items cim
365: WHERE cim.object1_id1 = to_char(chr.id)
366: AND EXISTS
367: (
368: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse

Line 1015: okc_k_items cim

1011: CURSOR asset_cost_csr IS
1012: SELECT SUM(fab.cost)
1013: FROM fa_additions_b faa,fa_books fab,okc_k_lines_b cle,
1014: okc_k_headers_b chr,okc_line_styles_b lse,
1015: okc_k_items cim
1016: WHERE faa.asset_id = fab.asset_id
1017: AND cim.object1_id2 = '#'
1018: AND cim.object1_id1 = faa.asset_id
1019: AND cim.jtot_object1_code = 'OKX_ASSET'