APPS.OKL_AM_TERMNT_INTERFACE_PVT dependencies on OKX_ASSETS_V

Line 863: FROM OKX_ASSETS_V

859: AND okiv.object1_id1=oiiv.instance_id;
860: /* this cursor retrives the total quantity for the asset*/
861: CURSOR get_qty_csr(p_asset_number IN VARCHAR2) IS
862: SELECT current_units quantity
863: FROM OKX_ASSETS_V
864: WHERE asset_number = p_asset_number;
865:
866: BEGIN
867: x_tif_rec := p_tif_rec;

Line 1602: FROM OKX_ASSETS_V

1598: l_msg_tbl msg_tbl_type;
1599: /* this cursor retrives the total quantity for the asset*/
1600: CURSOR get_qty_csr(p_asset_number IN VARCHAR2) IS
1601: SELECT current_units quantity
1602: FROM OKX_ASSETS_V
1603: WHERE asset_number = p_asset_number;
1604: BEGIN
1605: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1606: IF(p_tif_tbl.COUNT>0)THEN