DBA Data[Home] [Help]

APPS.OKL_CONTRACT_INFO dependencies on OKC_K_LINES_B

Line 368: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse

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
369: WHERE cle.lse_id = lse.id
370: AND lse.lty_code = 'SHARED'
371: AND cle.id = cim.cle_id
372: )

Line 1013: FROM fa_additions_b faa,fa_books fab,okc_k_lines_b cle,

1009:
1010: -- Get total Asset Cost
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 = '#'