42: asset_start_date DATE,
43: asset_end_date DATE,
44: asset_sts_code OKC_K_LINES_B.sts_code%TYPE,
45: date_terminated DATE,
46: asset_residual OKL_K_LINES.residual_value%TYPE,
47: khr_id NUMBER,
48: contract_number OKC_K_HEADERS_B.contract_number%TYPE,
49: product_id NUMBER,
50: vpa_id NUMBER,
1279: RET.retirement_id,
1280: RET.date_retired,
1281: CHR.scs_code -- rmunjulu 4622198
1282: FROM OKC_K_LINES_V CLE,
1283: OKL_K_LINES KLE,
1284: OKC_K_HEADERS_B CHR,
1285: OKL_K_HEADERS KHR,
1286: OKC_LINE_STYLES_V LSE,
1287: OKC_K_HEADERS_B VPA,