DBA Data[Home] [Help]

APPS.OKL_AM_PROCESS_RV_TRX_PVT dependencies on OKC_K_HEADERS_B

Line 166: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l, okc_k_headers_b khr

162: CURSOR l_assettrx_csr(p_sysdate DATE) IS
163: SELECT h.id, h.tas_type, date_trans_occurred, depreciate_yn, dnz_asset_id, corporate_book, in_service_date,
164: deprn_method,life_in_months, nvl(depreciation_cost,0) depreciation_cost , asset_number, old_residual_value,
165: new_residual_value, kle_id, dnz_khr_id, contract_number, sts_code
166: FROM OKL_TRX_ASSETS h, okl_txl_assets_v l, okc_k_headers_b khr
167: WHERE h.id = l.tas_id
168: AND h.tsu_code NOT IN ('PROCESSED')
169: AND h.tas_type = 'ARC'
170: AND khr.id = l.dnz_khr_id