APPS.OKL_RELEASE_PVT dependencies on OKX_ASSET_LINES_V

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

1430: -----------------------------------------------------------------------------------------------
1431: -- Start of Commnets
1432: -- Badrinath Kuchibholta
1433: -- Procedure Name : Validate_offlease_asset
1434: -- Description : validation with OKX_ASSET_LINES_V and OKL_ASSET_RETURNS_V
1435: -- Business Rules : We first need to get the parent line id and
1436: -- Asset number of the old contract number.
1437: -- And Now the check the top_line_id present in OKL_ASSET_RETURNS_V
1438: -- which significe that the asset are off lease and ready for release

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

1436: -- Asset number of the old contract number.
1437: -- And Now the check the top_line_id present in OKL_ASSET_RETURNS_V
1438: -- which significe that the asset are off lease and ready for release
1439: --
1440: -- Again we now check Asset number against OKX_ASSET_LINES_V to make sure
1441: -- asset number are not in lease with any other conract by looking for
1442: -- status of that line as TERMINATED , EXPIRED etc....
1443: -- Parameters : 1.P_dnz_chr_id Old Contract id
1444: -- Version : 1.0

Line 1468: FROM okx_asset_lines_v

1464: IS
1465: SELECT 1
1466: FROM dual
1467: WHERE EXISTS (SELECT '1'
1468: FROM okx_asset_lines_v
1469: WHERE asset_number = p_asset_number
1470: AND line_status not in ('EXPIRED','TERMINATED','ABANDONED'));
1471:
1472: BEGIN