DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_COMP_PVT dependencies on OKC_LINE_STYLES_B

Line 489: okc_line_styles_b lse

485: --chk for asset on asset line
486: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS
487: SELECT 'Y'
488: FROM okl_k_lines_full_v kle,
489: okc_line_styles_b lse
490: WHERE kle.name = p_asset_number
491: AND kle.lse_id = lse.id
492: AND lse.lty_code = 'FIXED_ASSET';
493:

Line 784: ,okc_line_styles_b lseb

780: ,trxa.date_trans_occurred
781: FROM okl_trx_assets trxa
782: ,okl_txl_assets_b txla
783: ,okc_k_lines_b cleb
784: ,okc_line_styles_b lseb
785: WHERE txla.kle_id = cleb.id
786: AND cleb.lse_id = lseb.id
787: AND lseb.lty_code = 'FIXED_ASSET'
788: AND txla.tal_type = 'ALI'

Line 1272: ,okc_line_styles_b lseb

1268: ,trxa.date_trans_occurred
1269: FROM okl_trx_assets trxa
1270: ,okl_txl_assets_b txla
1271: ,okc_k_lines_b cleb
1272: ,okc_line_styles_b lseb
1273: WHERE txla.kle_id = cleb.id
1274: AND cleb.lse_id = lseb.id
1275: AND lseb.lty_code = 'FIXED_ASSET'
1276: AND txla.tal_type = 'ALI'