APPS.OKL_RELEASE_PVT dependencies on OKX_ASSET_LINES_V

Line 1413: -- Description : validation with OKX_ASSET_LINES_V and OKL_ASSET_RETURNS_V

1409: -----------------------------------------------------------------------------------------------
1410: -- Start of Commnets
1411: -- Badrinath Kuchibholta
1412: -- Procedure Name : Validate_offlease_asset
1413: -- Description : validation with OKX_ASSET_LINES_V and OKL_ASSET_RETURNS_V
1414: -- Business Rules : We first need to get the parent line id and
1415: -- Asset number of the old contract number.
1416: -- And Now the check the top_line_id present in OKL_ASSET_RETURNS_V
1417: -- which significe that the asset are off lease and ready for release

Line 1419: -- Again we now check Asset number against OKX_ASSET_LINES_V to make sure

1415: -- Asset number of the old contract number.
1416: -- And Now the check the top_line_id present in OKL_ASSET_RETURNS_V
1417: -- which significe that the asset are off lease and ready for release
1418: --
1419: -- Again we now check Asset number against OKX_ASSET_LINES_V to make sure
1420: -- asset number are not in lease with any other conract by looking for
1421: -- status of that line as TERMINATED , EXPIRED etc....
1422: -- Parameters : 1.P_dnz_chr_id Old Contract id
1423: -- Version : 1.0

Line 1447: FROM okx_asset_lines_v

1443: IS
1444: SELECT 1
1445: FROM dual
1446: WHERE EXISTS (SELECT '1'
1447: FROM okx_asset_lines_v
1448: WHERE asset_number = p_asset_number
1449: AND line_status not in ('EXPIRED','TERMINATED','ABANDONED'));
1450:
1451: BEGIN