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:
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'
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'